Hi,
I have a cdt in which a column is SNO as
SNO name
1 abc
2 def
3 ghi
4 jkl
I want to update only SNO as 2,3,4,5 and it should be 3,4,5,6 . I don't want to update 1 . Which logic i should write?
Discussion posts and replies are publicly visible
Do you want to do it during/after loading by a query rule, right before storing in a smartservice, in an interface via button action or Link?
In an interface via button action
this should do the trick
a!forEach( items: {yourCDTarray}, expression:if( fv!Index>1, a!update( data:fv!item, index:"sno", value:fv!index+1 ), {} ) )
ok Thanks