Implementing advanced filtering

Case

An arbitrary object, say, an account, has parameter 1, parameter 2 and parameter 3. The object has a detail displaying records of this object type, e.g., accounts that meet the condition "parameter 1 + parameter 2 match the primary record", "parameter 2 + parameter 3 match the primary record", "parameter 1 + parameter 3 match the primary record". The detail enables filtering by several columns. How can I enable UNION, i.e., "summarize" several independent sets of such filters?

Solution

Let's assume we have the following population of the account table:

As per the above description, the page and detail will be populated as follows:

1) The first variant of detial population:

2) The secon variant of detail population. Maybe combining values was meant, in this case the detail and page will be as follows:

"The detail enables filtering by several columns. How can I enable UNION, i.e., "summarize" several independent sets of such filters?"

If the first variant of detail population was meant, then filterGroup in the filtering method on the page will look as follows:

If the second variant of detail population was meant, then filterGroup in the filtering method on the page will look as follows:

Note the mistake in adding groups - the keys are not specified. The correct adding of groups is displayed below:

filterGroup.add(1”, filterGroup1);
filterGroup.add(2”, filterGroup2);
filterGroup.add(3”, filterGroup3);

 

Like 0

Like

Share

0 comments
Show all comments