The syntax of a jKQL query should appear as follows (required elements are bolded):
jKQL > < action> <numeric expression> <limiting operator> <item type> <date/time expression> <comparison operator> <result grouping modifier> <viewlet chart type>
Compose a jKQL query from the following elements to produce a viewlet:
|<action>||Get, Subscribe to, Compare, Find|
|<numeric expression>||Specify any number of data items, which should be included in a viewlet – 5, 8, 10, etc.|
|<limiting expression>||These operators limit the query results. If the number of items, to which the limits will be set was not specified, the default number will be “1”.
Best, Bottom, Earliest, First, Largest, Last, Latest, Longest, Shortest, Smallest, Top, Worst
|<item type>||jKQL recognizes singular or plural form of the expression, i.e. Activity / Activities, so both forms are valid to use.
Activity, Event, Snapshot, Source, Resource, Set, Relative, Field, Provider, Action, Trigger, Log, Function, Repository, Team, Organization, User, Parameter, License
Expressions ‘Count of’ or ‘Number of’ can be added before item type names.
|<date/time expression>|| j KQL recognizes singular or plural expression forms, i.e. Year / Years, so both forms are valid to use.
Year, Month, Week, Day, Hour, Minute, Second, Millisecond, Microsecond
These date and time expressions can be combined with numbers and limiting operators, i.e. last 5 years, latest 3 weeks and so on. Below is a list of date and time limiting operators:
Last, Next, Latest, Earliest, This, Today, Yesterday, Tomorrow
An exact time value can be added for certain time expressions, i.e. yesterday at 9 am.
|<comparison operator>||Starts with all / any of <listed items> | Does not start; Matches all / any / none of <listed items> | Does not match; Contains all / any / none of <listed items> | Does not contain; Ends with all / any / none of <listed items>| Does not end; Is (=) | Is not (!= or <>) in <list of items>; Has all / any / none of <listed items> | Does not have; Between | Not between; > or >= – greater than or equal to specified expression; < or <= – less than or equal to specified expression|
|Group by; Sort by; Order asc / desc (ascending / descending); Bucketed by|
|<viewlet chart type>||'Show as' expression must be used before specifying the chart type. ‘Show as table’ is the default.|