Hi Afsar,
I tried to reproduce this issue. I created one remote table in scoped application and tried to access it using GlideRecord query.
It worked as expected.
I have created it with below permissions:
Also created one definition record. If I deactivate definition then it throws an error.
If I activate definition and comment the script which was adding dummy records then it returns zero record.
Thanks,
Anil Lande
Hi,
Please follow the steps below to achieve your requirement:
This is working for me and tested in my PDI instance.
1) I have created a new Remote Table in a Custom Scope as needed as shown below where I have two field Name and Short Description created as shown below:
2) Now once you have created the Remote table, next step is to create a Definition for the Remote Table. Navigate to the module "Definition as shown below:
3) Click on New button and say add your script which you want to insert data into this Remote Table. I have created a demo sample script so that a record gets inserted into this Remote Table as shown below:
Script:
(function executeQuery(v_table, v_query) {
var rec = {};
rec.sys_id = '23456';
rec.u_name = 'System Admin';
rec.u_short_description = 'this si for community helping users';
v_table.addRow(rec);
})(v_table, v_query);
Output 1:
Data inserted into my Remote Table as shown below:
Now in order to show this data into Service Portal, you do not need to create a Custom widget here and would suggest to make use of OOB capability which allows you to do the same job:
1) Navigate to Page module under Service portal Application menu as shown below:
Now open the page where you need to add the widget to display the data, I have created a new page in my custom scope as shown below:
Click on Open in Designer as shown below after opening your Page record:
Now add this widget in the container where you need to add "Data Table from Instance Definition"
Now once this widget is added, Navigate to widget module and open this widget as shown below: "Data Table from Instance Definition"
After opening the widget record scroll down to "Instance" related list as shown below:
Now open the record where title is blank and select your table Name i.e. Remote Table Name with fields as shown below:
Once this is done, Navigate to your portal page and result are as you need:
Result:
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
