Page 1 of 1

how to update different projects configurations in all_pro

Posted: 23 Feb 2016, 15:44
by Anapheron
I have customized my mantis with a column that calculates the days since the bug has been issued until it reaches a selected bug status (it may be closed, resolved, acknowleged, it depends on your decision in manage_config_workflow_page.php), then it stops counting (they do not go back to zero, just stop counting the days), but i have problems because when i select all projects, the configuration of all_projects start to run, not the configuration of each project.

Any ideas?
sorry for my horrible english.
thanks :D

Re: how to update different projects configurations in all_p

Posted: 14 Mar 2016, 16:10
by cas
What is the problem here? It does it for all individual bugs.
Perhaps the problem is your calculation. You should be able to capture this in the query select statement such that it has hardly impact on performance.
It should be something like round((unix_timestamp-date_submitted)/(3600*24)) as NumberOfDays :mrgreen: