[jira] [Comment Edited] (OFBIZ-6977) Update content type data - sql queries

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

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

Pierre Smits edited comment on OFBIZ-6977 at 4/17/16 12:48 PM:
---------------------------------------------------------------

Yes, there is a bigger plan behind this. 

Currently we have functionalities in the webtools component to execute ad-hoc sql queries, see https://demo-trunk-ofbiz.apache.org/webtools/control/EntitySQLProcessor.

But what we don't have is functionality to store executed sql queries and other commands, and/or reuse previously stored sql scripts. At the moment this can only be done by manual copy-paste activities from other sources or retyping (which can introduce errors and frustration).

Having such functionality would improve the usability of that function and in its wake adoption. One solution is to use the content component for the storage and retrieval of sql scripts. But for that much needs to be done, including defining the appropriate content type(s). 

This is a precursor to such functionality. 


was (Author: pfm.smits):
Yes, there is a bigger plan behind this. 

Currently we have functionalities in the webtools component to execute ad-hoc sql queries, see https://demo-trunk-ofbiz.apache.org/webtools/control/EntitySQLProcessor.

But what we don't have is functionality to store executed sql queries and other commands, and/or reuse previously stored sql scripts. This can now only be done by manual copy-paste activities or retyping (which can introduce errors and frustration).

Having such functionality would improve the usability of that function and in its wake adoption. One solution is to use the content component for the storage and retrieval of sql scripts. But for that much needs to be done, including defining the appropriate content type(s). 

This is a precursor to such functionality. 

> Update content type data - sql queries
> --------------------------------------
>
>                 Key: OFBIZ-6977
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6977
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: content
>    Affects Versions: Trunk
>            Reporter: Pierre Smits
>            Assignee: Michael Brohl
>            Priority: Minor
>         Attachments: OFBIZ-6977-ContentTypeData.xml.patch
>
>
> Adding a new content type for sql queries



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)