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

[Nicolas Malin (Jira)]

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


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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

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

Erwan de FERRIERES updated OFBIZ-3946:
--------------------------------------

    Assignee: Erwan de FERRIERES

> 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.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12912452#action_12912452 ]

Erwan de FERRIERES commented on OFBIZ-3946:
-------------------------------------------

Hi Pierre,
I took a quick look at your patch. It seems there are some formatting issues (tabs maybe ?), and you leaved the @author tag. Could you update it ?

Regards,

> 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.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12912457#action_12912457 ]

Gaudin Pierre commented on OFBIZ-3946:
--------------------------------------

Hi Erwan,

Thank you very mutch for this "quick look".

Could you please attach to JIRA screenshots about formating issues ?

I'll update @author tag and send you a new patch.

Best regards

Pierre

> 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.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12913605#action_12913605 ]

Erwan de FERRIERES commented on OFBIZ-3946:
-------------------------------------------

hi Pierre,
not speaking about UI, but code formatting.

Cheers,

> 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.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12928201#action_12928201 ]

Erwan de FERRIERES commented on OFBIZ-3946:
-------------------------------------------

Hi Pierre,

any  progress ?

Cheers,

> 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.
-
You can reply to this email to add a comment to the issue online.