Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1071 Improve usability for primary end-to-end use cases
  3. TEIIDDES-1223

Create SQL String Template framework and dialog for use in new view construction and SQL editing

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Done
    • Major
    • 7.7
    • 7.6
    • Transformations
    • None

    Description

      Could be beneficial to expose a standard library of SQL templates that Designer knows about and uses in our import and object creation wizards.

      EXAMPLES include forms based on :

      SELECT * FROM XXXX
      SELECT a,b,c FROM t1, t2 WHERE t1.a = t2.b

      ======= Generated XML File Importer SQL ==========
      SELECT
      A.x AS x, A.y AS y
      FROM
      (EXEC MP.getTextFiles('myfile.xml')) AS f,
      XMLTABLE('/topelement/secondelement' PASSING XMLPARSE(DOCUMENT f.file)
      COLUMNS x string PATH '/x', y string PATH '/elem_a/elem_b')
      AS A
      ========================

      Attachments

        Issue Links

          is related to

          Feature Request - Feature requests from customers and/or users TEIIDDES-1216 New View Table Wizard

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          relates to

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-1270 SQL Templates for Insert, Update, and Delete queries need to be modified to represent new syntax for Teiid 7.7

          • Critical - To be worked on immediately following BLOCKER issues.
          • Closed

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) TEIIDDES-987 Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              mdrillin1@redhat.com Mark Drilling (Inactive)
              blafond Barry LaFond
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: