[OFBIZ-1232] Data filtering in entity views

• Type: New Feature
• Status: Reopened
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Trunk, Upcoming Branch
• Component/s: framework
• Sprint: Bug Crush Event - 21/2/2015
• Assignee: Adam Heath
• Reporter: Oscar Pablo
• Created: 10/Sep/07 15:51
• Updated: 11/Jan/22 08:51

Description

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...

Issue Links

• relates to: OFBIZ-1252 To permit to use constant and SQL function in entities which has complex-alias fields.