Category attribute value update

Shalini MAHENDRAN

Any idea how to copy this TKL multiline value to a text field.

I can get both the value using livereport but cant update in text filed only second value is getting copied.

Kindly advise.

catnew.png

Greg Griffiths

how are you doing the update ?

Shalini MAHENDRAN

I used a webreport to update the value.

I found, value 1 is getting overridden by value 2 that is the reason value 2 is only shown in the new attribute text field. But I can't finger out how to add value 2 in new row, Kindly advise.

This is the code:

[LL_REPTAG_$subreport RUNSQL:[LL_REPTAG_1 /] SETVAR:useridArr1 /]
[LL_REPTAG_!useridArr1 /]

[LL_WEBREPORT_FOR DATA:[LL_REPTAG_!useridArr1 /] VAR:i /]
[LL_REPTAG_!i RECORD:ValStr SETVAR:value HIDE /]
[LL_REPTAG_!value /]
[//LL_REPTAG_'16653657' CATACTION:SETVALUE:'TEST':'Text field':[LL_REPTAG_!value /] /]

Hans Stoop

Have a look at the tag guide for cataction. It specifies how to give the index of the value to update/add.

Shalini MAHENDRAN

@Hans Stoop Thank you for the direction. Found the possession using index and updated the value using addsetrow tag.

[LL_REPTAG_$subreport RUNSQL:[LL_REPTAG_1 /] SETVAR:useridArr1 /]
[//LL_REPTAG_!useridArr1 /]

[LL_WEBREPORT_FOR DATA:[LL_REPTAG_!useridArr1 /] VAR:i /]
[LL_REPTAG_%i_index CURRENTVAL SETVAR:Row /]

[LL_REPTAG_!Row /]
[LL_REPTAG_!i RECORD:ValStr SETVAR:value HIDE /]
[LL_REPTAG_!value /]
[LL_REPTAG_1 CATACTION:SETVALUE:"TEST":"Rowtest":[LL_REPTAG_!Row /]:ADDSETROW:[LL_REPTAG_!value /] /]