Handle large amount of data in script include and while calling that script include from a report

[Test97]

Hi,

I am querying a table (Audit table), the table has also 6 lac records and I am trying to get the user list who is not having an update for the last 6 months. So I was doing a script include, script includes code is working fine. and calling that from the report.

But as it contains too many rows the report is not loading.

Is there any way to handle this like by pagination or any other way? 

Has anyone implemented anything like this?

Thank you.

[Ankur Bawiskar]

@Test97 

definitely it will have an impact as you are querying system table (Audit table). It's not recommended practice.

Discuss with customer and inform them about the platform limitations.

[Test97]

Thank you, Is there any other way we can implement to see the list of users who is basically not updating anything for the last few months?

[Ankur Bawiskar]

@Test97 

you can do this

1) have a field of type glidelist referring to user table and update it everytime with the user who is updating the record

2) then you can use this field for your reporting

but even that won't be simple.