[ https://issues.apache.org/jira/browse/OFBIZ-1232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526696 ]
Oscar Pablo commented on OFBIZ-1232: ------------------------------------ By using the tag <filter> to enter filter conditions, we are not binding the filtering to the join. That is, we can apply a filter even on a single table view. Using the filter tag inside or bound to the <view-link> tag makes the user define a view link to be able to define a filter. Control over "filter conditions" to avoid redundant filters I think is not a critical thing, cause developer/designer can easily control that. And, by the way, if not controlled, it doesn't cause an error. > Data filtering in entity views > ------------------------------ > > Key: OFBIZ-1232 > URL: https://issues.apache.org/jira/browse/OFBIZ-1232 > Project: OFBiz > Issue Type: New Feature > Components: framework > Affects Versions: SVN trunk > Reporter: Oscar Pablo > Priority: Minor > Fix For: SVN trunk > > Attachments: filter_views.diff > > > 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... -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.