filters for qlik license consumption ls

[matteoredaelli]

Hello

Which filters can I use for

   filters for qlik license consumption ls

I cannot find any info at

  https://qlik.dev/toolkits/qlik-cli/license/license-consumption-ls/

I'd' like to filter for endTime and LicenseUsage

but I get

```

qlik license consumption ls --filter 'licenseUsage eq "ASSIGNED_LICENSE"'

Error: {
"error": "LICENSES-InternalServerError",
"message": "could not convert filter, expression is invalid: unsupported attribute received: licenseusage",
"errors": [
{
"code": "LICENSES-037",
"title": "could not convert filter, expression is invalid: unsupported attribute received: licenseusage"
}
]
}

[jprdonnelly]

@matteoredaelli - it appears that the endpoint does not support filtering with the licenseUsage attribute, though it does work with endTime.

qlik license consumption ls --filter 'endTime ge "2023-11-21T18:21:51.635Z"'

Another option would be to parse using PowerShell or jq to help isolate the values

qlik license consumption ls --raw | jq '.data[].licenseUsage'

[DaveChannon]

For future reference, you should be able to tell which fields are filterable by looking for filterable in the response property list (note filterable is tagged only against endTime) on https://qlik.dev/apis/rest/licenses/#%23%2Fdefinitions%2FconsumptionEventsResponse 

[matteoredaelli]

Many thanks!

[matteoredaelli]

Hello 

I can see the "filtrable" text from your screenshot but I cannot find it following the link you shared...

Regards

Matteo

[DaveChannon]

You might need to follow the link and then Ctrl+F in the browser. We currently have a problem with qlik.dev which isn't taking you to deep links correctly (sorry!). Or search for consumptionEventsResponse and go from there.