Open ticket extraction

[fleche]

Hello,

I would like to do a php/sql call from my intranet to the mantis database to retrieve the current number of open tickets.
I can't find anything that screams "resolved ticket" or similar to query.

There are two fields called Status and Resolution that have codes in them. Could one of those be "resolved", like Status 10 = resolved?

Any help would be great.

Thanks

[cas]

Here are the values of the status field:
$g_status_enum_string = '10:new,20:feedback,30:acknowledged,40:confirmed,50:assigned,80:resolved,90:closed';

Most of those values you can find back config_defaults_inc.php which you can find in the root of your installation.
Do not make changes to this file, if needed make the changes in config/config_inc.php.