[
https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13206462#comment-13206462
]
Markus M. May commented on OFBIZ-3946:
--------------------------------------
Hi, I found this issue kind of interesting. The patch is already in my local
working branch and seems to be working (well, mostly). Unfortunately there
seems to be a dependency added from webtools to the application/content,
because of an entity defined in there needed for the webtools.
Question is now, how to approach something like this correctly. IMHO it is a
no-go to reference the application/content from the webtools. Should this tool
be packed into its own component then?
> 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.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
