GOURI_SHANKAR_K Member since 2011 10 posts
de Volksbank
Posted: 2 years ago
Last activity: 2 years 6 months ago

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
Share this page LinkedIn