[jira] [Closed] (OFBIZ-3946) add an SQL query manager

["Gaudin Pierre (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gaudin Pierre closed OFBIZ-3946.
--------------------------------
    Resolution: Won't Fix

> 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/webtools
>    Affects Versions: Trunk
>            Reporter: Gaudin Pierre
>            Assignee: Erwan de FERRIERES
>            Priority: Major
>         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 was sent by Atlassian JIRA
(v7.6.3#76005)