New Participant

Solved

CDT manipulation

3 replies
17 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 ?

sreedevij0001Answer

Participating Frequently

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

sreedevij0001Answer

Participating Frequently

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

amiteshs0001Author

New Participant

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

Participating Frequently

Yes. That's right