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