CCMDB Wiki

TISS Item List: Difference between revisions

← Older edit
mNo edit summary
mNo edit summary
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This is a list of data elements collected as part of [[TISS28]] according to [[TISS28 Collection Guide]].  
This is a list of data elements collected as part of [[TISS28]] according to [[TISS28 Collection Guide]].  


{{#ask:[[Category: TISS28 Item]]  
{{#cargo_query:
| mainlabel=-
tables=TISS_Items,
| ?TISS28Category = Category
|fields=CONCAT('[[:', Category, '|', SUBSTRING(Category, 20), ']]') = TISS Category, ItemNumber = Item Number, _pageName = Item, Description, Points, ItemNumber = Item Number, Comment, StartDate= Start Date
| ?TISS28RowNumber = Row#
|where=StartDate<CURRENT_DATE AND CURRENT_DATE<EndDate
| ?
|order by=Item Number
| ?TISS28Description = Description
|format=dynamic table
| ?TISS28Points = Points
|rows per page=100
| ?TISS28ItemNumber = Item#
|limit=100
| ?TISS28Comment = Comment
}}
|format=broadtable
 
|sort=TISS28RowNumber
== TISS items not currently collected ==
|link=all
{{Collapsable
|limit=500
| always= click expand to see TISS items not currently collected
|headers=show
| full=
|class=sortable wikitable smwtable
{{#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
}}
}}
}}


Retrieved from "https://ccmdb.kuality.ca/index.php?title=TISS_Item_List"