Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-6094

Need assistance on the JSON produced by the oData $expand function

    XMLWordPrintable

Details

    • Task
    • Resolution: Not a Bug
    • Major
    • None
    • None
    • OData
    • None

    Description

      Environment

      ~~~

      Product : Red Hat JBoss Data Virtualization

      Version 6.4.5

      ~~~

       

      Per cu.

      ~~~

      I have a project that requires showing one to many relationship. See diagram in attached jpg

      http://localhost:8080/odata4/domaineclipse/eclipse_vbl/v_diysalescust

      ?$format=JSON & $filter= MID eq '8025231419' & $expand=v_diysalescard_vfk_card,v_diysalesasset_vfk_asset The developer that is using the data set is asking if i can shorten the the name that $expand function is calling

       

      For example the call based on the virtual table and column for each JSON array i need to expand on is as follows.

      $expand=v_diysalescard_vfk_card,v_diysalesasset_vfk_asset

      "v_diysalescard_vfk_card": [] "v_diysalesasset_vfk_asset": []

      can the expanded names be called something like the following without changing the table structure showing in the attached jpg image?

      "asset": []

      "card": []

      ~~~

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-asaji Anu Saji
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: