Question
de Volksbank
NL
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.
Regards
Gouri Shankar K
Accepted Solution
de Volksbank
NL
Finally we have followed the below approach.
Approach :- 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.
Regards
Gouri Shankar K
Pegasystems Inc.
IN
How your current approach is working ?
The other option could be to let the user choose from where they want to search "? I mean, try giving a dropdown or radio button like below :
Search in Contacts ?
Search in Old cases ?
And based on their selection , try to call only the activity that will query the relevant table .
Considering that you have to search thru millions of record, ensure that your tables are properly indexed.
de Volksbank
NL
Hi Santanu,
Sorry, i dint understand what you are trying say by this "try to call only the activity that will query the relevant table ."
Contacts data you cannot search in a work table alone, that's why i was joining work party table.
and i dint understand Search in Contacts ?, Search in Old cases ?
And yes indexes are set up properly on work , workparty table.
Regards
Gouri Shankar K
Pegasystems Inc.
IN
>> Contacts data you cannot search in a work table alone, that's why i was joining work party table.
I was not clear about this requriement. Hence suggested the earlier approach.
Please ignore the steps.
Let us see if others in the forum can give any other idea.
Accepted Solution
de Volksbank
NL
Finally we have followed the below approach.
Approach :- 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.
Regards
Gouri Shankar K