.000700 000000 000000 00000000000 14540146672 007301 5ustar00000000 000000 definition.json000600 000000 000000 00000012777 14540146672 012266 0ustar00000000 000000 { "packageDefinition": { "name": "Aggregate Query Testing" }, "packageDefinitionVersion": { "id": "clqbhem950007356e1av2qt8n", "version": "0.0.2" }, "packageDefinitionSelections": [ { "id": "clqbhemfq0008356ej4rpo7t7", "api": "application", "modelName": "InventoryStatus", "selected": [ { "id": "depleted", "label": "Depleted" }, { "id": "good", "label": "Good" }, { "id": "hold", "label": "Hold" }, { "id": "suspect", "label": "Suspect" } ], "fields": [ { "name": "id" }, { "name": "active" }, { "name": "label" } ], "metadata": { "dataTransform": "$", "labelField": [ { "name": "label" } ] }, "packageDefinitionVersionId": "clqbhem950007356e1av2qt8n" }, { "id": "clqbhemfq0009356ew9on4pbp", "api": "application", "modelName": "ModuleGroup", "selected": [ { "id": "materialsManagement", "label": "Materials Management" }, { "id": "productDataManagement", "label": "Product Data Management" } ], "fields": [ { "name": "id" }, { "name": "name" }, { "name": "icon" } ], "metadata": { "dataTransform": "$", "labelField": [ { "name": "name" } ] }, "packageDefinitionVersionId": "clqbhem950007356e1av2qt8n" }, { "id": "clqbhemfq000a356eeb8krldi", "api": "application", "modelName": "Module", "selected": [ { "id": "inventory", "label": "Inventory" }, { "id": "materials", "label": "Materials" } ], "fields": [ { "name": "id" }, { "name": "name" }, { "name": "description" }, { "name": "moduleGroupId" } ], "metadata": { "dataTransform": "$", "labelField": [ { "name": "name" } ] }, "packageDefinitionVersionId": "clqbhem950007356e1av2qt8n" }, { "id": "clqbhemfq000b356e71ispd00", "api": "application", "modelName": "Screen", "selected": [ { "id": "masterUnitsWithInventorySum", "label": "Master Units with Inventory Sum" }, { "id": "inventoryQuantityByUnit", "label": "Inventory Quantity By Unit" } ], "fields": [ { "name": "id" }, { "name": "name" }, { "name": "description" }, { "name": "active" }, { "name": "isWidget" } ], "metadata": { "dataTransform": "$", "labelField": [ { "name": "name" } ] }, "packageDefinitionVersionId": "clqbhem950007356e1av2qt8n" }, { "id": "clqbhemfq000c356ezk7ea1ni", "api": "application", "modelName": "SavedQuery", "selected": [ { "id": "inventoryAggregateExamples", "label": "Inventory Aggregate Examples" } ], "fields": [ { "name": "id" }, { "name": "name" }, { "name": "description" }, { "name": "queryText" } ], "metadata": { "dataTransform": "$", "labelField": [ { "name": "name" } ] }, "packageDefinitionVersionId": "clqbhem950007356e1av2qt8n" }, { "id": "clqbhemfq000d356ehxt4o7iq", "api": "application", "modelName": "DataModel", "selected": [ { "id": "inventory", "label": "Inventory" }, { "id": "inventoryStatus", "label": "InventoryStatus" }, { "id": "masterUnit", "label": "MasterUnit" } ], "fields": [ { "name": "id" }, { "name": "name" }, { "name": "description" }, { "name": "dataModelKindId" } ], "metadata": { "dataTransform": "$", "labelField": [ { "name": "name" } ] }, "packageDefinitionVersionId": "clqbhem950007356e1av2qt8n" }, { "id": "clqbhemfq000e356e5196qrbu", "api": "application", "modelName": "DataFlow", "selected": [ { "id": "generateTestInventory", "label": "Generate Test Inventory" } ], "fields": [ { "name": "id" }, { "name": "name" }, { "name": "description" }, { "name": "active" }, { "name": "dataFlowTypeId" }, { "name": "moduleId" } ], "metadata": { "dataTransform": "$", "labelField": [ { "name": "name" } ] }, "packageDefinitionVersionId": "clqbhem950007356e1av2qt8n" } ] }manifest.json000600 000000 000000 00000000217 14540146672 011726 0ustar00000000 000000 { "name": "Aggregate Query Testing", "version": "0.0.2", "dependencies": {}, "specVersion": "2.0.0", "platformVersion": "2023.12.0" }package-data.json000600 000000 000000 00000340425 14540146672 012432 0ustar00000000 000000 { "dataModels": [ { "header": { "id": "inventory", "name": "Inventory", "description": "", "dataModelKindId": "reference" }, "version": { "id": "clp352gl2004z07758eaebn4b", "number": "2", "dataModelId": "inventory", "modelDefinition": { "name": "Inventory", "metadata": { "mfgx": { "module": { "id": "materials", "group": { "id": "productDataManagement" } }, "exposed": true, "mutable": true, "mutations": { "create": true, "update": true, "del": true }, "dataChangeCapture": { "exposed": true, "retentionDays": 120 }, "editor": { "autosort": true } }, "mongo": { "collection": "inventory" }, "graphql": { "type": "Object" } }, "kind": "Reference", "fields": [ { "name": "id", "type": "ID!", "description": "The primary unique ID of the record. Every model should have an id field.", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": false } }, "queries": { "include": true }, "where": { "include": true } }, "unique": true } }, { "name": "number", "type": "String!", "description": "", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": true } }, { "name": "quantity", "type": "Measure!", "description": "", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } }, { "name": "inventoryStatusId", "type": "ID!", "description": "", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } }, { "name": "inventoryStatus", "description": "", "type": "InventoryStatus!", "metadata": { "mfgx": { "relation": { "fields": { "from": "inventoryStatusId", "to": "id" } }, "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } }, { "name": "masterUnitId", "type": "ID", "description": "", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } }, { "name": "masterUnit", "description": "", "type": "MasterUnit", "metadata": { "mfgx": { "relation": { "fields": { "from": "masterUnitId", "to": "id" } }, "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } } ], "description": "" } }, "migration": "$", "migrations": [ { "dataModelVersionId": "clp352gl2004z07758eaebn4b", "dataModelVersion": { "number": "2" }, "mappingExpression": "$" }, { "dataModelVersionId": "clp34zoxw00490775a40hbr4x", "dataModelVersion": { "number": "1" }, "mappingExpression": "$" } ] }, { "header": { "id": "inventoryStatus", "name": "InventoryStatus", "description": "", "dataModelKindId": "reference" }, "version": { "id": "clp352haf00510775du4lb4nn", "number": "2", "dataModelId": "inventoryStatus", "modelDefinition": { "name": "InventoryStatus", "metadata": { "mfgx": { "module": { "id": "materials", "group": { "id": "productDataManagement" } }, "exposed": true, "mutable": true, "mutations": { "create": true, "update": true, "del": true }, "dataChangeCapture": { "exposed": true, "retentionDays": 120 }, "editor": { "autosort": true } }, "mongo": { "collection": "inventoryStatus" }, "graphql": { "type": "Object" } }, "kind": "Reference", "fields": [ { "name": "id", "type": "ID!", "description": "The primary unique ID of the record. Every model should have an id field.", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": false } }, "queries": { "include": true }, "where": { "include": true } }, "unique": true } }, { "name": "active", "type": "Boolean!", "description": "", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } }, { "name": "label", "type": "String!", "description": "", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": true } }, { "name": "inventories", "description": "", "type": "[Inventory!]!", "metadata": { "mfgx": { "relation": { "fields": { "from": "id", "to": "inventoryStatusId" } }, "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } } ], "description": "" } }, "migration": "$", "migrations": [ { "dataModelVersionId": "clp352haf00510775du4lb4nn", "dataModelVersion": { "number": "2" }, "mappingExpression": "$" }, { "dataModelVersionId": "clp34z58g004807755wh76lez", "dataModelVersion": { "number": "1" }, "mappingExpression": "$" } ] }, { "header": { "id": "masterUnit", "name": "MasterUnit", "description": "", "dataModelKindId": "reference" }, "version": { "id": "clp352gyl00500775f2o07c2b", "number": "2", "dataModelId": "masterUnit", "modelDefinition": { "name": "MasterUnit", "metadata": { "mfgx": { "module": { "id": "inventory", "group": { "id": "materialsManagement" } }, "exposed": true, "mutable": true, "mutations": { "create": true, "update": true, "del": true }, "dataChangeCapture": { "exposed": true, "retentionDays": 120 }, "editor": { "autosort": true } }, "mongo": { "collection": "masterUnit" }, "graphql": { "type": "Object" } }, "kind": "Reference", "fields": [ { "name": "id", "type": "ID!", "description": "The primary unique ID of the record. Every model should have an id field.", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": false } }, "queries": { "include": true }, "where": { "include": true } }, "unique": true } }, { "name": "batchCode", "type": "String", "description": "", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } }, { "name": "number", "type": "String!", "description": "", "metadata": { "mfgx": { "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": true } }, { "name": "inventories", "description": "", "type": "[Inventory!]!", "metadata": { "mfgx": { "relation": { "fields": { "from": "id", "to": "masterUnitId" } }, "mutations": { "create": { "include": true }, "update": { "include": true } }, "queries": { "include": true }, "where": { "include": true } }, "unique": false } } ], "description": "" } }, "migration": "$", "migrations": [ { "dataModelVersionId": "clp352gyl00500775f2o07c2b", "dataModelVersion": { "number": "2" }, "mappingExpression": "$" }, { "dataModelVersionId": "clp3512x7004a077555vma2dz", "dataModelVersion": { "number": "1" }, "mappingExpression": "$" } ] } ], "dataFlows": [ { "header": { "id": "generateTestInventory", "name": "Generate Test Inventory", "description": "", "active": true, "dataFlowTypeId": "System", "moduleId": null }, "version": { "id": "clp356vlh005o07756j3e1t6h", "number": "0.0.1", "description": "", "dataFlowId": "generateTestInventory", "flow": { "id": "clp356vlh005o07756j3e1t6h", "name": "Generate Test Inventory", "type": "System", "nodes": [ { "id": "21aeb13a-21b4-4a73-b14f-9036ad5df943", "name": "Generate Master Units", "type": "transform", "data": { "transform": "{\n \"masterUnits\": [1..$state.context.params.masterUnits].{\n \"batchCode\": $state.context.params.batchCode,\n \"number\": $coalesce([$state.context.params.batchCode, \"\"]) & $pad($string($), -5, \"0\")\n }\n}", "nextNodes": [ "c6f9a873-1bfa-413b-80fa-f820b7eff907" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false } }, { "id": "ad94ac82-f882-4136-9618-9cf18e88c11f", "name": "Set Context", "type": "setContext", "data": { "nextNodes": [ "21aeb13a-21b4-4a73-b14f-9036ad5df943" ], "transform": "{\n \"params\": $\n}" }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false } }, { "id": "c6f9a873-1bfa-413b-80fa-f820b7eff907", "name": "Create Master Units", "type": "mutate", "data": { "api": "Application", "variablesTransform": "{\n \"payload\": masterUnits.{\n \"create\": $\n }\n}", "mutation": "mutation ($payload:[MasterUnitCreatePayloadInput!]!) {\n createMasterUnit(payload: $payload) {\n id\n }\n}", "nextNodes": [ "59d5f844-5708-403f-b946-ca943c3789e5" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false } }, { "id": "c65c89c2-ade3-44a1-a4bd-56f7e6e9cbdc", "name": "Create Inventory", "type": "mutate", "data": { "api": "Application", "variablesTransform": "{\n \"payload\": inventory.{\n \"create\": $\n }\n}", "mutation": "mutation ($payload:[InventoryCreatePayloadInput!]!) {\n createInventory(payload: $payload) {\n id\n }\n}", "nextNodes": [] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false } }, { "id": "0c1c8272-4465-4908-a7fd-68140868943d", "name": "Query", "type": "query", "data": { "api": "application", "variablesTransform": "{}", "query": "{\n masterUnit(first: null) {\n edges {\n node {\n id\n }\n }\n }\n \n inventory(first: null) {\n edges {\n node {\n id\n }\n }\n }\n}", "nextNodes": [ "4baea663-9779-4e76-8094-f05d87038b09" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false } }, { "id": "4baea663-9779-4e76-8094-f05d87038b09", "name": "Mutate", "type": "mutate", "data": { "api": "Application", "variablesTransform": "{\n \"inventory\": [inventory.edges.{\n \"where\": node\n }],\n \"masterUnits\": [masterUnit.edges.{\n \"where\": node\n }]\n}", "mutation": "mutation ($inventory:[InventoryDeletePayloadInput!]! $masterUnits:[MasterUnitDeletePayloadInput!]!) {\n deleteInventory(payload: $inventory) {\n id\n }\n \n deleteMasterUnit(payload: $masterUnits) {\n id\n }\n}", "nextNodes": [] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false } }, { "id": "59d5f844-5708-403f-b946-ca943c3789e5", "name": "Generate Inventory", "type": "transform", "data": { "transform": "{\n \"inventory\": [1..$state.context.params.inventory].(\n $index := $floor($random() * $state.context.params.masterUnits);\n {\n \"number\": $coalesce([$state.context.params.batchCode, \"\"]) & $pad($string($), -5, \"0\"),\n \"quantity\": {\n \"unitId\": $state.context.params.unitId,\n \"value\": $floor($random() * 100)\n },\n \"inventoryStatusId\": $state.context.params.inventoryStatusId,\n \"masterUnitId\": $$.createMasterUnit[$index].id\n }\n )\n}", "nextNodes": [ "c65c89c2-ade3-44a1-a4bd-56f7e6e9cbdc" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false } } ], "version": "0.0.1" }, "diagram": { "id": "clp356vlh005o07756j3e1t6h", "offsetX": -53, "offsetY": 39, "zoom": 100, "gridSize": 5, "layers": [ { "id": "a43bae98-8110-45f7-b1a1-ba8c76f162e1", "type": "diagram-links", "isSvg": true, "transformed": true, "models": { "a3bb4750-b6ab-4858-87a4-d66e7c9ac3ba": { "points": [ { "id": "a421198b-a203-4389-9ab1-4396df113b06", "type": "point", "x": 298.98, "y": 249.73 }, { "id": "0add2475-ecc2-4878-92ac-e0a5aef3b931", "type": "point", "x": 340, "y": 249.73 } ], "id": "a3bb4750-b6ab-4858-87a4-d66e7c9ac3ba", "type": "default", "source": "969c7c3f-aa73-4559-b1ac-a268a6249ae3", "sourcePort": "clp356y290010356elll22rc9", "target": "ad94ac82-f882-4136-9618-9cf18e88c11f", "targetPort": "clp35d3w4009t356e6e3mc2dg", "labels": [], "width": 3, "curvyness": 50 }, "7b0068f1-7dd9-4394-b4e4-9d11b84798f3": { "points": [ { "id": "10ddc7c2-c314-46d9-a2e8-a854b40c3a5b", "type": "point", "x": 494, "y": 249.73 }, { "id": "d90ba30f-b5ca-46e8-a945-c9fa6731d7b9", "type": "point", "x": 535, "y": 249.73 } ], "id": "7b0068f1-7dd9-4394-b4e4-9d11b84798f3", "type": "default", "source": "ad94ac82-f882-4136-9618-9cf18e88c11f", "sourcePort": "clp35d3w5009v356ebn95berd", "target": "21aeb13a-21b4-4a73-b14f-9036ad5df943", "targetPort": "clp357ckz0018356ewrn74oe8", "labels": [], "width": 3, "curvyness": 50 }, "70760ad6-9824-4acd-baf6-8d7adbe034f5": { "points": [ { "id": "95aea585-46c3-4a90-a646-b3e79bf1a049", "type": "point", "x": 700.72, "y": 249.73 }, { "id": "b343ef81-0649-4fcb-937e-01c2d07354ec", "type": "point", "x": 745, "y": 249.73 } ], "id": "70760ad6-9824-4acd-baf6-8d7adbe034f5", "type": "default", "source": "21aeb13a-21b4-4a73-b14f-9036ad5df943", "sourcePort": "clp357ckz001a356ediucm8iw", "target": "c6f9a873-1bfa-413b-80fa-f820b7eff907", "targetPort": "clp35ev2q00df356e74zb2mws", "labels": [], "width": 3, "curvyness": 50 }, "a1cf65e0-5bb5-40c3-8818-0edbf9f7e77e": { "points": [ { "id": "f4de8113-ed04-4027-8ccb-ce7845c63890", "type": "point", "x": 298.98, "y": 129.73 }, { "id": "4afbb3a0-50a5-4a6d-9146-628122dd677d", "type": "point", "x": 340, "y": 129.73 } ], "id": "a1cf65e0-5bb5-40c3-8818-0edbf9f7e77e", "type": "default", "source": "bce1d25d-560a-4d6f-ae51-503a546ada9b", "sourcePort": "clp35kipy00qy356eon6r7z12", "target": "0c1c8272-4465-4908-a7fd-68140868943d", "targetPort": "clp35kn9h00r0356ephi3ppu7", "labels": [], "width": 3, "curvyness": 50 }, "08d68e7e-54d8-48df-9789-10774e35ff77": { "points": [ { "id": "6f807423-d504-4970-b675-56c4dda20a16", "type": "point", "x": 494, "y": 129.73 }, { "id": "5eb10626-da6a-439d-bba8-f0d136ef44b1", "type": "point", "x": 540, "y": 129.73 } ], "id": "08d68e7e-54d8-48df-9789-10774e35ff77", "type": "default", "source": "0c1c8272-4465-4908-a7fd-68140868943d", "sourcePort": "clp35kn9h00r2356e8ecpfsge", "target": "4baea663-9779-4e76-8094-f05d87038b09", "targetPort": "clp35lmyi00ud356ebly90o2a", "labels": [], "width": 3, "curvyness": 50 }, "fc5b3a92-37d7-40d1-8a9f-dd001e3f1cfe": { "points": [ { "id": "612a2726-e1c6-4703-ae90-b8212dfecd8c", "type": "point", "x": 899, "y": 249.73 }, { "id": "ee1b48bf-709a-4b12-80b5-e945a433a6d2", "type": "point", "x": 945, "y": 249.73 } ], "id": "fc5b3a92-37d7-40d1-8a9f-dd001e3f1cfe", "type": "default", "source": "c6f9a873-1bfa-413b-80fa-f820b7eff907", "sourcePort": "clp35ev2q00dh356ebyfvyd02", "target": "59d5f844-5708-403f-b946-ca943c3789e5", "targetPort": "clp3617p201co356e18cvqn8h", "labels": [], "width": 3, "curvyness": 50 }, "6c23c9f6-3495-4740-9cb7-3c092b58f840": { "points": [ { "id": "f6df76be-80cc-45fe-a529-de95f57adcfa", "type": "point", "x": 1099, "y": 249.73 }, { "id": "a51f447e-5989-4b31-a5ef-5da3f8f59d72", "type": "point", "x": 1140, "y": 249.73 } ], "id": "6c23c9f6-3495-4740-9cb7-3c092b58f840", "type": "default", "source": "59d5f844-5708-403f-b946-ca943c3789e5", "sourcePort": "clp3617p201cq356eqfsr9ctr", "target": "c65c89c2-ade3-44a1-a4bd-56f7e6e9cbdc", "targetPort": "clp35k1w400pr356edcits7me", "labels": [], "width": 3, "curvyness": 50 } } }, { "id": "7d1560bd-f82a-404d-af13-3abbee78ae1d", "type": "diagram-nodes", "isSvg": false, "transformed": true, "models": { "969c7c3f-aa73-4559-b1ac-a268a6249ae3": { "id": "969c7c3f-aa73-4559-b1ac-a268a6249ae3", "type": "debugSource", "selected": true, "x": 145, "y": 210, "ports": [ { "id": "clp356y290010356elll22rc9", "type": "default", "x": 290.98, "y": 241.73, "name": "clp356y290011356eonwu72y1", "parentNode": "969c7c3f-aa73-4559-b1ac-a268a6249ae3", "links": [ "a3bb4750-b6ab-4858-87a4-d66e7c9ac3ba" ], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "payload": { "batchCode": "4", "masterUnits": 3, "inventory": 100, "unitId": "in", "inventoryStatusId": "good" }, "context": {}, "nextNodes": [ "ad94ac82-f882-4136-9618-9cf18e88c11f" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Source" }, "21aeb13a-21b4-4a73-b14f-9036ad5df943": { "id": "21aeb13a-21b4-4a73-b14f-9036ad5df943", "type": "transform", "selected": false, "x": 535, "y": 210, "ports": [ { "id": "clp357ckz0018356ewrn74oe8", "type": "default", "x": 527, "y": 241.73, "name": "clp357ckz0019356enumfpvw3", "parentNode": "21aeb13a-21b4-4a73-b14f-9036ad5df943", "links": [ "7b0068f1-7dd9-4394-b4e4-9d11b84798f3" ], "in": true }, { "id": "clp357ckz001a356ediucm8iw", "type": "default", "x": 692.72, "y": 241.73, "name": "clp357ckz001b356enqt72jps", "parentNode": "21aeb13a-21b4-4a73-b14f-9036ad5df943", "links": [ "70760ad6-9824-4acd-baf6-8d7adbe034f5" ], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "transform": "{\n \"masterUnits\": [1..$state.context.params.masterUnits].{\n \"batchCode\": $state.context.params.batchCode,\n \"number\": $coalesce([$state.context.params.batchCode, \"\"]) & $pad($string($), -5, \"0\")\n }\n}", "nextNodes": [ "c6f9a873-1bfa-413b-80fa-f820b7eff907" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Generate Master Units" }, "ad94ac82-f882-4136-9618-9cf18e88c11f": { "id": "ad94ac82-f882-4136-9618-9cf18e88c11f", "type": "setContext", "selected": false, "x": 340, "y": 210, "ports": [ { "id": "clp35d3w4009t356e6e3mc2dg", "type": "default", "x": 332, "y": 241.73, "name": "clp35d3w4009u356ee5dfts9h", "parentNode": "ad94ac82-f882-4136-9618-9cf18e88c11f", "links": [ "a3bb4750-b6ab-4858-87a4-d66e7c9ac3ba" ], "in": true }, { "id": "clp35d3w5009v356ebn95berd", "type": "default", "x": 486, "y": 241.73, "name": "clp35d3w5009w356efbxhu94x", "parentNode": "ad94ac82-f882-4136-9618-9cf18e88c11f", "links": [ "7b0068f1-7dd9-4394-b4e4-9d11b84798f3" ], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "nextNodes": [ "21aeb13a-21b4-4a73-b14f-9036ad5df943" ], "transform": "{\n \"params\": $\n}" }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Set Context" }, "c6f9a873-1bfa-413b-80fa-f820b7eff907": { "id": "c6f9a873-1bfa-413b-80fa-f820b7eff907", "type": "mutate", "selected": false, "x": 745, "y": 210, "ports": [ { "id": "clp35ev2q00df356e74zb2mws", "type": "default", "x": 737, "y": 241.73, "name": "clp35ev2q00dg356eklpnqboa", "parentNode": "c6f9a873-1bfa-413b-80fa-f820b7eff907", "links": [ "70760ad6-9824-4acd-baf6-8d7adbe034f5" ], "in": true }, { "id": "clp35ev2q00dh356ebyfvyd02", "type": "default", "x": 891, "y": 241.73, "name": "clp35ev2q00di356efu7omox1", "parentNode": "c6f9a873-1bfa-413b-80fa-f820b7eff907", "links": [ "fc5b3a92-37d7-40d1-8a9f-dd001e3f1cfe" ], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "api": "Application", "variablesTransform": "{\n \"payload\": masterUnits.{\n \"create\": $\n }\n}", "mutation": "mutation ($payload:[MasterUnitCreatePayloadInput!]!) {\n createMasterUnit(payload: $payload) {\n id\n }\n}", "nextNodes": [ "59d5f844-5708-403f-b946-ca943c3789e5" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Create Master Units" }, "c65c89c2-ade3-44a1-a4bd-56f7e6e9cbdc": { "id": "c65c89c2-ade3-44a1-a4bd-56f7e6e9cbdc", "type": "mutate", "selected": false, "x": 1140, "y": 210, "ports": [ { "id": "clp35k1w400pr356edcits7me", "type": "default", "x": 1132, "y": 241.73, "name": "clp35k1w400ps356e6q3nlumq", "parentNode": "c65c89c2-ade3-44a1-a4bd-56f7e6e9cbdc", "links": [ "6c23c9f6-3495-4740-9cb7-3c092b58f840" ], "in": true }, { "id": "clp35k1w400pt356egzjarboa", "type": "default", "x": 1286, "y": 241.73, "name": "clp35k1w400pu356esu4lk18b", "parentNode": "c65c89c2-ade3-44a1-a4bd-56f7e6e9cbdc", "links": [], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "api": "Application", "variablesTransform": "{\n \"payload\": inventory.{\n \"create\": $\n }\n}", "mutation": "mutation ($payload:[InventoryCreatePayloadInput!]!) {\n createInventory(payload: $payload) {\n id\n }\n}", "nextNodes": [] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Create Inventory" }, "bce1d25d-560a-4d6f-ae51-503a546ada9b": { "id": "bce1d25d-560a-4d6f-ae51-503a546ada9b", "type": "debugSource", "selected": false, "x": 145, "y": 90, "ports": [ { "id": "clp35kipy00qy356eon6r7z12", "type": "default", "x": 290.98, "y": 121.73, "name": "clp35kipy00qz356ei3f6mdgn", "parentNode": "bce1d25d-560a-4d6f-ae51-503a546ada9b", "links": [ "a1cf65e0-5bb5-40c3-8818-0edbf9f7e77e" ], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "payload": { "batchCode": "1", "masterUnits": 5, "inventory": 100, "unitId": "ft", "inventoryStatusId": "good" }, "context": {}, "nextNodes": [ "0c1c8272-4465-4908-a7fd-68140868943d" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Clear Collections" }, "0c1c8272-4465-4908-a7fd-68140868943d": { "id": "0c1c8272-4465-4908-a7fd-68140868943d", "type": "query", "selected": false, "x": 340, "y": 90, "ports": [ { "id": "clp35kn9h00r0356ephi3ppu7", "type": "default", "x": 332, "y": 121.73, "name": "clp35kn9h00r1356eh34vga0u", "parentNode": "0c1c8272-4465-4908-a7fd-68140868943d", "links": [ "a1cf65e0-5bb5-40c3-8818-0edbf9f7e77e" ], "in": true }, { "id": "clp35kn9h00r2356e8ecpfsge", "type": "default", "x": 486, "y": 121.73, "name": "clp35kn9h00r3356e4avra4yn", "parentNode": "0c1c8272-4465-4908-a7fd-68140868943d", "links": [ "08d68e7e-54d8-48df-9789-10774e35ff77" ], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "api": "application", "variablesTransform": "{}", "query": "{\n masterUnit(first: null) {\n edges {\n node {\n id\n }\n }\n }\n \n inventory(first: null) {\n edges {\n node {\n id\n }\n }\n }\n}", "nextNodes": [ "4baea663-9779-4e76-8094-f05d87038b09" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Query" }, "4baea663-9779-4e76-8094-f05d87038b09": { "id": "4baea663-9779-4e76-8094-f05d87038b09", "type": "mutate", "selected": false, "x": 540, "y": 90, "ports": [ { "id": "clp35lmyi00ud356ebly90o2a", "type": "default", "x": 532, "y": 121.73, "name": "clp35lmyi00ue356evz35pyum", "parentNode": "4baea663-9779-4e76-8094-f05d87038b09", "links": [ "08d68e7e-54d8-48df-9789-10774e35ff77" ], "in": true }, { "id": "clp35lmyi00uf356ep7ysr5i4", "type": "default", "x": 686, "y": 121.73, "name": "clp35lmyi00ug356egw5wsfvn", "parentNode": "4baea663-9779-4e76-8094-f05d87038b09", "links": [], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "api": "Application", "variablesTransform": "{\n \"inventory\": [inventory.edges.{\n \"where\": node\n }],\n \"masterUnits\": [masterUnit.edges.{\n \"where\": node\n }]\n}", "mutation": "mutation ($inventory:[InventoryDeletePayloadInput!]! $masterUnits:[MasterUnitDeletePayloadInput!]!) {\n deleteInventory(payload: $inventory) {\n id\n }\n \n deleteMasterUnit(payload: $masterUnits) {\n id\n }\n}", "nextNodes": [] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Mutate" }, "59d5f844-5708-403f-b946-ca943c3789e5": { "id": "59d5f844-5708-403f-b946-ca943c3789e5", "type": "transform", "selected": false, "x": 945, "y": 210, "ports": [ { "id": "clp3617p201co356e18cvqn8h", "type": "default", "x": 937, "y": 241.73, "name": "clp3617p201cp356elw6zefmg", "parentNode": "59d5f844-5708-403f-b946-ca943c3789e5", "links": [ "fc5b3a92-37d7-40d1-8a9f-dd001e3f1cfe" ], "in": true }, { "id": "clp3617p201cq356eqfsr9ctr", "type": "default", "x": 1091, "y": 241.73, "name": "clp3617p201cr356epjo6bocc", "parentNode": "59d5f844-5708-403f-b946-ca943c3789e5", "links": [ "6c23c9f6-3495-4740-9cb7-3c092b58f840" ], "in": false, "groupIndex": null, "groupPath": null, "fieldLabel": "Output", "fieldPath": "data.nextNodes" } ], "data": { "transform": "{\n \"inventory\": [1..$state.context.params.inventory].(\n $index := $floor($random() * $state.context.params.masterUnits);\n {\n \"number\": $coalesce([$state.context.params.batchCode, \"\"]) & $pad($string($), -5, \"0\"),\n \"quantity\": {\n \"unitId\": $state.context.params.unitId,\n \"value\": $floor($random() * 100)\n },\n \"inventoryStatusId\": $state.context.params.inventoryStatusId,\n \"masterUnitId\": $$.createMasterUnit[$index].id\n }\n )\n}", "nextNodes": [ "c65c89c2-ade3-44a1-a4bd-56f7e6e9cbdc" ] }, "debug": { "breakpointEnabled": false, "publishSubscribeClient": false, "publishToMFGx": false }, "logging": { "executionMetrics": false, "executionStarted": false, "executionSucceeded": false, "executionFailed": true, "enableTraceLogging": false }, "name": "Generate Inventory" } } } ], "name": "Generate Test Inventory", "type": "System", "version": "0.0.1", "walkthrough": { "steps": [] } } } } ], "screens": [ { "header": { "id": "masterUnitsWithInventorySum", "name": "Master Units with Inventory Sum", "description": "", "active": true, "isWidget": false }, "version": { "id": "clqbhdh1m00rp0775gd5iekry", "number": "0.0.2", "description": "", "screenId": "masterUnitsWithInventorySum", "design": { "components": [ { "type": "canvas", "name": "MasterUnitTable", "tabTitle": "Master Unit Table", "props": { "design": { "ROOT": { "type": { "resolvedName": "Screen" }, "isCanvas": true, "props": { "padding": 0, "margin": 0, "flexDirection": "column", "flexWrap": false, "alignItems": "stretch", "justifyContent": "flex-start", "width": "100%", "height": "100%", "hidden": false, "flexGrow": false, "shadow": false, "borderRadius": 0 }, "displayName": "Screen", "custom": { "elementName": "Screen", "elementCounts": { "Container": 3, "Action Button": 4, "Form": 1, "Table": 1, "Text": 2, "Table Column": 4 }, "module": { "id": "inventory", "group": { "id": "materialsManagement" } }, "dataModel": "MasterUnit", "template": "table" }, "parent": null, "hidden": false, "nodes": [ "rcf7XNpYWy", "PzGQyuiSYQ", "nXrLmn-Y-B" ], "linkedNodes": {} }, "rcf7XNpYWy": { "type": { "resolvedName": "Container" }, "isCanvas": true, "props": { "padding": 0, "margin": 0, "flexWrap": false, "flexDirection": "column", "justifyContent": "flex-start", "alignItems": "stretch", "width": "100%", "height": "auto", "hidden": false, "flexGrow": false, "shadow": false, "borderRadius": 0, "collapsible": false, "collapsedFooter": false, "collapsedSize": 0, "collapsedByDefault": false, "onClickTransform": false, "layout": "flex", "justifyItems": "start", "style": {} }, "displayName": "Container", "custom": { "elementName": "Container1" }, "parent": "ROOT", "hidden": false, "nodes": [ "SVTZNTngug" ], "linkedNodes": {} }, "SVTZNTngug": { "type": { "resolvedName": "Form" }, "isCanvas": true, "props": { "query": { "api": "Application", "model": "MasterUnit", "query": null, "dataPath": "edges[0]", "dataTransform": { "transform": null, "remote": true }, "dataSubscription": { "enabled": false }, "autoLoad": false }, "blockNavigationWhenDirty": false }, "displayName": "Form", "custom": { "elementName": "Form1" }, "parent": "rcf7XNpYWy", "hidden": false, "nodes": [ "s3HiLogpc6" ], "linkedNodes": {} }, "s3HiLogpc6": { "type": { "resolvedName": "Container" }, "isCanvas": true, "props": { "padding": 8, "margin": 1, "flexWrap": true, "flexDirection": "row", "justifyContent": "flex-start", "alignItems": "flex-end", "width": "100%", "height": "auto", "hidden": false, "flexGrow": false, "shadow": false, "borderRadius": 0, "collapsible": true, "collapsedFooter": false, "collapsedSize": 0, "collapsedByDefault": false, "onClickTransform": false, "layout": "flex", "justifyItems": "start", "style": {}, "background": "paper" }, "displayName": "Container", "custom": { "elementName": "Container2" }, "parent": "SVTZNTngug", "hidden": false, "nodes": [ "mrkwmZh1dR", "DaZLh1ae7l" ], "linkedNodes": {} }, "mrkwmZh1dR": { "type": { "resolvedName": "TextInput" }, "isCanvas": false, "props": { "type": "text", "padding": 8, "width": "300px", "height": "auto", "label": "Batch Code", "validation": { "required": false }, "visible": true, "formElement": "Form1", "dataPath": "batchCode", "field": "batchCode", "description": "", "element": "TextInput", "predicate": "_contains", "target": { "dataPath": "batchCode._contains" } }, "displayName": "Text", "custom": { "elementName": "Text1" }, "parent": "s3HiLogpc6", "hidden": false, "nodes": [], "linkedNodes": {} }, "DaZLh1ae7l": { "type": { "resolvedName": "TextInput" }, "isCanvas": false, "props": { "type": "text", "padding": 8, "width": "300px", "height": "auto", "label": "Number", "validation": { "required": false }, "visible": true, "formElement": "Form1", "dataPath": "number", "field": "number", "description": "", "element": "TextInput", "predicate": "_contains", "target": { "dataPath": "number._contains" } }, "displayName": "Text", "custom": { "elementName": "Text2" }, "parent": "s3HiLogpc6", "hidden": false, "nodes": [], "linkedNodes": {} }, "PzGQyuiSYQ": { "type": { "resolvedName": "Container" }, "isCanvas": true, "props": { "padding": 0, "margin": 1, "flexWrap": true, "flexDirection": "row", "justifyContent": "flex-start", "alignItems": "stretch", "width": "100%", "height": "auto", "hidden": false, "flexGrow": false, "shadow": false, "borderRadius": 0, "collapsible": false, "collapsedFooter": false, "collapsedSize": 0, "collapsedByDefault": false, "onClickTransform": false, "layout": "flex", "justifyItems": "start", "style": {}, "background": "paper" }, "displayName": "Container", "custom": { "elementName": "Container3" }, "parent": "ROOT", "hidden": false, "nodes": [ "Gy8aClqNNl", "VaM_Ww_ZWf", "WgN7o8pUE6", "_QNhcvKIrP" ], "linkedNodes": {} }, "Gy8aClqNNl": { "type": { "resolvedName": "ActionButton" }, "isCanvas": false, "props": { "margin": 6, "buttonColor": "primary", "icon": { "icon": "search", "variant": "duotone", "size": "icon" }, "width": "76px", "height": "48px", "disabled": false, "hidden": false, "useIconButton": false, "action": [ { "type": "transformation", "transformation": "$components.Table1.fn.search()", "remote": false } ], "title": "Search" }, "displayName": "Action Button", "custom": { "elementName": "ActionButton1" }, "parent": "PzGQyuiSYQ", "hidden": false, "nodes": [], "linkedNodes": {} }, "VaM_Ww_ZWf": { "type": { "resolvedName": "ActionButton" }, "isCanvas": false, "props": { "margin": 6, "buttonColor": "secondary", "icon": { "icon": "plus", "variant": "regular", "size": "icon" }, "width": "76px", "height": "48px", "disabled": false, "hidden": false, "useIconButton": false, "action": [ { "type": "form", "submitIcon": "plus", "title": "Create a new Master Unit", "fields": [ { "label": "Batch Code", "validation": { "required": false }, "dataPath": "batchCode", "field": "batchCode", "description": "", "element": "TextInput", "type": "text" }, { "label": "Number", "validation": { "required": true }, "dataPath": "number", "field": "number", "description": "", "element": "TextInput", "type": "text" } ] }, { "type": "mutation", "api": "Application", "mutation": "mutation CreateMasterUnit($payload: [MasterUnitCreatePayloadInput!]!) {\n mutation: createMasterUnit(payload: $payload) { \n id\n label\n }\n}", "transforms": { "pre": "{\n \"payload\": {\n \"create\": data\n }\n}" }, "message": { "__transform": "\"Master Unit \" & data.mutation[0].label & \" created successfully.\"" } }, { "type": "transformation", "remote": false, "transformation": "$components.Table1.fn.search()" } ], "title": "Create" }, "displayName": "Action Button", "custom": { "elementName": "ActionButton2" }, "parent": "PzGQyuiSYQ", "hidden": false, "nodes": [], "linkedNodes": {} }, "WgN7o8pUE6": { "type": { "resolvedName": "ActionButton" }, "isCanvas": false, "props": { "margin": 6, "buttonColor": "secondary", "icon": { "icon": "pencil", "variant": "duotone", "size": "icon" }, "width": "76px", "height": "48px", "disabled": { "__transform": "$count($components.Table1.selectedRows) != 1", "__dynamicFields": { "payload": [], "context": [ "components.Table1.selectedRows" ] }, "__cacheKey": "updateButton", "__remote": false }, "hidden": false, "useIconButton": false, "action": [ { "type": "form", "submitIcon": "save", "title": { "__transform": "\"Update Master Unit \" & $components.Table1.selectedRows[0].label" }, "fields": [ { "label": "Batch Code", "validation": { "required": false }, "dataPath": "batchCode", "field": "batchCode", "description": "", "element": "TextInput", "type": "text" }, { "label": "Number", "validation": { "required": true }, "dataPath": "number", "field": "number", "description": "", "element": "TextInput", "type": "text" } ], "transforms": { "pre": "$components.Table1.selectedRows[0]" } }, { "type": "mutation", "api": "Application", "mutation": "mutation UpdateMasterUnit($payload: [MasterUnitUpdatePayloadInput!]!) {\n mutation: updateMasterUnit(payload: $payload) { \n id\n label\n }\n}", "transforms": { "pre": "{\n \"payload\": $components.Table1.selectedRows.{\n \"where\": {\n \"id\": id\n },\n \"update\": $$.data\n }\n}" }, "message": { "__transform": "($count($components.Table1.selectedRows) = 1 ? (\"Master Unit \" & $components.Table1.selectedRows.label) : $count($components.Table1.selectedRows) & \" records\") & \" updated successfully.\"" } }, { "type": "transformation", "remote": false, "transformation": "$components.Table1.fn.search()" } ], "title": "Update" }, "displayName": "Action Button", "custom": { "elementName": "ActionButton3" }, "parent": "PzGQyuiSYQ", "hidden": false, "nodes": [], "linkedNodes": {} }, "_QNhcvKIrP": { "type": { "resolvedName": "ActionButton" }, "isCanvas": false, "props": { "margin": 6, "buttonColor": "error", "icon": { "icon": "trash", "variant": "solid", "size": "icon" }, "width": "76px", "height": "48px", "disabled": { "__transform": "$count($components.Table1.selectedRows) = 0", "__dynamicFields": { "payload": [], "context": [ "components.Table1.selectedRows" ] }, "__cacheKey": "deleteButton", "__remote": false }, "hidden": false, "useIconButton": false, "action": [ { "type": "confirmation", "buttonColor": "error", "submitIcon": { "icon": "trash", "variant": "solid" }, "message": { "__transform": "\"Delete \" & ($count($components.Table1.selectedRows) = 1 ? (\"Master Unit \" & $components.Table1.selectedRows.label) : $count($components.Table1.selectedRows) & \" records\") & \"?\"" } }, { "type": "mutation", "api": "Application", "mutation": "mutation DeleteMasterUnit($payload: [MasterUnitDeletePayloadInput!]!) {\n mutation: deleteMasterUnit(payload: $payload) { \n id\n label\n }\n}", "transforms": { "pre": "{\n \"payload\": $components.Table1.selectedRows.{\n \"where\": {\n \"id\": id\n }\n }\n}" }, "message": { "__transform": "($count($components.Table1.selectedRows) = 1 ? (\"Master Unit \" & $components.Table1.selectedRows.label) : $count($components.Table1.selectedRows) & \" records\") & \" deleted successfully.\"" } }, { "type": "transformation", "remote": false, "transformation": "$components.Table1.fn.search()" } ], "title": "Delete" }, "displayName": "Action Button", "custom": { "elementName": "ActionButton4" }, "parent": "PzGQyuiSYQ", "hidden": false, "nodes": [], "linkedNodes": {} }, "nXrLmn-Y-B": { "type": { "resolvedName": "Table" }, "isCanvas": true, "props": { "margin": 1, "width": "100%", "height": "auto", "flexGrow": true, "query": { "api": "Application", "model": "MasterUnit", "query": null, "dataPath": "edges", "dataTransform": { "transform": null, "remote": true }, "dataSubscription": { "enabled": false }, "autoLoad": true, "fields": [ "id" ] }, "selectable": "single", "showToolPanels": true, "showStatusBar": true, "enableGrouping": true, "enableCharts": true, "showColumnMenu": true, "enableRowDragging": false, "masterDetail": false, "filterFormName": "Form1", "description": "", "rowMultiSelectWithClick": false }, "displayName": "Table", "custom": { "elementName": "Table1" }, "parent": "ROOT", "hidden": false, "nodes": [ "cMayo00oRN", "F61nDfscs-", "GJjP9Pge0" ], "linkedNodes": {} }, "cMayo00oRN": { "type": { "resolvedName": "TableColumn" }, "isCanvas": false, "props": { "label": "Batch Code", "format": "text", "field": "batchCode", "dataPath": "batchCode", "description": "" }, "displayName": "Table Column", "custom": { "elementName": "TableColumn1" }, "parent": "nXrLmn-Y-B", "hidden": false, "nodes": [], "linkedNodes": {} }, "F61nDfscs-": { "type": { "resolvedName": "TableColumn" }, "isCanvas": false, "props": { "label": "Number", "format": "text", "field": "number", "dataPath": "number", "description": "" }, "displayName": "Table Column", "custom": { "elementName": "TableColumn2" }, "parent": "nXrLmn-Y-B", "hidden": false, "nodes": [], "linkedNodes": {} }, "GJjP9Pge0": { "type": { "resolvedName": "TableColumn" }, "isCanvas": false, "props": { "label": "Inventory Quantity", "format": "text", "dataPath": "inventories.edges.0.node.quantity._aggregate.value.sum", "field": "inventories.edges.node._aggregate.quantity.value.sum", "query": { "fields": [ "inventories.edges.node.quantity._aggregate.value.sum" ] } }, "displayName": "Table Column", "custom": { "elementName": "TableColumn3" }, "parent": "nXrLmn-Y-B", "hidden": false, "nodes": [], "linkedNodes": {} } } } } ] } }, "routes": [ { "id": "clp8xlsvi002b0775gutk2zeo", "title": "Master Units with Inventory Sum", "path": "/materialsManagement/inventory/masterUnits", "moduleId": "inventory", "screenId": "masterUnitsWithInventorySum", "isMenuAccessible": false, "submenu": "" } ] }, { "header": { "id": "inventoryQuantityByUnit", "name": "Inventory Quantity By Unit", "description": "", "active": true, "isWidget": false }, "version": { "id": "clqbgh010000207750ib40t54", "number": "0.0.1", "description": "", "screenId": "inventoryQuantityByUnit", "design": { "components": [ { "type": "canvas", "name": "InventoryTable", "tabTitle": "Inventory Table", "props": { "design": { "ROOT": { "type": { "resolvedName": "Screen" }, "isCanvas": true, "props": { "padding": 0, "margin": 0, "flexDirection": "column", "flexWrap": false, "alignItems": "stretch", "justifyContent": "flex-start", "width": "100%", "height": "100%", "hidden": false, "flexGrow": false, "shadow": false, "borderRadius": 0 }, "displayName": "Screen", "custom": { "elementName": "Screen", "elementCounts": { "Container": 3, "Action Button": 4, "Form": 1, "Table": 1, "Text": 1, "Float": 2, "Combobox": 1, "Table Column": 3 }, "module": { "id": "materials", "group": { "id": "productDataManagement" } }, "dataModel": "Inventory", "template": "table" }, "parent": null, "hidden": false, "nodes": [ "Z9AQBZ4RaQ", "erGE_lS8In", "YKT1NZbiOF" ], "linkedNodes": {} }, "Z9AQBZ4RaQ": { "type": { "resolvedName": "Container" }, "isCanvas": true, "props": { "padding": 0, "margin": 0, "flexWrap": false, "flexDirection": "column", "justifyContent": "flex-start", "alignItems": "stretch", "width": "100%", "height": "auto", "hidden": false, "flexGrow": false, "shadow": false, "borderRadius": 0, "collapsible": false, "collapsedFooter": false, "collapsedSize": 0, "collapsedByDefault": false, "onClickTransform": false, "layout": "flex", "justifyItems": "start", "style": {} }, "displayName": "Container", "custom": { "elementName": "Container1" }, "parent": "ROOT", "hidden": false, "nodes": [ "QxchT8vPHQ" ], "linkedNodes": {} }, "QxchT8vPHQ": { "type": { "resolvedName": "Form" }, "isCanvas": true, "props": { "query": { "api": "Application", "model": "Inventory", "query": null, "dataPath": "edges[0]", "dataTransform": { "transform": null, "remote": true }, "dataSubscription": { "enabled": false }, "autoLoad": false }, "blockNavigationWhenDirty": false }, "displayName": "Form", "custom": { "elementName": "Form1" }, "parent": "Z9AQBZ4RaQ", "hidden": false, "nodes": [ "38Op7b9rqn" ], "linkedNodes": {} }, "38Op7b9rqn": { "type": { "resolvedName": "Container" }, "isCanvas": true, "props": { "padding": 8, "margin": 1, "flexWrap": true, "flexDirection": "row", "justifyContent": "flex-start", "alignItems": "flex-end", "width": "100%", "height": "auto", "hidden": false, "flexGrow": false, "shadow": false, "borderRadius": 0, "collapsible": true, "collapsedFooter": false, "collapsedSize": 0, "collapsedByDefault": false, "onClickTransform": false, "layout": "flex", "justifyItems": "start", "style": {}, "background": "paper" }, "displayName": "Container", "custom": { "elementName": "Container2" }, "parent": "QxchT8vPHQ", "hidden": false, "nodes": [ "qk4x2f2bT5", "3uo2_Ej1Vv", "LQr1II0TT0", "hidEa1mjbY" ], "linkedNodes": {} }, "qk4x2f2bT5": { "type": { "resolvedName": "TextInput" }, "isCanvas": false, "props": { "type": "text", "padding": 8, "width": "300px", "height": "auto", "label": "Number", "validation": { "required": false }, "visible": true, "formElement": "Form1", "dataPath": "number", "field": "number", "description": "", "element": "TextInput", "predicate": "_contains", "target": { "dataPath": "number._contains" } }, "displayName": "Text", "custom": { "elementName": "Text1" }, "parent": "38Op7b9rqn", "hidden": false, "nodes": [], "linkedNodes": {} }, "3uo2_Ej1Vv": { "type": { "resolvedName": "FloatInput" }, "isCanvas": false, "props": { "type": "float", "padding": 8, "width": "300px", "height": "auto", "label": "Quantity Min", "validation": { "required": false }, "visible": true, "formElement": "Form1", "dataPath": "quantity.value._gte", "field": "quantity", "description": "", "element": "FloatInput", "predicate": "_gte" }, "displayName": "Float", "custom": { "elementName": "Float1" }, "parent": "38Op7b9rqn", "hidden": false, "nodes": [], "linkedNodes": {} }, "LQr1II0TT0": { "type": { "resolvedName": "FloatInput" }, "isCanvas": false, "props": { "type": "float", "padding": 8, "width": "300px", "height": "auto", "label": "Quantity Max", "validation": { "required": false }, "visible": true, "formElement": "Form1", "dataPath": "quantity.value._lte", "field": "quantity", "description": "", "element": "FloatInput", "predicate": "_lte" }, "displayName": "Float", "custom": { "elementName": "Float2" }, "parent": "38Op7b9rqn", "hidden": false, "nodes": [], "linkedNodes": {} }, "hidEa1mjbY": { "type": { "resolvedName": "Combobox" }, "isCanvas": false, "props": { "type": "combobox", "padding": 8, "width": "300px", "height": "auto", "label": "Quantity Unit", "multiselect": true, "isClearable": true, "api": "Application", "validation": { "required": false }, "visible": true, "formElement": "Form1", "dataPath": "quantity.unit", "field": "quantity", "description": "", "element": "Combobox", "predicate": "_in", "target": { "dataPath": "quantity.unit.id._in" }, "queryType": "Unit", "labelField": "name" }, "displayName": "Combobox", "custom": { "elementName": "Combobox1" }, "parent": "38Op7b9rqn", "hidden": false, "nodes": [], "linkedNodes": {} }, "erGE_lS8In": { "type": { "resolvedName": "Container" }, "isCanvas": true, "props": { "padding": 0, "margin": 1, "flexWrap": true, "flexDirection": "row", "justifyContent": "flex-start", "alignItems": "stretch", "width": "100%", "height": "auto", "hidden": false, "flexGrow": false, "shadow": false, "borderRadius": 0, "collapsible": false, "collapsedFooter": false, "collapsedSize": 0, "collapsedByDefault": false, "onClickTransform": false, "layout": "flex", "justifyItems": "start", "style": {}, "background": "paper" }, "displayName": "Container", "custom": { "elementName": "Container3" }, "parent": "ROOT", "hidden": false, "nodes": [ "0QiXDOujNU", "826yIE9Zqi", "ECVlkG8l0E", "dSL0fh-oMD" ], "linkedNodes": {} }, "0QiXDOujNU": { "type": { "resolvedName": "ActionButton" }, "isCanvas": false, "props": { "margin": 6, "buttonColor": "primary", "icon": { "icon": "search", "variant": "duotone", "size": "icon" }, "width": "76px", "height": "48px", "disabled": false, "hidden": false, "useIconButton": false, "action": [ { "type": "transformation", "transformation": "$components.Table1.fn.search()", "remote": false } ], "title": "Search" }, "displayName": "Action Button", "custom": { "elementName": "ActionButton1" }, "parent": "erGE_lS8In", "hidden": false, "nodes": [], "linkedNodes": {} }, "826yIE9Zqi": { "type": { "resolvedName": "ActionButton" }, "isCanvas": false, "props": { "margin": 6, "buttonColor": "secondary", "icon": { "icon": "plus", "variant": "regular", "size": "icon" }, "width": "76px", "height": "48px", "disabled": false, "hidden": false, "useIconButton": false, "action": [ { "type": "form", "submitIcon": "plus", "title": "Create a new Inventory", "fields": [ { "label": "Number", "validation": { "required": true }, "dataPath": "number", "field": "number", "description": "", "element": "TextInput", "type": "text" }, { "label": "Quantity", "validation": { "required": true }, "dataPath": "quantity", "field": "quantity", "description": "", "element": "MeasureInput", "type": "measure", "query": { "fields": [ "quantity.value", "quantity.unit.code", "quantity.unit.id" ] } } ] }, { "type": "mutation", "api": "Application", "mutation": "mutation CreateInventory($payload: [InventoryCreatePayloadInput!]!) {\n mutation: createInventory(payload: $payload) { \n id\n label\n }\n}", "transforms": { "pre": "{\n \"payload\": {\n \"create\": data\n }\n}" }, "message": { "__transform": "\"Inventory \" & data.mutation[0].label & \" created successfully.\"" } }, { "type": "transformation", "remote": false, "transformation": "$components.Table1.fn.search()" } ], "title": "Create" }, "displayName": "Action Button", "custom": { "elementName": "ActionButton2" }, "parent": "erGE_lS8In", "hidden": false, "nodes": [], "linkedNodes": {} }, "ECVlkG8l0E": { "type": { "resolvedName": "ActionButton" }, "isCanvas": false, "props": { "margin": 6, "buttonColor": "secondary", "icon": { "icon": "pencil", "variant": "duotone", "size": "icon" }, "width": "76px", "height": "48px", "disabled": { "__transform": "$count($components.Table1.selectedRows) != 1", "__dynamicFields": { "payload": [], "context": [ "components.Table1.selectedRows" ] }, "__cacheKey": "updateButton", "__remote": false }, "hidden": false, "useIconButton": false, "action": [ { "type": "form", "submitIcon": "save", "title": { "__transform": "\"Update Inventory \" & $components.Table1.selectedRows[0].label" }, "fields": [ { "label": "Number", "validation": { "required": true }, "dataPath": "number", "field": "number", "description": "", "element": "TextInput", "type": "text" }, { "label": "Quantity", "validation": { "required": true }, "dataPath": "quantity", "field": "quantity", "description": "", "element": "MeasureInput", "type": "measure", "query": { "fields": [ "quantity.value", "quantity.unit.code", "quantity.unit.id" ] } } ], "transforms": { "pre": "$components.Table1.selectedRows[0]" } }, { "type": "mutation", "api": "Application", "mutation": "mutation UpdateInventory($payload: [InventoryUpdatePayloadInput!]!) {\n mutation: updateInventory(payload: $payload) { \n id\n label\n }\n}", "transforms": { "pre": "{\n \"payload\": $components.Table1.selectedRows.{\n \"where\": {\n \"id\": id\n },\n \"update\": $$.data\n }\n}" }, "message": { "__transform": "($count($components.Table1.selectedRows) = 1 ? (\"Inventory \" & $components.Table1.selectedRows.label) : $count($components.Table1.selectedRows) & \" records\") & \" updated successfully.\"" } }, { "type": "transformation", "remote": false, "transformation": "$components.Table1.fn.search()" } ], "title": "Update" }, "displayName": "Action Button", "custom": { "elementName": "ActionButton3" }, "parent": "erGE_lS8In", "hidden": false, "nodes": [], "linkedNodes": {} }, "dSL0fh-oMD": { "type": { "resolvedName": "ActionButton" }, "isCanvas": false, "props": { "margin": 6, "buttonColor": "error", "icon": { "icon": "trash", "variant": "solid", "size": "icon" }, "width": "76px", "height": "48px", "disabled": { "__transform": "$count($components.Table1.selectedRows) = 0", "__dynamicFields": { "payload": [], "context": [ "components.Table1.selectedRows" ] }, "__cacheKey": "deleteButton", "__remote": false }, "hidden": false, "useIconButton": false, "action": [ { "type": "confirmation", "buttonColor": "error", "submitIcon": { "icon": "trash", "variant": "solid" }, "message": { "__transform": "\"Delete \" & ($count($components.Table1.selectedRows) = 1 ? (\"Inventory \" & $components.Table1.selectedRows.label) : $count($components.Table1.selectedRows) & \" records\") & \"?\"" } }, { "type": "mutation", "api": "Application", "mutation": "mutation DeleteInventory($payload: [InventoryDeletePayloadInput!]!) {\n mutation: deleteInventory(payload: $payload) { \n id\n label\n }\n}", "transforms": { "pre": "{\n \"payload\": $components.Table1.selectedRows.{\n \"where\": {\n \"id\": id\n }\n }\n}" }, "message": { "__transform": "($count($components.Table1.selectedRows) = 1 ? (\"Inventory \" & $components.Table1.selectedRows.label) : $count($components.Table1.selectedRows) & \" records\") & \" deleted successfully.\"" } }, { "type": "transformation", "remote": false, "transformation": "$components.Table1.fn.search()" } ], "title": "Delete" }, "displayName": "Action Button", "custom": { "elementName": "ActionButton4" }, "parent": "erGE_lS8In", "hidden": false, "nodes": [], "linkedNodes": {} }, "YKT1NZbiOF": { "type": { "resolvedName": "Table" }, "isCanvas": true, "props": { "margin": 1, "width": "100%", "height": "auto", "flexGrow": true, "query": { "api": "Application", "model": "Inventory", "query": null, "dataPath": "edges", "dataTransform": { "transform": null, "remote": true }, "dataSubscription": { "enabled": false }, "autoLoad": true, "fields": [ "id" ] }, "selectable": "single", "showToolPanels": true, "showStatusBar": true, "enableGrouping": true, "enableCharts": true, "showColumnMenu": true, "enableRowDragging": false, "masterDetail": false, "filterFormName": "Form1", "description": "", "rowMultiSelectWithClick": false }, "displayName": "Table", "custom": { "elementName": "Table1" }, "parent": "ROOT", "hidden": false, "nodes": [ "uzItzR1juR", "-IzobXWHxQ" ], "linkedNodes": {} }, "uzItzR1juR": { "type": { "resolvedName": "TableColumn" }, "isCanvas": false, "props": { "label": "Quantity Unit Id", "format": "text", "field": "quantity.unitId", "dataPath": "quantity.unitId" }, "displayName": "Table Column", "custom": { "elementName": "TableColumn2" }, "parent": "YKT1NZbiOF", "hidden": false, "nodes": [], "linkedNodes": {} }, "-IzobXWHxQ": { "type": { "resolvedName": "TableColumn" }, "isCanvas": false, "props": { "label": "Quantity Aggregate Value Sum", "format": "float", "field": "quantity._aggregate.value.sum", "dataPath": "quantity._aggregate.value.sum", "description": "The sum of the grouped field values." }, "displayName": "Table Column", "custom": { "elementName": "TableColumn3" }, "parent": "YKT1NZbiOF", "hidden": false, "nodes": [], "linkedNodes": {} } } } } ] } }, "routes": [] } ], "savedTransforms": [], "data": [ { "api": "application", "modelName": "InventoryStatus", "payload": [ { "id": "depleted", "active": false, "label": "Depleted" }, { "id": "good", "active": true, "label": "Good" }, { "id": "hold", "active": false, "label": "Hold" }, { "id": "suspect", "active": true, "label": "Suspect" } ], "metadata": {} }, { "api": "application", "modelName": "ModuleGroup", "payload": [ { "id": "materialsManagement", "name": "Materials Management", "icon": "boxes" }, { "id": "productDataManagement", "name": "Product Data Management", "icon": "clipboard" } ], "metadata": {} }, { "api": "application", "modelName": "Module", "payload": [ { "id": "inventory", "name": "Inventory", "description": "Functionality around managing inventory, such as inventory data, move, split, and merge.", "moduleGroupId": "materialsManagement" }, { "id": "materials", "name": "Materials", "description": "Functionality around managing material data, such as heats, grades, and lots.", "moduleGroupId": "productDataManagement" } ], "metadata": {} }, { "api": "application", "modelName": "SavedQuery", "payload": [ { "id": "inventoryAggregateExamples", "name": "Inventory Aggregate Examples", "description": "", "queryText": "query InventoryAggregate {\n qty: inventory {\n edges {\n node {\n quantity {\n _aggregate {\n value {\n sum\n }\n }\n }\n }\n }\n }\n inventory {\n edges {\n node {\n quantity {\n unit {\n code\n }\n _aggregate {\n value {\n sum\n }\n }\n }\n }\n }\n }\n countByActive: inventory {\n edges {\n node {\n inventoryStatus {\n active\n }\n quantity {\n _aggregate {\n value {\n sum\n }\n }\n }\n _aggregate {\n id {\n count\n }\n }\n }\n }\n }\n qtyByMasterUnit: inventory(orderBy: {field: masterUnitId, direction: asc}) {\n edges {\n node {\n masterUnit {\n number\n }\n quantity {\n _aggregate {\n value {\n sum\n }\n }\n }\n }\n }\n }\n activeMasterUnitQty: masterUnit {\n edges {\n node {\n number\n inventories(where: {inventoryStatus: {active: {_eq: true}}}) {\n edges {\n node {\n quantity {\n _aggregate {\n value {\n sum\n }\n }\n }\n }\n }\n }\n }\n }\n }\n masterUnitsWithSuspectInventory: inventory(where: {inventoryStatusId: {_eq: \"suspect\"}}) {\n edges {\n node {\n quantity {\n _aggregate {\n value {\n sum\n }\n }\n }\n masterUnit {\n _aggregate {\n number {\n uniqueValues\n }\n }\n }\n }\n }\n }\n batchStatistics: inventory {\n edges {\n node {\n masterUnit {\n batchCode\n }\n quantity {\n unit {\n code\n }\n _aggregate {\n value {\n count\n average\n standardDeviation\n minimum\n maximum\n }\n }\n }\n }\n }\n }\n}\n" } ], "metadata": {} } ] }