Hola estoy intentando convertir un script de JSON a un QVD pero no se como realmente, si alguien me pudiera apoyar se los agradecería mucho. Quiero separar cada select para hacer un QVD de cada uno.
RestConnectorMasterTable: SQL SELECT "__KEY_root", (SELECT "sort", "order", "max", "offset", "totalCount", "count", "__FK_meta" FROM "meta" FK "__FK_meta"), (SELECT "q", "courseType", "status", "interestLevel", "referrer", "paymentStatus", "enrollmentStatus", "seller", "client", "saleGroup", "isEnabled", "studentName", "saleOrderStartDate", "courseName", "customStatus", "channel", "manager", "__KEY_query", "__FK_query", (SELECT "@Value", "__FK_distributor" FROM "distributor" FK "__FK_distributor" ArrayValueAlias "@Value") FROM "query" PK "__KEY_query" FK "__FK_query"), (SELECT "id" AS "id_u4", "version", "pid", "externalId", "name" AS "name_u4", "status" AS "status_u0", "courseType" AS "courseType_u0", "dateCreated" AS "dateCreated_u0", "lastUpdated", "referrer" AS "referrer_u0", "interestLevel" AS "interestLevel_u0", "campaign", "formURL", "saleGroup" AS "saleGroup_u0", "isEnabled" AS "isEnabled_u0", "manager" AS "manager_u0", "discardReason", "customStatus" AS "customStatus_u0", "enrollmentFieldApproved", "enrollmentFieldCount", "paymentDueDate", "paymentStatus" AS "paymentStatus_u0", "enrollmentStatus" AS "enrollmentStatus_u0", "__KEY_resourceList", "__FK_resourceList", (SELECT "id", "name", "email", "firstName", "lastName", "birthday", "gender", "__KEY_client", "__FK_client", (SELECT "number", "type", "__FK_phone" FROM "phone" FK "__FK_phone") FROM "client" PK "__KEY_client" FK "__FK_client"), (SELECT "name" AS "name_u0", "nationality", "birthday" AS "birthday_u0", "occupation", "firstName" AS "firstName_u0", "lastName" AS "lastName_u0", "email" AS "email_u0", "__FK_student" FROM "student" FK "__FK_student"), (SELECT "id" AS "id_u0", "name" AS "name_u1", "email" AS "email_u1", "iconUri", "__FK_seller" FROM "seller" FK "__FK_seller"), (SELECT "id" AS "id_u1", "name" AS "name_u2", "__FK_distributor_u0" FROM "distributor" FK "__FK_distributor_u0"), (SELECT "departureDate", "destination", "interest", "budget", "channel" AS "channel_u0", "comments", "dateCreated", "reporter", "__FK_lead" FROM "lead" FK "__FK_lead"), (SELECT "id" AS "id_u2", "name" AS "name_u3", "__FK_customStatus" FROM "customStatus" FK "__FK_customStatus"), (SELECT "id" AS "id_u3", "start", "__FK_saleOrder" FROM "saleOrder" FK "__FK_saleOrder") FROM "resourceList" PK "__KEY_resourceList" FK "__FK_resourceList") FROM JSON (wrap on) "root" PK "__KEY_root";
