Hi Team,

I'm looking for a solution where I can fetch the list of records from a section if the value of any three fields that i enter in the edit page form of a new record match with the current entry field values.

For example : In my current record I enter the values as follows for the customer CustomerA:

Field1 = 1;

Field2 = 2;

Field3 = 3;

Field4 = 4;

Field5 = 5;

Existing entries :

entry 1 : CustomerB

Field1 = 1;

Field2 = 2;

Field3 = 3;

Field4 = 6;

Field5 = 9;

entry 2 : CustomerC

Field1 = 3;

Field2 = 2;

Field3 = 3;

Field4 = 4;

Field5 = 9;

entry 3 : CustomerD

Field1 = 10;

Field2 = 12;

Field3 = 33;

Field4 = 62;

Field5 = 91;

then, in this case system should be able to fetch the entry with customer names-CustomerB and CustomerC  in a list and display in a dialogBox .

Kindly help.

Many thanks in advance.

best regards,

Sarika

When I try to implement esq and multiple filters, only last added filter will work. Rest will be kind of overrided by the next filter.

For example, If I use 3 filters - 

esq.filters.add(esqFirstFilter);
esq.filters.add(esqSecondFilter);
esq.filters.add(esqThirdFilter);

I am getting results on the basis of last filter.

If I use 2 filters - 

esq.filters.add(esqFirstFilter);
esq.filters.add(esqSecondFilter);

Then last filter esqSecondFilter will filter the records not the first one. And I need both filters.

Is there anything need to be added to this code snippet - before or after.