How to combine array to sys_id

[Community Alums]

Hi Team,

Below is the function of script include and below is the issue:

Line no 381 is taking time to fetch the records when I do lookup, total no of records is just 18 in my case.

I want to add the value of result in Line  376  to 379 so that I can return all accounts name which are there in 376 and 379.

Kindly help me in resolving the same.

[Sandeep Rajput · Accepted solution]

@Community Alums try updating the line 381 as follows.

return 'sys_idIN'+arr.toString()+','+accounts;

[Sandeep Rajput · Accepted solution]

@Community Alums try updating the line 381 as follows.

return 'sys_idIN'+arr.toString()+','+accounts;

[Community Alums]

@Sandeep Rajput Its now working fine. But its taking lot of time to pull the records?

[Sandeep Rajput · Accepted solution]

@Community Alums It will take time as you are you having nested while loops which is causing the delay. You need to refactor your logic to see how the nested loops can be avoided.

Since I addressed your original question, please mark the response as accepted solution.