Casesummary-table: Difference between revisions
No edit summary |
(GROUP BY) |
||
| Line 9: | Line 9: | ||
|join on=_pageData._pageName = Cases._pageName | |join on=_pageData._pageName = Cases._pageName | ||
|fields=_pageData._pageTitle=Casename, _pageData._creationDate=Created, _pageData._categories__full=Categories | |fields=_pageData._pageTitle=Casename, _pageData._creationDate=Created, _pageData._categories__full=Categories | ||
|group by=_pageData._pageTitle, _pageData._creationDate, _pageData._categories__full | |group by=_pageData._pageTitle, _pageData._creationDate, _pageData._categories__full, _pageData._creationDate__precision | ||
|where=Cases.Subject HOLDS '{{{c}}}' OR _categories HOLDS '{{#replace:{{{c}}}| |_}}' | |where=Cases.Subject HOLDS '{{{c}}}' OR _categories HOLDS '{{#replace:{{{c}}}| |_}}' | ||
|limit={{#if:{{{limit|}}} | {{{limit|}}} | 200}} | |limit={{#if:{{{limit|}}} | {{{limit|}}} | 200}} | ||