Mantis Bug Tracker - Forums

I wish to count how much time that bug has been on that status

can anyone help?

Hello,

I have an problem when defining a custom field which is "Required on Resolve" and a custom status whose value is higher than assinged, 60 to be precise, but lower than resolved. When I want to set an issue to the custom status I always get the error that the custom field has to be filled ...

To answer without guessing, I need to understand clearly what you need to ger. Is it time that issue was in 'assigned' state, or in all 'open' states, or in selected particular states? Do you need to see same for issues, which are 'new'? If issue is resolved, but then reopened, do you continue ...

i'm thinking about searching for the last history update, get its date_modified value (which is in unix timestamp), convert into days and putting as old_value of the new history update
what do you think?

OK, I understand. So you will need to iterate through status changes from the history table and depending on old/new status add/subtract corresponding dates. Please have a look at core/history_api.php --> it has plenty of useful functions. For example history_get_events_array, history_get_raw ...

I see. This should work, although doesn't sound like elegant solution. :-) One question - why do you want to record time updates in history log?

Well, i have turned off that dynamic update, i can only update by changing the bug status

I need that old_value because i want to "turn back" the days ...

I must say I don't like whole approach because you time will get updated only on action happening with bug. If no action it will show outdated value...

I have called that function in view_all_bug_page.php, view.php, and my_view_page.php before just to give a "dynamic" update, but i'm trying ...

aavagyan wrote:If you went in the direction of creating function writing to DB, then you can also write to history table, I guess. The structure of history table is very simple.

I thought that too, but when i get the old_value, it returns 0, not the same value if i execute the query directly on MySQL

i have created a function that update the custom field in DB
each time i call it, it updates the custom field.

Oh, and my mantis version is 1.2.19

Hi, everyone!
I have a question (i'm kinda of a apprentice on mantis, sorry about that)
i have created a custom field that count the days since that bug has been opened, but i want to update that custom field each time i change the bug status (Open -> Acknowledged, for example)
i haven't configure ...

It puts the value normally in history log, but i need to put a value in the custom field text area
i wish to get the value in history log without needing a custom field text area
any ideas?

I have wrote a query that inserts into the mantis_bug_history_table correctly, but i can't take the old_value

so it goes 0----->30

any ideas to get the old_value?
thanks!

I have created a custom field called "Days"
I figured how to use it to count every day it has passed since that bug is opened, depending on status (for example: if the status is closed, then the day count will stop (it dont go to zero, just stop counting), if it is re-opened, the day count will ...

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 ...