Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0049299
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Modules] Openbravo Business APIminorhave not tried2022-05-11 16:032022-05-16 08:29
ReportercaristuView Statuspublic 
Assigned Tocaristu 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0049299: Support defining optional export filter parameters

DescriptionSupport defining optional export filter parameters. Currently it is required to provide the values for each of the parameters defined in the query for an export filter. If any parameter value is missing the export fails and the query is not executed. Therefore, all the parameters by default are mandatory.

It would be nice if it would be possible to define a query parameter as non mandatory. And in case its value is not provided it would not be included in the query.
Steps To Reproduce.
Proposed Solution1- In the [Export Filter Parameters] subtab of the Entity Mapping window add a new checkbox "Is Mandatory" which will be checked by default.
2- If the "Is Mandatory" field is unchecked a second field "HQL expression" will be displayed allowing to define a subpart of the HQL where clause that would be added in case the parameter value is passed, ex: e.myoptparam > :myoptparam
3- The HQL where clause would support defining a placeholder for the optional parameter, like for example e.a = :a and $myoptparam. This way $myoptparam would be replaced with the expression e.myoptparam > :myoptparam only if the myoptparam value is provided.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0137210)
hgbot (developer)
2022-05-12 10:41

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/39 [^]
(0137211)
hgbot (developer)
2022-05-12 10:44

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/45 [^]
(0137212)
hgbot (developer)
2022-05-12 10:50

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api.giftcards/-/merge_requests/7 [^]

- Issue History
Date Modified Username Field Change
2022-05-11 16:03 caristu New Issue
2022-05-11 16:03 caristu Assigned To => caristu
2022-05-12 10:41 hgbot Note Added: 0137210
2022-05-12 10:44 hgbot Note Added: 0137211
2022-05-12 10:50 hgbot Note Added: 0137212
2022-05-13 08:20 caristu Description Updated View Revisions
2022-05-13 08:20 caristu Proposed Solution updated
2022-05-13 08:21 caristu Proposed Solution updated
2022-05-16 08:29 alostale Type defect => feature request


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker