Skip to Content
0
Aug 02, 2016 at 03:22 PM

Issue with BO R4 Query Builder

64 Views

Hi All,

-----------------------

Script :

SELECT TOP 1000000 SI_NAME from ci_systemobjects where children("si_name= 'usergroup-user'", "si_name = 'xxxx Viewers'")


------------------

We are getting SI_Name and User ID data only with the mentioned script,when we run this script in BO_R4_Query Builder


and we are not getting required data(Rolesand status) for users based on the roles.


I need data with SIName |User Id| Role | Status.


Do we get this kind of data with the mentioned script or do we need to enhance the script?


Kindly check the attached image FYI.


Needdata as shown in 1st table.


Attachments

Image.PNG (12.8 kB)