CCMDB Wiki

TISS Item List: Difference between revisions

Created page with "{{#ask:Category: TISS28 Item |?# | ?TISS28 Row Number | ?TISS28 Description | ?TISS28 Points | ?TISS28 Item Numbere.g. 1) | ?TISS28 Comment | ?Modification date |format=b..."
 
mNo edit summary
 
(39 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{#ask:[[Category: TISS28 Item]]  
This is a list of data elements collected as part of [[TISS28]] according to [[TISS28 Collection Guide]].
|?#
 
| ?TISS28 Row Number
{{#cargo_query:
| ?TISS28 Description
tables=TISS_Items,
| ?TISS28 Points
|fields=CONCAT('[[:', Category, '|', SUBSTRING(Category, 20), ']]') = TISS Category, ItemNumber = Item Number, _pageName = Item, Description, Points, ItemNumber = Item Number, Comment, StartDate= Start Date
| ?TISS28 Item Numbere.g. 1)
|where=StartDate<CURRENT_DATE AND CURRENT_DATE<EndDate
| ?TISS28 Comment
|order by=Item Number
| ?Modification date
|format=dynamic table
|format=broadtable
|rows per page=100
|link=all
|limit=100
|limit=0
|headers=show
|class=sortable wikitable smwtable
}}
}}
== TISS items not currently collected ==
{{Collapsable
| always= click expand to see TISS items not currently collected
| full= 
{{#cargo_query:
tables=TISS_Items,
|fields=CONCAT('[[:', Category, '|', SUBSTRING(Category, 20), ']]') = TISS Category, RowNumber= Row number, _pageName = Item, Description, Points, Comment, StartDate= Start Date, EndDate = End date
|where=StartDate>CURRENT_DATE or CURRENT_DATE>EndDate
|order by=Row number
|format=dynamic table
|limit=100
|rows per page=100
}}
}}
==Related articles ==
{{Related Articles}}
[[Category:TISS28| *]]
[[Category:TISS wiki infrastructure]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=TISS_Item_List"