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

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

XMLWordPrintable

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

      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": []

      ~~~

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

                Created:
                Updated:
                Resolved: