[OFBIZ-3946] add an SQL query manager

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: Trunk
• Component/s: framework/webtools
• Sprint: Bug Crush Event - 21/2/2015
• Assignee: Erwan de Ferrieres
• Reporter: Gaudin Pierre
• Created: 17/Sep/10 15:33
• Updated: 23/Feb/18 13:56
• Resolved: 23/Feb/18 13:56

Description

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

Issue Links

• is related to: OFBIZ-6977 Update content type data - sql queries