[
https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13206499#comment-13206499 ]
Markus M. May commented on OFBIZ-3946:
--------------------------------------
Ah, sure.
The patch references application/content because the results are transformed to XLS, and therefor it needs the POI dependencies found in the application/content component.
Guess this whole thing is not really what I wanted. Anyway, thanks for your input.
> 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
