I am getting error "Invalid index: Cannot index property 'crProductLimitCode_int' of type Text into type DataSubset" ,Can anyone suggest on this?
Discussion posts and replies are publicly visible
Can you give us more context?First thought: you have a local likelocal!datasubsetand you try to adress there "crProductLimitCode_in" with dot notation example: local!datasubset.crProductLimitCode_in-> this isnt working as the parameters of a datasubset are"startIndex, batchSize, sort, totalCount, data, identifiers"https://docs.appian.com/suite/help/22.1/fnc_system_a_datasubset.html
If you're trying to get this data via a!queryEntity() or similar methods, you will need to get the ".data" property from the query results before getting entity-specific properties. That would look like "local!dataSubset.data.crProductLimitCode_in".
However please be aware that if the query returns zero rows for whatever reason, the "data" subcomponent won't have any named properties and using dot notation would break in that case. Here we could handle it by expanding it slightly to use the property() function to get the property safely, like: "property(local!dataSubset.data, "crProductLimitCode_in", null())", which will safely return a NULL value if the query returned zero data rows.
haha your are absolutly right. It is the addition I was to lazy about to add. My Bad