TISS Item List: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=TISS_Items, | tables=TISS_Items, | ||
|fields=CONCAT('[[:', Category, '|', SUBSTRING(Category, 20), ']]') = TISS Category, RowNumber= Row number, _pageName = Item, Description, Points, ItemNumber = Item Number, Comment, StartDate= Start Date | |fields=CONCAT('[[:', Category, '|', SUBSTRING(Category, 20), ']]') = TISS Category, RowNumber= Row number, _pageName = Item, Description, Points, ItemNumber = Item Number, Comment, StartDate= Start Date | ||
|where=StartDate<CURRENT_DATE AND CURRENT_DATE<EndDate | |where=StartDate<CURRENT_DATE AND CURRENT_DATE<EndDate | ||
|order by=Row number | |order by=Row number | ||