how can a list of records in one table can be show in other form using a button

manojlakshmanas
Kilo Expert

I need to show a popup in incident   from to show all the computer present in the computer table,how can i perform this with the help of glide window.

mainly all this must work in customized application scope

Please help me to solve it

this script i have used and this is showing pop up with exact information while using same script in global scope.But while working with private application scope this popup show as mentioned in the second image...  

Please help me to solve it

eerrr11.JPGerrrr2.JPG

1 ACCEPTED SOLUTION

manojlakshmanas
Kilo Expert

This script helped to get the data from table with a query values obtained from form.


function popupList() {


  var num = g_form.getValue('field name');


    var tableName = 'table name from which to query';


    var url =   tableName + '_list.do?';


    url += 'sysparm_query=device_id=' + num;


    //Open the popup


    var w = getTopWindow();


    w.popupOpenFocus(url, 'related_list',   950, 700, '', false, false);


}


note:


table and the buttons are created in the same application scope  


View solution in original post

8 REPLIES 8

I have created a table by name software in the newly created application scope and I have tried to get the details of that table by a button from incident form with same kind of code i have mentioned.


As you said i have given accessing rights also to this table even then i am unable to get the information i get the following image as my ouputins.JPG


Are the details are coming from the Software table which is in the same scope of incident table? that is global scope?


The table and UI Action button which i created are there in same scope only even then i unable to get data.


the data from incident table also i cant get even the table access condition is given to all application scope.


manojlakshmanas
Kilo Expert

This script helped to get the data from table with a query values obtained from form.


function popupList() {


  var num = g_form.getValue('field name');


    var tableName = 'table name from which to query';


    var url =   tableName + '_list.do?';


    url += 'sysparm_query=device_id=' + num;


    //Open the popup


    var w = getTopWindow();


    w.popupOpenFocus(url, 'related_list',   950, 700, '', false, false);


}


note:


table and the buttons are created in the same application scope