GouriShankar Korivi (GOURI_SHANKAR_K)
de Volksbank
DevOps Engineer
de Volksbank
GOURI_SHANKAR_K Member since 2011 10 posts
de Volksbank
Posted: February 9, 2018
Last activity: March 26, 2018
Posted: 9 Feb 2018 12:38 EST
Last activity: 26 Mar 2018 23:17 EDT

Workparty search - by name

Hi All,

Requirement :- While creating the case - Contacts is mandatory and it is stored as work party in the case.

We have a requirement where in advanced search - We have to give the option to search with contact name (Work party name)

And we have around 6 Million cases in production so if per case 2 contacts - it will be 12 million records in work party table.

What is the best way to achieve this - Considering the performance impact.

Approach :-I have following approach to achieve this - Join Work class with workparty class, in workparty table in pypartyfullname column we will get the workparty full name. I am joining work class because i have to show few details which are not there in workparty table and there in work table.


Gouri Shankar K

Low-Code App Development System Administration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.