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.
See Item types for more information.
|<date/time expression>|| jKQL 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.
|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.|