The Get statement is used for retrieving items from the database, or for querying jKQL information. Below are examples of queries using the Get statement.
Definition |
Query Statement |
To get default fields for all Activity items |
jKQL> Get Activities |
To get all fields for all Activity items in Set “Purchasing” |
jKQL> Get Activity Fields All from 'Purchasing' |
To get the number of Activity items in Set “Purchasing” |
jKQL> Get number of Activities from 'Purchasing' |
To get the number of Activity items in Set “Purchasing” that started today |
jKQL> Get number of Activities from 'Purchasing' for today |
To get the percentage of all Activity items in Set “Purchasing” that started today |
jKQL> Get percent of Activities from 'Purchasing' for today |
To get the 10 longest running Activities in Set “Purchasing” that started today |
jKQL> Get top 10 Activities from 'Purchasing' for today sort by ElapsedTime desc |
To get the number of Activities in "Payment" last week grouped by their start time |
jKQL> Get number of Activities from Payment for last week group by starttime |
To get the number of Activities in Set “Purchasing” for each Activity status for the last week |
jKQL> Get number of Activities from 'Purchasing' for last week group by Status |
To get the number of Activities in Set “Purchasing” that have the value “Order” (case insensitive) in any field |
jKQL> Get number of Activities from 'Purchasing' for last week containing 'Order' |
To get the number of Activities in Set “Purchasing” that have the values “Order” or 12345 (case insensitive) in any field |
jKQL> Get number of Activities from 'Purchasing' for last week containing 'Order',12345 |
To get the number of Activities in Set “Purchasing” that have the values “Order” and 12345 (case insensitive) in any field (the values do not have to be in the same field) |
jKQL> Get number of Activities from 'Purchasing' for last week containing all of 'Order',12345 |
To get the number of Activities in Set “Purchasing” that met all objectives |
jKQL> Get number of Activities from 'Purchasing' that met all objectives |
To get the number of Activities in Set “Purchasing” that did not meet some objectives |
jKQL> Get number of Activities from 'Purchasing' that have not met all objectives |
To get the number of Activities in Set “Purchasing” that did not meet objectives “A” and “B” |
jKQL> Get number of Activities from 'Purchasing' that have not met objectives 'A','B' |
To get Activities in Set “Purchasing” that did not meet objectives “A” and “B” from set “Web Purchases” |
jKQL> Get Activities from 'Purchasing' that have not met objectives 'A','B' from 'Web Purchases' |