GET users with any role -REPORT.

[Rushit Patel2]

Hi all,

i want to create a report which shows   list of all users with atleast 1 role in the table. i tried creating database view but it is giving duplicate user records.

i also tried creating report on user table with query like this sys_id is one of   javascript:my script.

now problem is that it returns around 6600 records only. my best guess is.. field which there to hold all sys_id(right side of one of condtion) has some max limit.

i have more than 200000+ records. so it wont work.

can any one suggest any other way?

ps: i can export that data with duplicate records and have some logic to make it distinct on EXCEL.that seems the last option.

[Mike Allen]

That is the way script includes were made before script includes existed.   We were warned away from them, because they load with everything.