• State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 12 subscribers
  • Views 3609 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

Casting Issue on dataset

sauravk

Hi,

 

I am trying to pass one dataset in appyComponent() to another interface and trying to filter that database on some conditions.

 

But getting below error.

 

local!dataset: index(ri!fulldatasubset,wherecontains(ri!testName[ri!index],ri!fulldatasubset.data.testName)),
local!datasubset: todatasubset(
local!dataset.data,
local!gridSelection.pagingInfo
),

Error :

 

Could not display interface. Please check definition and inputs.

Interface Definition: Expression evaluation error at function 'wherecontains' parameter 2 [line 39]: Invalid index: Cannot index property 'data' of type Text into type "(fulldatasubset)Type of Dataset".

 

Can someone help me on this what can i do on this ??

 
 
 

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 1
    Hi sauravk,

    As per my understanding wherecontains() parameters must be of same type .It is not possible to search a different array with an agument of type integer.As text values are case-sensitive,this function is used in finding the items in a array which have thes= same value for a field.So in your case the same reflects i.e, index(ri!fulldatasubset,wherecontains((ri!testName[ri!index],tostring(ri!fulldatasubset.data.testName))).Try with that once.
Reply
  • 0
    A Score Level 1
    Hi sauravk,

    As per my understanding wherecontains() parameters must be of same type .It is not possible to search a different array with an agument of type integer.As text values are case-sensitive,this function is used in finding the items in a array which have thes= same value for a field.So in your case the same reflects i.e, index(ri!fulldatasubset,wherecontains((ri!testName[ri!index],tostring(ri!fulldatasubset.data.testName))).Try with that once.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.