Skip to main content
harmanjots514
Inspiring
Aug 30, 2021 8:27 PM UTC
Question

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

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

harmanjots514Author
Inspiring
Aug 30, 2021 9:10 PM UTC

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

acaciob0002
acaciob0002
Participating Frequently
Aug 31, 2021 12:28 AM UTC

Hi there,

Have you tried index?

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

Hope that helps

Acacio B.

    ravir0002
    ravir0002
    Participating Frequently
    Aug 31, 2021 11:22 AM UTC

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

    kavyam0002
    kavyam0002
    Brainy
    Nov 9, 2021 11:55 AM UTC

    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

    Terms & ConditionsAccessibility statement