You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Gaudin Pierre (JIRA)" <ji...@apache.org> on 2010/09/17 17:54:35 UTC
[jira] Updated: (OFBIZ-3946) add an SQL query manager
[ https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gaudin Pierre updated OFBIZ-3946:
---------------------------------
Attachment: query_manager_patch.txt
The patch to apply on OFBiz-trunck
> 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
>
> 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.
-
You can reply to this email to add a comment to the issue online.