Home > Forum > Rules, JS, SQL > Update Item List Action

Update Item List Action

0

29.01.2021

02:06

Hey everybody!

Does anyone already created an action to add news values in an item list?
I'm trying to add a new line in one item list but one of the field I'm copying into is a Person/Group one and it doesn't get the value.

I'm using the following query:

select '{WFCONCOL:1769}' as {DCNCOL:105},
'Requester Manager' as {DCNCOL:104}
from WFElementDetails
where DET_WFDID='{WFD_ID}' and DET_WFCONID={WFCON:1652}

with the unique value set to be the row identifier

Anyone with ideas?

Thank you!

29.01.2021

05:24

Hi Andreia,

I'm making a few guesses here since I don't know what columns the internal IDs refer to.

'{WFCONCOL:1769}' as {DCNCOL:105},
This row probably defines the DET_ID row which should be updated

'Requester Manager' as {DCNCOL:104}
The value should probably be written into the person/group field.

If you are populating a Person/Group or other picker field you should use the ID. In case of Person or Group this should be the BPS ID. Your value seems to be the display name instead. I may be wrong but just to make sure, check the BPS User List to verify it. I currently can't make a screenshot of it.

Regarding screenshot:
A picture of the select statement would have been helpful. We could see the field names instead the internal ones.

Best regards,
Daniel

Solution (0)

Helpful (1)

Wrong answer (0)

02.02.2021

00:41

In reply to: Daniel Krüger (Cosmo Consult)

Hi Daniel,

After several attempts, I managed to copy the field inside the item list!
My final configuration looks like in the image

Thank you so much for your answers and help!!!!!

Solution (0)

Helpful (0)

Wrong answer (0)