[
https://issues.apache.org/jira/browse/OFBIZ-1232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oscar Pablo updated OFBIZ-1232:
-------------------------------
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 sintax:
<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...
was:
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 allows workarounds and a cleaner code.
The proposal is to create a new tag inside view-entity tag from entitymodel.xml
with the following sintax:
<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...
> 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 sintax:
> <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.
