movilizer - How to filter masterdata using more than 6 criterias -

assuming have masterdata pool containing customer data. want filter masterdata entities using querymasterdata. masterdata entity - definition - has 6 filter attributes, 3 string based , 3 numeric, can used filtering performance because values indexed.

what if want filter customers in pool using more 6 criterias of type string?

for instance:

• first name
• last name
• city
• country
• state
• street
• occupation

i aware of criterias should rather predefined values in productive scenario usability reasons. let's assume 7 filter criterias treated strings. how model / structure masterdata make sure criterias operating on indexed values of masterdata, when there 3 string filters available in 1 masterdata entity?

if use more 3 string filters, may split masterdata several pools. can create separate pools person details , location details or group them according preference. then, may link data between pools making use of numeric filters foreign keys.

kind regards, ana