We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Build a Master/Detail using VBCS Excel Add-In and ORDS

Received Response
11
Views
2
Comments
edited Dec 6, 2021 11:40AM in Visual Builder 2 comments

Summary:

Is it possible to use the ORDS service to build an Master/Detail using VBCS Excel Add-In

Content (required):

I have a ORDS service that returns the data using the below SQL. In the Handler the Source Type is set to Media and the Source is set to the below SQL


SELECT

  'application/json',

  JSON_OBJECT (

    'legal_entity_identifier' VALUE cpg.legal_entity_identifier,

    'cpg_id' VALUE cpg.cpg_id,

    'cpg_code' VALUE cpg.cpg_code,

    'cpg_name' VALUE cpg.cpg_name,

    'price_grp_lines' VALUE (

      SELECT

        JSON_ARRAYAGG(JSON_OBJECT(

                 'cpg_line_id' VALUE cpgl.cpg_line_id,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!