question How to get sys_id on List Collector multi-row variable set? in Developer forum

How to get sys_id on List Collector multi-row variable set?

lipan — Mon, 22 Apr 2024 08:32:44 GMT

Hi EveryOne,

I create a record producer "Create Case Contract" map to Case table, there are multiple rows of variable "Test Case Contract",I use a script to fill variable set's variables into the sc_task table, and in variable set "Test Case Contract", there is a List Collector "attachments". "attachments" is reference to the attachment table. How to add a Reference qualifier to List Collector "attachments"， so that it only displays the files "file1.xlsx" and "file2.xlsx" uploaded when using record producer "Create Case Contract" to create records?I try to use 「javascript&colon;"table_sys_id=" + current.sys_id;'」,it's not work.

record producer

multiple rows of variable

Reference qualifier

Current situation,「javascript&colon;"table_sys_id=" + current.sys_id;'」

Expected results：Create a record using the record producer, and display the uploaded attachments in the list collector of the multi line variable set

Re: How to get sys_id on List Collector multi-row variable set?

lipan — Mon, 22 Apr 2024 08:09:01 GMT

The method of fixed sys_id was used in the expected result graph (Javascript&colon;"table_sys_id=d2c7f55c97bd0e1043d4b380f053af38";). How to dynamically obtain this sys_id? When creating a record using record producer (not yet submitted), the sys_id of the new record

Re: How to get sys_id on List Collector multi-row variable set?

Ryan Duce — Mon, 22 Apr 2024 08:10:03 GMT

Attachments aren't inserted to the database until the record producer is saved, so the attachment records won't show up in that list.

I recommend using the "Attachment" variable type to upload your attachments in a context that's relevant to each row of your variable set.

Re: How to get sys_id on List Collector multi-row variable set?

lipan — Mon, 22 Apr 2024 08:30:53 GMT

Hi Ryan Duce,

I just tried again. When creating a record using record producer, after uploading the file (which has not yet been submitted), the uploaded attachment will immediately appear in the attachment table. At this time, there is no new record in the case table

And the 'Attachment' variable type does not seem to be applicable to multi row variable sets,It displays the following error

'Attachment' variable cannot be part of multi-row variable set

Re: How to get sys_id on List Collector multi-row variable set?

Ryan Duce — Mon, 22 Apr 2024 09:49:40 GMT

Oh that's really annoying, sorry neither of those tips worked.

I think the problem is that current doesn't yet know what the record's sys ID will be. Typically a current object's sys ID will be represented as -1 until the record is saved.

I will defer to others in this case as I can't think of a way to do this without some hefty customisation. Although you might consider just allowing people to attach files at the top-level record producer and not associating them with each row in the variable set, since there'll be some element of human interaction on the case to validate the attachments and set up the individual contracts.