How to run background script to print records details/Redable log,if there is 2 Lakhs data in table.

[Chandra18]

Hi Expert,

How to run background script to print or Display records details in Redable log, when there are 2 Lakhs records in a table. ensuring it will not create any performance issues.

You can say "you can download the list as per your requirement after appling filter and which field you want to see".

But my use case is diffrent, I am dotwalking from a field thats why I need to run a script.

Thank You!

[Ankur Bawiskar]

@Chandra18 

background script on 2lakh records -> not a good practice and won't recommend.

What's your business requirement?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Chandra18]

Hi @Ankur Bawiskar ,
I want to make a excel file.Where below field should be display.
survey.number +" - "+survey.user.getDisplayValue()+" - "+survey.user.email+" - "+c_value.toString()+" - "+survey.survey_name.getDisplayValue()+'\n'
Note: "c_value" can we generated by link only it depends on Survey records sys_id. I am generating this link( throw calling script include function) and extract C Value from link and pushing these fields value in a array. (My script is working fine if i am showing details for 3000 trecords but more then this transcation get canceled for background  script in servicenow)

[Ankur Bawiskar]

@Chandra18 

try to use export set feature where you can dot walk and specify the type of file excel or csv

It will be exported to mid server

Export sets 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Chandra18]

C_value is important for me to see in that seat , It is possible?