Skip to main content
A
amiteshs0001
New Participant
May 22, 2021
Solved

CDT manipulation

  • May 22, 2021
  • 3 replies
  • 0 views

If we need to update a value like status in cdt (multiple) with condition only update only where status =1

Is there a way to achieve this using updatearray and index or is the only option recreating cdt using a!foreach ?

Best answer by sreedevij0001

Hi amitesh,

You can use updatecdt function

updatecdt(

cdt:ri!yourcdt[wherecontains(1,ri!yourcdt.status)],

fieldsAndValues:{

status:"Newstatus"

})

Hope this helps.

Thanks,

Sree Devi J R

3 replies

S
sreedevij0001Answer
Participating Frequently
May 22, 2021

Hi amitesh,

You can use updatecdt function

updatecdt(

cdt:ri!yourcdt[wherecontains(1,ri!yourcdt.status)],

fieldsAndValues:{

status:"Newstatus"

})

Hope this helps.

Thanks,

Sree Devi J R

    A
    amiteshs0001Author
    New Participant
    May 22, 2021

    Update cdt is an add on function and not out of box right?

    S
    sreedevij0001
    Participating Frequently
    May 22, 2021

    Yes. That's right

      Terms & ConditionsAccessibility statement