Search the Community
Showing results for tags 'where'.
In order to undertake more complex measures and to be able or retrospectively regenerate them, can we request an enhancement to be able to insert the 'Date Ranging Column' start and end date/time stamps in the 'Query where clause'. For example we want to set a measure that obtains the number of open requests at the end of a period, so we would do a count on requests where the Data Logged is before the end of the period and the date closed is null or after the end of the period. Cheers Martyn
We run multiple service desk with a large number of different SLA which means when amalgamating performance measures to give his an overall picture we require very complex where clauses. Consequently we are hitting the UI limit of entering more the 1024 characters in the 'Query where clause' field. Can this be extended to accommodate more complex criteria. Cheers Martyn