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


Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more