[
https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13206466#comment-13206466 ]
Adrian Crum commented on OFBIZ-3946:
------------------------------------
If we wanted to implement something like this, then it would be best to use the SQL parsing code found in the entity engine. The SQL parser converts SQL to Entity Expressions and then uses the Entity Engine to execute the SQL. That approach maintains database compatibility.
> 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
> Assignee: Erwan de FERRIERES
> Fix For: SVN trunk
>
> Attachments: query_manager_patch.txt
>
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspaFor more information on JIRA, see:
http://www.atlassian.com/software/jira
Locked
