While I don’t have the full details about the fields in the database, based on some quick analysis, it seems like the ACTION_STATE_HISTORY table contains all the necessary data. As you suggested, in particular the ‘State’ field is of interest as it appears to contain an action status (in your example above :s=Waiting). Version 9 introduced native sqlite inspectors, and so the following relevance appears to provide some useful information:
(“ActionID”, “Last Action Time”, “Status”);((preceding text of first “:” of following text of first “:id=” of (it as string) as string, (preceding text of first “:” of following text of first “:lat=” of (it as string) as integer * second + (“01 Jan 1970 00:00:00” as local time)) as string, preceding text of first “:” of following text of first “:s=” of (it as string) as string) of (rows of statement “select yt.ActionID, yt.TotalActiveCount, yt.State from ACTION_STATE_HISTORY yt inner join (select ActionID, max(TotalActiveCount) TotalActiveCount from ACTION_STATE_HISTORY group by ActionID) ss on yt.ActionID = SS.ActionID and yt.TotalActiveCount = SS.TotalActiveCount” of sqlite database of file “ActionHistory.db” of folder “__Global” of data folder of client))
Can you give this a try and let us know if returns the data of interest?