Your help will be very appreciated.
In DESIGN mode of Designer, today the Interface shows:
Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = INH9G] : Cannot compare incompatible operands of type Lista de nulos and type Número (entero).
(I don't know why sometimes is full in English and now partially in Spanish. I have always worked in English.)
Yesterday I made several combinations using and not using rule expressions, declaring local variales that didn't show in the right pane and putting the filter of idType = 1 just below the recordType: parameter and the null and not null owner field filters in their corresponding measure. Also, I tried moving the idType = 1 filter to each filter parameter of measure. The objective is to count the owned assets (not null) and to count the available assets to assign (null) for workstations (idType = 1). owner is User and idType is Integer.
Yesterday the query calculated both aliases but today show the message.
a!queryRecordType( recordType: 'recordType!{e2812b2c-0980-4e9d-a0ec-e460e8561a1e}W2692AIM Asset', fields: a!aggregationFields( measures: { a!measure( field: 'recordType!{e2812b2c-0980-4e9d-a0ec-e460e8561a1e}W2692AIM Asset.fields.{900801bb-7da6-437d-bb94-86b7ae449362}id', function: "COUNT", alias: "ownedCounter", filters: { a!queryFilter( field: 'recordType!{e2812b2c-0980-4e9d-a0ec-e460e8561a1e}W2692AIM Asset.fields.{700cd7bb-61df-4eb8-9be5-0330712d7bed}owner', operator: "not null" ), a!queryFilter( field: 'recordType!{e2812b2c-0980-4e9d-a0ec-e460e8561a1e}W2692AIM Asset.fields.{fc21a018-e8f0-4e15-bee1-22491a44fca9}typeId', operator: "=", value: 1 ) } ), a!measure( field: 'recordType!{e2812b2c-0980-4e9d-a0ec-e460e8561a1e}W2692AIM Asset.fields.{900801bb-7da6-437d-bb94-86b7ae449362}id', function: "COUNT", alias: "availCounter", filters: { a!queryFilter( field: 'recordType!{e2812b2c-0980-4e9d-a0ec-e460e8561a1e}W2692AIM Asset.fields.{700cd7bb-61df-4eb8-9be5-0330712d7bed}owner', operator: "is null" ), a!queryFilter( field: 'recordType!{e2812b2c-0980-4e9d-a0ec-e460e8561a1e}W2692AIM Asset.fields.{fc21a018-e8f0-4e15-bee1-22491a44fca9}typeId', operator: "=", value: 1 ) } ) } ), pagingInfo: a!pagingInfo(1, 500)
).data
Do you know why this behavior and how can I fix it?
Discussion posts and replies are publicly visible
Are you sure that no one deleted data from your record source?
Thanks to all the 4 of you for you help.
I wanted to publish the code of the interface but something in the filter say that was spam and I appealed but it didn't answer.
So, I put the query and the chart together in the interface and review the way I was using variables, aliases, ri!s and indexes. It worked.
Query with grouping outputs maps with the counters..
Thanks agains for your rapid response.