Skip to main content
August 30, 2021
Question

How to Filter data from Rule input with is of type cdt ?

  • August 30, 2021
  • 5 replies
  • 1 view

How to Filter data from Rule input with is of type cdt ?  for example ri!Questions is of type cdt where i want the only data with active =1 , ri! questions contiains active 0 and 1 data both.

5 replies

August 30, 2021

I can do with the query rule but want to filter from ri

acaciob0002
August 31, 2021

Hi there,

Have you tried index?

index(ri!Questions, wherecontains(true(),ri!Questions.active),null),

Hope that helps

Acacio B.

ravir0002
August 31, 2021

index(
    ri!Questions,
    tointeger(
        wherecontains(
            1,
            tointeger(index(ri!Questions,"isActive", ""))
        )
    ),
    {}
)

kavyam0002
November 9, 2021

Even i have similar question. for example i have ri!applimitcdt and want to display selected rows. selected rows values are in ri!selected_id. how can i display only these selected values