OfBiz allows the creation of views based on the database model. But the data selection is done only by join. It would be great to select the data also by value. And, in some cases, it avoids workarounds and a cleaner code.
The proposal is to create a new tag inside view-entity tag from entitymodel.xml with the following syntax:
<filter entity-alias="<table_alias>" field-name="<field_name>" operator="<operator:equals, not-equals, like...>" value="<value_to_select>"/>
these tag could appear from 0 to N times. When N times, all filter criteria must match with the data to select it.
I am attaching the xsd and the code I made...