Sort on LastModif?
I was using TRACKERLIST to make some 'simple' reports from a tracker I made. The tracker is a to-do list. I can list the to-do items easily, and sort that by the priority. In a second report I want to list the last 5 items I set to 'complete'. I figured that the items with a status of Closed and with the most recent lastModif would be all I need for my purposes. That is, show 5 items with the most recent lastModif that have Closed status.
I can list the fields I want, but I can't seem to sort by lastModif. The problem seems to stem from the fact that the lastModif is not a field I created and does not have a numeric ID. I tried using the column name as it appears in the URL (determined by manually clicking the lastModif column header on the page where the report displays). That shows as: tr_sort_mode2=lastModif_asc. The trackerlist parameter is "sort_mode=", so I was pretty sure it wouldn't work. I tried it both as tr_sort_mode2=lastModif_asc and sort_mode=lastModif_asc
Here is what I have set up in the plugin:
trackerlist trackerId="4" fields="23:11:16:17" showstatus="y" status="c" max="5" showpagination="y"
23 = priority, 11 = item, 16 = subitem, 17 = Description
in the tracker, "Show lastModif date when listing tracker items?" is checked, so the LastModif displays in the result.
The result is fine, except the sorting issue, which ends up making the 5 items useless unless I manually click the lastModif to sort.
QUESTIONS:
1) is there a way to convert lastModif to a colum with an ID in the tracker?
2) is there a way to name lastModif as the sort_mode= item?
3) is there another solution I am not considering?