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
Most probably the issue is not with the query somewhere in your interface code you are trying to compare a list with integer because of that you are getting this error for better understanding please share the code snippet for interface.
MarioB
Not sure if the issue is with the expression rule. This might be an issue with your interface code where you might be comparing two incomparable variables against each other. Please share the interface code snippet.
hi ,MarioB Guessing that would be a casting error from the list to a single type. could you post your code please for better debugging?
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.