The syntax of a jKQL query should appear as follows (required elements are bold):
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:
| Query Element | Expression |
|---|---|
| <action> | Get, Subscribe to, Compare, Find |
| <numeric_expression> | Specify any number of data items to be included in the 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 forms of expressions, for example, Activity / Activities. 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, for example, Year / Years. 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, for example, 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, for example, yesterday at 9 am. |
| <comparison_operator> |
|
|
<result_grouping_modifier>
|
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. For example: Show as barchart The default is ‘Show as table’ |