Hi All, I'm trying to use a Query Entity and Configured some basic field, Wh

deepanc712 over 11 years ago

Hi All, I'm trying to use a Query Entity and Configured some basic field, While I try to execute the attached code I'm being alerted with "Interface Definition: Expression evaluation error [line 21]: Invalid index: Cannot index property 'TrialName' of type Text into type List of Variant".
I've used cast function with .data but not able to reach the resolution. suggestions Aprreciated...

query.txt

Discussion posts and replies are publicly visible

0 radhaa over 11 years ago

Hi deepanc, I didn't find any flaws or mistakes in your code. but please confirm, are you using outcome of this query entity in any other expression rule?
If one is there, please provide that rule. Please try index function rather than data.TrailName[1] like attached code.
query.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deepanc712 over 11 years ago

Am currently not using this in any expression rules,

Tried to add index but getting the following alert. can you please look into it.
Interface Definition: Expression evaluation error at function 'type!{www.appian.com/.../2009}ColumnLayout' [line 21]: An array of components may only contain components. Received Text at index 1.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 radhaa over 11 years ago

deepanc, "invalid index: Cannot index property 'TrialName' of type Text into type List of Variant", this error arises because of there is no data retrieved for that query. if you can see the data structure of the query entity without tagging data.Trail_Name in bottom of the expression, you can see empty result in data column.
so please check null handling before referencing CDT columns with "."
And I will look into the error you mentioned in comments.
Correction.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deepanc712 over 11 years ago

Changed the function to IsNull and this works !!! Thanks Radhaa
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 radhaa over 11 years ago

deepanc, please see the attached code once, is that second error is arises due to wrong sail code of query column embedded in column layout. I guess this is the only choice to get that error. Please confirm this
Query_Mistakes.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deepanc712 over 11 years ago

Yes, It was..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deepanc712 over 11 years ago

Interface Definition: Not a valid component. Am getting this error before the result.. Any Idea
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 radhaa over 11 years ago

query entity returns data means TrailName. it is a text value not a sail component. so that's the reason you get that error. use SAIl components to show the query entity results such as grid field, tempo reports and etc., in your case you are retrieving single column, so place that data in local variable and show it in text field component.
See these links forum.appian.com/.../Grid_Tutorial.html,
forum.appian.com/.../Query_Recipes.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel