add an SQL query manager
------------------------
Key: OFBIZ-3946
URL: https://issues.apache.org/jira/browse/OFBIZ-3946
Project: OFBiz
Issue Type: New Feature
Components: framework
Affects Versions: SVN trunk
Reporter: Gaudin Pierre
Fix For: SVN trunk
This is a new feature to manage SQL queries.
You can :
- store/update/delete SQL query
- store/update/delete parameters for this query
- execute query and view results into worksheet
This SQL query manager is usefull to run frequently queries (ie: for
maintenance report)
How to use it :
- goes to webtools/Entity Engine Tools
- select "SQL queries library" item
- create a new query and fill in SQL. If you want to use parameters, add them
like this : select * from facility where facility_Id = '${facilityId}'
- to declare parameters for this query then goes to "Add or update query
parameter" screenlet and fill in fields : description = facility id ; Parameter
= facilityId
- to execute SQl query then press buton "run"
- fill in parameters value adn press buton "run"
- worksheet should automaticaly open
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
