Publisher field is taking lot of time to fetch the list of records in TRM request form

RahmatSharH
Tera Contributor

In TRM request form Publisher (reference field)is consuming lot of time to fetch the list. Publisher has 45k records it is referencing to company table and it is using Advanced reference qualifier, In client instance while searching it shows the info message as "took long and was cancelled. Please refine your search and try again". This is OOB. Please help me out on this. 

 

Thanks in Advance!

3 REPLIES 3

Mark Manders
Mega Patron

Sounds like the scripts behind your qualifier need some checking on performance. Do you have all related info filled in on the form? The fact that the code is OOB does not mean it can handle a huge amount of data. Can you share your qualifier and the script(s) behind it?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Okay I agree @Mark Manders, Please find the attached reference qualifier info and script.

Hi @RahmatSharH, you should also raise a SN case, to get the issue fixed by SN as it is OOTB feature.

Should my response prove helpful, please consider marking it as the Accepted Solution/Helpful to assist closing this thread.