AES - Using a remote table in a list collector field.

[Ron28]

I hope someone can shed some light on this. I created a new Catalog Item in AES and for one of the questions I need to use a list collector. The list collector works fine with I specify a table that resides inside ServiceNow (eg cmdb_ci_component).

Now I want to use a remote table for this list collector, not a local table. The problem I have is that whatever I try, the list collector indicates there are records in the table however each line in the list collector does not show any data. 

When clicking in the list collector, the box pops up and I even get a scroll bar so I know there is data but no table data is showing, despite one of the columns having "display=true" set.

I can even filter the data when starting to type in the list box.

Is this an issue or is a list collector not supposed to work with (in memory) remote tables?

Thanks

Ron

[perkinsarm]

Ron,
I am having a similar issue.
Did you get an answer as to whether a list collector will not work with (in memory) remote tables?
If they are compatible did you find a solution to your issue?

[Ron28]

Hi, 

ServiceNow came back and advised that the reason for this behaviour was that there is no 'sys_id'  value in the remote table items. 

From the SN response:
Based on the example of how to create script based remote table in our DOC:
https://docs.servicenow.com/bundle/tokyo-servicenow-platform/page/administer/remote-tables/task/crea...
There are ways to assign sys_id to remote table records.
Please review the remote table design and make sure the records have sys_id generated on the remote table.

It's a while ago I tested this but I believe that made it work in my case.

Regards

Ron

[perkinsarm]

Thanks Ron,
I found another discussion that hinted that might be the problem. After adding sys_ids to the table the problem was resolved.

Brad

[Ron28]

Hi Brad,
I'm glad that sorted out the issue you had.

Regards

Ron