Allow related tables (ie Data Links) to display in the table view rather than in the result details/results list

Commentaire officiel
Christian Wohlmutter
18 février 2026 21:59
This feature is planned. You can follow the state in the changelog under the ID 365786.
Michael Davis
27 mars 2025 12:15
Please make this happen soon VertiGIS
8
Maarten van Roest
17 avril 2025 15:49 Modifié
We want this as well. yesterday!
7
Lauren MacLean
23 mai 2025 04:21
This!
Belinda is always right on the money VertiGIS - this is basic, essential functionality particularly in local government. We also need to be able to then export everything to one excel, as we currently can in essentials.
5
Lauren MacLean
8 août 2025 03:54 Modifié
Hi All,
Just an FYI: we have opted to change our datalinks to related tables in the service. I now have a workflow run from the results list/table that loops through results, finds any related tables, queries them and adds the outputs to the results list/table.
I can't attach the workflow here but I will add the json in a code block below if anyone wants to use it.
{"_properties":{"isServerWorkflow":false},"components":[{"id":2,"steps":[{"id":3,"inputs":{},"position":"-240,-1310","purpose":"start","title":"Start","transitions":[{"id":348,"position":"-150,-1250 -150,-1200","sourceConnector":"bottom","target":{"id":167}}]},{"action":"gcx:wf:core::GetWorkflowInputs","id":66,"inputs":{},"name":"getWorkflowInputs","position":"-270,-1100","title":"Get Workflow Inputs","transitions":[{"id":360,"position":"-150,-1040 -150,-1010","sourceConnector":"bottom","target":{"id":220}}]},{"action":"gcx:wf:core:loop:ForEach","id":150,"inputs":{"items":{"accessors":["$getWorkflowInputs"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$getWorkflowInputs.inputs.context","source":"$getWorkflowInputs.inputs.context"}},"name":"forEachResult","position":"-280,-650","title":"For Each","transitions":[{"id":277,"position":"-160,-530 -160,-500 -140,-500 -140,-480","sourceConnector":"bottom","target":{"id":275}}]},{"action":"gcx:wf:core::Annotation","description":"This workflow is run from a results list or table. It does the following steps\n\n+ Takes input features (results)\n\n+ Loops through and builds a list of OIDs per layer (ie if there are 3 results from one layer and 2 from another, two lists of OIDs will be built\n+ Checks if the current results' layer has any relationships\n+ If there is (one or more) relationships; run a query relationships task\n+ Loop through the results of the relationship query and add them to featuresets with the relevant name\n+ Select the featuresets in the map","id":159,"inputs":{},"position":"-880,-650","title":"Notes"},{"action":"gcx:wf:arcgis::GetMap","id":167,"inputs":{},"name":"map1","position":"-270,-1200","title":"Get Map","transitions":[{"id":169,"inputs":{},"position":"-150,-1140 -150,-1100","target":{"id":66}}]},{"action":"gcx:wf:core::Container","id":220,"inputs":{},"position":"-270,-1010","title":"Variable Prep","transitions":[{"id":274,"position":"-30,-965 -10,-965 -10,-890 -270,-890 -270,-855 -250,-855","sourceConnector":"right","target":{"id":285},"targetConnector":"left"}]},{"action":"gcx:wf:app::RunOperation","id":267,"inputs":{"operationName":"results.convert-to-xlsx","operationParameter":{"accessors":["$FinalResultsCollection","$map1"],"annotations":[{"count":23,"index":11,"kind":"idref"},{"count":5,"index":50,"kind":"idref"}],"code":"{ features: $FinalResultsCollection.result, maps: [$map1.map.extension] }","source":"{ features:$FinalResultsCollection.result, maps: [$map1.map.extension] }"}},"name":"runOperation101","position":"110,-680","title":"results.convert-to-xlsx","transitions":[{"id":273,"inputs":{},"position":"230,-620 230,-550","target":{"id":271}}]},{"action":"gcx:wf:app::RunCommand","id":271,"inputs":{"commandName":"system.download-file","commandParameter":{"accessors":["$runOperation101"],"annotations":[{"count":16,"index":0,"kind":"idref"}],"code":"$runOperation101.result","source":"$runOperation101.result"}},"name":"runCommand102","position":"110,-550","title":"system.download-file"},{"action":"gcx:wf:core::Switch","id":275,"inputs":{"value":{"accessors":["$getWorkflowInputs"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$getWorkflowInputs.inputs.outputresult","source":"$getWorkflowInputs.inputs.outputresult"}},"position":"-200,-480","title":"Switch","transitions":[{"id":284,"position":"40,-450 90,-450 90,-650 110,-650","purpose":"default","sourceConnector":"right","target":{"id":267},"targetConnector":"left","title":"excel"},{"branch":"display","id":288,"position":"-200,-450 -260,-450 -260,-340","sourceConnector":"left","target":{"id":287}}]},{"action":"gcx:wf:core::AddItems","id":285,"inputs":{"collection":{"accessors":["$FinalResultsCollection"],"annotations":[{"count":23,"index":0,"kind":"idref"}],"code":"$FinalResultsCollection.result","source":"$FinalResultsCollection.result"},"itemsToAdd":{"accessors":["$getWorkflowInputs"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$getWorkflowInputs.inputs.context","source":"$getWorkflowInputs.inputs.context"}},"position":"-250,-870","title":"Add Items","transitions":[{"id":286,"position":"-130,-840 -130,-750 -170,-750 -170,-730","sourceConnector":"bottom","target":{"id":378},"targetConnector":"top"}]},{"action":"gcx:wf:core::Exit","id":287,"inputs":{},"position":"-350,-340","title":"Exit"},{"action":"gcx:wf:arcgis::SelectFeatures","id":378,"inputs":{"combineMode":"replace"},"position":"-290,-730","title":"Clear Results","transitions":[{"id":380,"position":"-170,-700 -170,-670 -160,-670 -160,-650","target":{"id":150}}]}]},{"id":101,"steps":[{"id":103,"inputs":{},"position":"0,0","purpose":"start","title":"For Each","transitions":[{"id":111,"inputs":{},"position":"90,60 90,100","target":{"id":105}}]},{"action":"gcx:wf:core::CreateValue","id":105,"inputs":{"expression":{"accessors":["$forEachPropertyOID"],"annotations":[{"count":19,"index":0,"kind":"idref"}],"code":"$forEachPropertyOID.item","source":"$forEachPropertyOID.item"}},"name":"objectID","position":"-30,100","title":"Create Value","transitions":[{"id":174,"inputs":{},"position":"90,160 90,190","sourceConnector":"bottom","target":{"id":107}}]},{"action":"gcx:wf:core::CreateValue","id":107,"inputs":{"expression":{"accessors":["$queryRelationship1","$objectID"],"annotations":[{"count":19,"index":0,"kind":"idref"},{"count":9,"index":28,"kind":"idref"}],"code":"$queryRelationship1.results[$objectID.result].features","source":"$queryRelationship1.results[$objectID.result].features"}},"name":"resultFeatures","position":"-30,190","title":"Create Value","transitions":[{"id":115,"inputs":{},"position":"90,250 90,280","sourceConnector":"bottom","target":{"id":109}}]},{"action":"gcx:wf:core:loop:ForEach","id":109,"inputs":{"items":{"accessors":["$resultFeatures"],"annotations":[{"count":15,"index":0,"kind":"idref"}],"code":"$resultFeatures.result","source":"$resultFeatures.result"}},"name":"forEachRelatedResult","position":"-30,280","title":"For Each"}]},{"id":117,"steps":[{"action":"gcx:wf:core::AddItem","id":119,"inputs":{"collection":{"accessors":["$resultCollection"],"annotations":[{"count":17,"index":0,"kind":"idref"}],"code":"$resultCollection.result","source":"$resultCollection.result"},"item":{"accessors":["$forEachRelatedResult"],"annotations":[{"count":21,"index":0,"kind":"idref"}],"code":"$forEachRelatedResult.item","source":"$forEachRelatedResult.item"}},"position":"-60,160","title":"Add Item"},{"id":121,"inputs":{},"position":"0,0","purpose":"start","title":"For Each","transitions":[{"id":123,"inputs":{},"position":"90,60 90,140 60,140 60,160","target":{"id":119}}]}]},{"id":151,"steps":[{"id":152,"inputs":{},"position":"0,-1630","purpose":"start","title":"For Each","transitions":[{"id":396,"inputs":{},"position":"90,-1570 90,-1460","sourceConnector":"bottom","target":{"id":395}}]},{"action":"gcx:wf:core::Log","id":156,"inputs":{"message":"Reset values for this run"},"position":"-970,510","title":"Finish off current run","transitions":[{"id":160,"inputs":{},"position":"-850,510 -850,-860 -260,-860 -260,-840","sourceConnector":"top","target":{"id":231},"targetConnector":"top"}]},{"action":"gcx:wf:core::Log","id":161,"inputs":{"message":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":17,"kind":"idref"}],"code":"\"pass number: \" + $forEachResult.pass.toString()","source":"`pass number: `+ $forEachResult.pass.toString()"}},"name":"LogPASSNum","position":"-350,110","title":"Log","transitions":[{"id":172,"inputs":{},"position":"-230,170 -230,210","target":{"id":171}}]},{"action":"gcx:wf:core::Log","id":171,"inputs":{"message":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$forEachResult.count - 1","source":"$forEachResult.count-1"}},"name":"LogFeatureCount","position":"-350,210","title":"Log","transitions":[{"id":173,"inputs":{},"position":"-230,270 -230,285 -240,285 -240,300","target":{"id":241},"targetConnector":"top"}]},{"action":"gcx:wf:core::Log","id":180,"inputs":{"message":{"accessors":[],"code":"\"Change of layer name detected\"","source":"\"Change of layer name detected\""}},"position":"90,230","title":"Layer name changed","transitions":[{"id":221,"inputs":{},"position":"210,260 210,370 260,370 260,560 220,560 220,580","sourceConnector":"bottom","target":{"id":222},"targetConnector":"top"}]},{"action":"gcx:wf:core::If","description":"<-- \"sublayer\"\n\n                      \"layer\" -->","id":186,"inputs":{"condition":{"accessors":["$forEachResult","NULL"],"annotations":[{"count":14,"index":0,"kind":"idref"},{"count":4,"index":34,"kind":"idref"}],"code":"$forEachResult.item.source.layer == NULL","source":"$forEachResult.item.source.layer==NULL"}},"name":"IfSubLayer","position":"-380,-660","title":"If","transitions":[{"branch":"false","id":198,"inputs":{},"position":"-140,-575 -60,-575 -60,-590 -40,-590","sourceConnector":"right","target":{"id":197}},{"branch":"true","id":199,"inputs":{},"position":"-380,-575 -470,-575 -470,-590 -490,-590","sourceConnector":"left","target":{"id":192},"targetConnector":"right"}]},{"action":"gcx:wf:arcgis::GetLayer","id":192,"inputs":{"layerId":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$forEachResult.item.source.sublayer.parent.id","source":"$forEachResult.item.source.sublayer.parent.id"},"sublayerId":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$forEachResult.item.source.sublayer.id","source":"$forEachResult.item.source.sublayer.id"}},"name":"subLayer","position":"-730,-620","title":"Get Layer","transitions":[{"id":210,"inputs":{},"position":"-610,-560 -610,-520","sourceConnector":"bottom","target":{"id":208}}]},{"action":"gcx:wf:arcgis::GetLayer","id":197,"inputs":{"layerId":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$forEachResult.item.source.layer.id","source":"$forEachResult.item.source.layer.id"}},"name":"Layer","position":"-40,-620","title":"Get Layer","transitions":[{"id":216,"inputs":{},"position":"80,-560 80,-530","sourceConnector":"bottom","target":{"id":215}}]},{"action":"gcx:wf:core::If","description":"<-- Title doesn't match previous run\n\nTitle DOES match previous run -->","id":200,"inputs":{"condition":{"accessors":["$forEachResult","$varLayerName"],"annotations":[{"count":14,"index":0,"kind":"idref"},{"count":13,"index":34,"kind":"idref"}],"code":"$forEachResult.item.source.title != $varLayerName.result","source":"$forEachResult.item.source.title!=$varLayerName.result"}},"name":"IfTitleMatchesPreviousResult","position":"210,-150","title":"If","transitions":[{"branch":"true","id":181,"inputs":{},"position":"210,-75 190,-75 190,210 210,210 210,230","sourceConnector":"left","target":{"id":180}},{"branch":"false","id":240,"inputs":{},"position":"450,-75 540,-75 540,-60 560,-60","sourceConnector":"right","target":{"id":239}}]},{"action":"gcx:wf:core::If","description":"<---  This is the first pass\n\n    This is NOT the first pass -->","id":203,"inputs":{"condition":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$forEachResult.pass == 0","source":"$forEachResult.pass==0"}},"name":"IfFirstPass","position":"-20,-900","title":"If","transitions":[{"branch":"false","id":219,"inputs":{},"position":"220,-815 330,-815 330,-150","sourceConnector":"right","target":{"id":200},"targetConnector":"top"},{"branch":"true","id":232,"inputs":{},"position":"-20,-815 -140,-810","sourceConnector":"left","target":{"id":231}}]},{"action":"gcx:wf:core::SetProperty","id":208,"inputs":{"object":{"accessors":["$varCurrentLayer"],"annotations":[{"count":16,"index":0,"kind":"idref"}],"code":"$varCurrentLayer","source":"$varCurrentLayer"},"propertyName":"result","propertyValue":{"accessors":["$subLayer"],"annotations":[{"count":9,"index":0,"kind":"idref"}],"code":"$subLayer.sublayer","source":"$subLayer.sublayer"}},"name":"setCurrentLayerAsSublayer","position":"-730,-520","title":"Set Property","transitions":[{"id":212,"inputs":{},"position":"-610,-460 -610,90 -230,90 -230,110","sourceConnector":"bottom","target":{"id":161},"targetConnector":"top"}]},{"action":"gcx:wf:core::Log","id":209,"inputs":{"message":"Not the last pass, start foreach again"},"position":"-750,390","title":"Log"},{"action":"gcx:wf:core::SetProperty","id":215,"inputs":{"object":{"accessors":["$varCurrentLayer"],"annotations":[{"count":16,"index":0,"kind":"idref"}],"code":"$varCurrentLayer","source":"$varCurrentLayer"},"propertyName":"result","propertyValue":{"accessors":["$Layer"],"annotations":[{"count":6,"index":0,"kind":"idref"}],"code":"$Layer.layer","source":"$Layer.layer"}},"name":"setCurrentLayerAsLayer","position":"-40,-530","title":"Set Property","transitions":[{"id":213,"inputs":{},"position":"80,-470 80,90 -230,90 -230,110","sourceConnector":"bottom","target":{"id":161},"targetConnector":"top"}]},{"action":"gcx:wf:core::If","description":"<--  no relationships\n\n       has relationships -->","id":222,"inputs":{"condition":{"accessors":["$varCurrentLayer"],"annotations":[{"count":16,"index":0,"kind":"idref"}],"code":"$varCurrentLayer.result.relationships.length == 0","source":"$varCurrentLayer.result.relationships.length==0"}},"name":"IFNoRelationships","position":"100,580","title":"If","transitions":[{"branch":"false","id":223,"inputs":{},"position":"340,665 460,670","sourceConnector":"right","target":{"id":254},"targetConnector":"left"},{"branch":"true","id":242,"inputs":{},"position":"100,665 10,665 10,840","sourceConnector":"left","target":{"id":238},"targetConnector":"top"}]},{"action":"gcx:wf:core::SetProperty","id":231,"inputs":{"object":{"accessors":["$varLayerName"],"annotations":[{"count":13,"index":0,"kind":"idref"}],"code":"$varLayerName","source":"$varLayerName"},"propertyName":"result","propertyValue":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$forEachResult.item.source.title","source":"$forEachResult.item.source.title"}},"name":"setPropertyLayerTitle","position":"-380,-840","title":"Set Layer Title","transitions":[{"id":235,"inputs":{},"position":"-260,-780 -260,-750","sourceConnector":"bottom","target":{"id":234}}]},{"action":"gcx:wf:core::SetProperty","id":233,"inputs":{"object":{"accessors":["$varLastPass"],"annotations":[{"count":12,"index":0,"kind":"idref"}],"code":"$varLastPass","source":"$varLastPass"},"propertyName":"result","propertyValue":1},"position":"-40,480","title":"Set Property","transitions":[{"id":237,"inputs":{},"position":"200,495 220,495 220,580","target":{"id":222}}]},{"action":"gcx:wf:core::SetProperty","id":234,"inputs":{"object":{"accessors":["$varOIDs"],"annotations":[{"count":8,"index":0,"kind":"idref"}],"code":"$varOIDs","source":"$varOIDs"},"propertyName":"result","propertyValue":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$forEachResult.item.primaryKey","source":"$forEachResult.item.primaryKey"}},"name":"setPropertyResultOID","position":"-380,-750","title":"Set OID","transitions":[{"id":142,"inputs":{},"position":"-260,-690 -260,-660","sourceConnector":"bottom","target":{"id":186}}]},{"action":"gcx:wf:core::If","description":"<-- If this is the last result in the list, finish off the OID list\n\nNot the last pass go to next loop -->","id":238,"inputs":{"condition":{"accessors":["$varLastPass"],"annotations":[{"count":12,"index":0,"kind":"idref"}],"code":"$varLastPass.result == 0","source":"$varLastPass.result==0"}},"name":"IfLastPass","position":"-110,840","title":"If","transitions":[{"branch":"true","id":243,"inputs":{},"position":"-110,925 -710,925 -710,525 -730,525","sourceConnector":"left","target":{"id":156},"targetConnector":"right"},{"branch":"false","id":245,"inputs":{},"position":"130,925 200,925 200,965 220,965","sourceConnector":"right","target":{"id":244}}]},{"action":"gcx:wf:core::SetProperty","id":239,"inputs":{"object":{"accessors":["$varOIDs"],"annotations":[{"count":8,"index":0,"kind":"idref"}],"code":"$varOIDs","source":"$varOIDs"},"propertyName":"result","propertyValue":{"accessors":["$varOIDs","$forEachResult"],"annotations":[{"count":8,"index":0,"kind":"idref"},{"count":14,"index":22,"kind":"idref"}],"code":"$varOIDs.result + ',' + $forEachResult.item.primaryKey","source":"$varOIDs.result+ ','+ $forEachResult.item.primaryKey"}},"name":"SetOIDList","position":"560,-90","title":"Add to OID list","transitions":[{"id":251,"inputs":{},"position":"680,-30 680,90 -230,90 -230,110","sourceConnector":"bottom","target":{"id":161},"targetConnector":"top"}]},{"action":"gcx:wf:core::If","description":"<--  This is NOT the last pass\n\nThis is the LAST pass -->","id":241,"inputs":{"condition":{"accessors":["$forEachResult","$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"},{"count":14,"index":21,"kind":"idref"}],"code":"$forEachResult.pass != $forEachResult.count - 1","source":"$forEachResult.pass!=$forEachResult.count-1"}},"name":"IFNotLastPass","position":"-360,300","title":"If","transitions":[{"branch":"true","id":211,"inputs":{},"position":"-360,375 -490,375 -490,405 -510,405","sourceConnector":"left","target":{"id":209}},{"branch":"false","id":248,"inputs":{},"position":"-120,375 -40,375","sourceConnector":"right","target":{"id":247}}]},{"action":"gcx:wf:core::Log","id":244,"inputs":{"message":"END"},"position":"220,950","title":"END"},{"action":"gcx:wf:core::Log","id":247,"inputs":{"level":"warning","message":"This is the LAST pass"},"position":"-40,360","title":"Last Pass","transitions":[{"id":236,"inputs":{},"position":"80,390 80,480","sourceConnector":"bottom","target":{"id":233},"targetConnector":"top"}]},{"action":"gcx:wf:core:loop:ForEach","id":254,"inputs":{"items":{"accessors":["$varCurrentLayer"],"annotations":[{"count":16,"index":0,"kind":"idref"}],"code":"$varCurrentLayer.result.relationships","source":"$varCurrentLayer.result.relationships"}},"name":"forEachRelationship","position":"460,610","title":"For Each relationship"},{"action":"gcx:wf:arcgis::SelectFeatures","description":"reselects the result, needed as sometimes the related records get stuck and don't clear from the results","id":383,"inputs":{"combineMode":"union","features":{"accessors":["$forEachResult"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$forEachResult.item","source":"$forEachResult.item"}},"position":"-20,-1050","title":"Show Results","transitions":[{"id":385,"position":"100,-940 100,-900","target":{"id":203}}]},{"action":"gcx:wf:core::If","description":"no geometry. if no geometry, this is a related result and we don't want to reselect it.","id":395,"inputs":{"condition":{"accessors":["$forEachResult","NULL"],"annotations":[{"count":14,"index":0,"kind":"idref"},{"count":4,"index":32,"kind":"idref"}],"code":"$forEachResult.item.geometry == NULL","source":"$forEachResult.item.geometry == NULL"}},"position":"-30,-1460","title":"If","transitions":[{"branch":"false","id":228,"position":"210,-1400 240,-1400 240,-995 220,-995","sourceConnector":"right","target":{"id":383}},{"branch":"true","id":400,"position":"-30,-1400 -250,-1400 -250,-1445 -270,-1445","sourceConnector":"left","target":{"id":399}}]},{"action":"gcx:wf:core::Log","id":399,"inputs":{"level":"warning","message":"No geometry, this result is a related record"},"position":"-510,-1460","title":"Log"}]},{"id":205,"steps":[{"id":206,"inputs":{},"position":"0,0","purpose":"start","title":"For Each","transitions":[{"id":304,"position":"90,60 90,190 30,190 30,210","sourceConnector":"bottom","target":{"id":227}}]},{"action":"gcx:wf:core::Log","description":"layerId\nrelatedTableId","id":217,"inputs":{"message":{"accessors":["$forEachTableInMap"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$forEachTableInMap.item","source":"$forEachTableInMap.item"}},"position":"-410,480","title":"Log","transitions":[{"id":386,"position":"-290,540 -290,670","sourceConnector":"bottom","target":{"id":365}}]},{"action":"gcx:wf:core::If","id":227,"inputs":{"condition":{"accessors":["$forEachRelationship","$forEachTableInMap"],"annotations":[{"count":20,"index":0,"kind":"idref"},{"count":18,"index":43,"kind":"idref"}],"code":"$forEachRelationship.item.relatedTableId === $forEachTableInMap.item.layerId","source":"$forEachRelationship.item.relatedTableId===$forEachTableInMap.item.layerId"}},"position":"-30,210","title":"If","transitions":[{"branch":"true","id":306,"position":"-30,240 -150,240 -150,305 -170,305","target":{"id":305}}]},{"action":"gcx:wf:core::CreateValue","description":"displayField","id":305,"inputs":{"expression":{"accessors":["$forEachTableInMap"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$forEachTableInMap.item.displayField","source":"$forEachTableInMap.item.displayField"}},"name":"varDisplayField","position":"-410,260","title":"Create Value","transitions":[{"id":317,"position":"-290,350 -290,390","sourceConnector":"bottom","target":{"id":316}}]},{"action":"gcx:wf:core::SetProperty","description":"table found, exit the table loop","id":316,"inputs":{"object":{"accessors":["$varExitLoop"],"annotations":[{"count":12,"index":0,"kind":"idref"}],"code":"$varExitLoop","source":"$varExitLoop"},"propertyName":"result","propertyValue":1},"position":"-410,390","title":"Set Property","transitions":[{"id":318,"position":"-290,450 -290,480","sourceConnector":"bottom","target":{"id":217}}]},{"action":"gcx:wf:arcgis:query:QueryTask","id":364,"inputs":{},"name":"query1","position":"-80,340","title":"Query Layer"},{"action":"gcx:wf:arcgis::GetTable","id":365,"inputs":{"tableId":{"accessors":["$forEachTableInMap"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$forEachTableInMap.item.id","source":"$forEachTableInMap.item.id"}},"name":"table1","position":"-410,670","title":"Get Table","transitions":[{"id":373,"position":"-290,730 -290,780","sourceConnector":"bottom","target":{"id":372}}]},{"action":"gcx:wf:core::CreateValue","id":372,"inputs":{"expression":{"accessors":["$forEachTableInMap"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$forEachTableInMap.item.id","source":"$forEachTableInMap.item.id"}},"name":"varTableID","position":"-410,780","title":"Create Value","transitions":[{"id":375,"position":"-290,840 -290,890","sourceConnector":"bottom","target":{"id":374}}]},{"action":"gcx:wf:core::CreateValue","id":374,"inputs":{"expression":{"accessors":["$forEachTableInMap"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$forEachTableInMap.item.layerId","source":"$forEachTableInMap.item.layerId"}},"name":"varTableLayerid","position":"-410,890","title":"Create Value","transitions":[{"id":377,"position":"-290,950 -290,1000","sourceConnector":"bottom","target":{"id":376}}]},{"action":"gcx:wf:core::CreateValue","id":376,"inputs":{"expression":{"accessors":["$forEachTableInMap"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$forEachTableInMap.item.title","source":"$forEachTableInMap.item.title"}},"name":"varTableTitle","position":"-410,1000","title":"Create Value"}]},{"id":224,"steps":[{"id":225,"inputs":{},"position":"0,0","purpose":"start","title":"Container","transitions":[{"id":282,"inputs":{},"position":"90,60 90,100 100,100 100,120","sourceConnector":"bottom","target":{"id":229}}]},{"action":"gcx:wf:core::CreateValue","id":229,"inputs":{},"name":"varOIDs","position":"-20,120","title":"Create Value","transitions":[{"id":266,"inputs":{},"position":"100,180 100,210","sourceConnector":"bottom","target":{"id":246}}]},{"action":"gcx:wf:core::CreateValue","id":246,"inputs":{"expression":{"accessors":[],"code":"\"\"","source":"\"\""}},"name":"varLayerName","position":"-20,210","title":"Create Value","transitions":[{"id":268,"inputs":{},"position":"100,270 100,300","sourceConnector":"bottom","target":{"id":253}}]},{"action":"gcx:wf:core::CreateValue","id":252,"inputs":{"expression":{"accessors":[],"annotations":[],"code":"[]","source":"[]"}},"name":"FinalResultsCollection","position":"-20,800","title":"Create Value"},{"action":"gcx:wf:core::CreateValue","id":253,"inputs":{},"name":"varLayerID","position":"-20,300","title":"Create Value","transitions":[{"id":270,"inputs":{},"position":"100,360 100,390","sourceConnector":"bottom","target":{"id":259}}]},{"action":"gcx:wf:core::CreateValue","id":259,"inputs":{},"name":"varSubLayerID","position":"-20,390","title":"Create Value","transitions":[{"id":280,"inputs":{},"position":"100,450 100,480","sourceConnector":"bottom","target":{"id":279}}]},{"action":"gcx:wf:core::CreateValue","id":261,"inputs":{"expression":0},"name":"varLastPass","position":"-20,580","title":"Create Value","transitions":[{"id":276,"inputs":{},"position":"100,640 100,690","sourceConnector":"bottom","target":{"id":264}}]},{"action":"gcx:wf:core::CreateValue","id":264,"inputs":{},"name":"varRelationshipName","position":"-20,690","title":"Create Value","transitions":[{"id":258,"position":"100,750 100,800","sourceConnector":"bottom","target":{"id":252}}]},{"action":"gcx:wf:core::CreateValue","id":279,"inputs":{},"name":"varCurrentLayer","position":"-20,480","title":"Create Value","transitions":[{"id":281,"inputs":{},"position":"100,540 100,580","sourceConnector":"bottom","target":{"id":261}}]}]},{"id":255,"steps":[{"action":"gcx:wf:core::CreateValue","id":125,"inputs":{"expression":{"accessors":[],"annotations":[],"code":"[]","source":"[]"}},"name":"resultCollection","position":"290,410","title":"Create Value","transitions":[{"id":370,"position":"410,470 410,510","sourceConnector":"bottom","target":{"id":308}}]},{"action":"gcx:wf:core:loop:ForEach","id":127,"inputs":{"items":{"accessors":["Object","$queryRelationship1"],"annotations":[{"count":6,"index":0,"kind":"idref"},{"count":19,"index":12,"kind":"idref"}],"code":"Object.keys($queryRelationship1.results)","source":"Object.keys($queryRelationship1.results)"}},"name":"forEachPropertyOID","position":"290,790","title":"For Each","transitions":[{"id":371,"position":"410,910 410,960","sourceConnector":"bottom","target":{"id":289}}]},{"action":"gcx:wf:arcgis::SelectFeatures","description":"=`{`+$regexReplace2.result +`}`\n","id":129,"inputs":{"combineMode":"union","featureSetDisplayName":{"accessors":["$varTableTitle"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$varTableTitle.result","source":"$varTableTitle.result"},"features":{"accessors":["$resultCollection"],"annotations":[{"count":17,"index":0,"kind":"idref"}],"code":"$resultCollection.result","source":"$resultCollection.result"},"iconUri":"https://geox.cityofsydney.nsw.gov.au/SharedResources/Images/LayerIcons/TableResult-24.png","labelFormat":{"accessors":["$varTableTitle","$varDisplayField"],"annotations":[{"count":14,"index":0,"kind":"idref"},{"count":16,"index":31,"kind":"idref"}],"code":"$varTableTitle.result + \": {\" + $varDisplayField.result + \"}\"","source":"$varTableTitle.result + `: {`+ $varDisplayField.result +`}`"},"layerId":{"accessors":["$varTableLayerid"],"annotations":[{"count":16,"index":0,"kind":"idref"}],"code":"$varTableLayerid.result","source":"$varTableLayerid.result"},"layerName":{"accessors":["$varTableTitle"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$varTableTitle.result","source":"$varTableTitle.result"}},"name":"ShowResults","position":"-180,1390","title":"Show Results"},{"action":"gcx:wf:app::RunCommand","description":"activate related record table","id":143,"inputs":{"commandName":"ui.activate","commandParameter":{"accessors":[],"annotations":[],"code":"{\n    \"component\": \"item://results/6a1766da-90ec-4601-bfea-16e4e9ad5b21\"\n}","source":"{\n      \"component\": \"item://results/6a1766da-90ec-4601-bfea-16e4e9ad5b21\"\n    }"}},"name":"RunCommandActivateTable","position":"-180,1270","title":"Run Command","transitions":[{"id":394,"position":"-60,1360 -60,1390","sourceConnector":"bottom","target":{"id":129}}]},{"action":"gcx:wf:app::RunCommand","description":"set related results table as target","id":144,"inputs":{"commandName":"results.set-display-components","commandParameter":"results-table-48f55679"},"name":"runCommandSetDisplayComponent","position":"-180,1140","title":"Run Command","transitions":[{"id":147,"inputs":{},"position":"-60,1230 -60,1270","target":{"id":143}}]},{"action":"gcx:wf:core::TextReplace","id":146,"inputs":{"newValue":{"accessors":[],"code":"''","source":"''"},"oldValue":"sdeadmin.dl_","text":{"accessors":["$varRelationshipName"],"annotations":[{"count":20,"index":0,"kind":"idref"}],"code":"$varRelationshipName.result","source":"$varRelationshipName.result"}},"name":"textReplace1","position":"290,130","title":"Text Replace","transitions":[{"id":175,"inputs":{},"position":"410,190 410,230","sourceConnector":"bottom","target":{"id":149},"targetConnector":"top"}]},{"action":"gcx:wf:core::RegexReplace","description":"our table names need to be split by captial letterrs. eg. \"ParentProperties\" becomes \"Parent Properties\"","id":149,"inputs":{"pattern":{"accessors":[],"code":"\"([a-z])([A-Z])\"","source":"\"([a-z])([A-Z])\""},"replacement":{"accessors":[],"code":"\"$1 $2\"","source":"\"$1 $2\""},"text":{"accessors":["$textReplace1"],"annotations":[{"count":13,"index":0,"kind":"idref"}],"code":"$textReplace1.result","source":"$textReplace1.result"}},"name":"regexReplace1","position":"290,230","title":"Regular Expression Replace","transitions":[{"id":176,"inputs":{},"position":"410,370 410,410","sourceConnector":"bottom","target":{"id":125}}]},{"action":"gcx:wf:core::Annotation","description":"text replacement not relevant for some cases, but is for ours","id":162,"inputs":{},"position":"-140,250","title":"Notes"},{"action":"gcx:wf:core:loop:ForEach","id":204,"inputs":{"exit":{"accessors":["$varExitLoop"],"annotations":[{"count":12,"index":0,"kind":"idref"}],"code":"$varExitLoop.result == 1","source":"$varExitLoop.result==1"},"items":{"accessors":["$map1"],"annotations":[{"count":5,"index":0,"kind":"idref"}],"code":"$map1.map.map.tables.items","source":"$map1.map.map.tables.items"}},"name":"forEachTableInMap","position":"290,620","title":"For Eachtable","transitions":[{"id":341,"position":"410,740 410,790","sourceConnector":"bottom","target":{"id":127}}]},{"action":"gcx:wf:core::Switch","id":218,"inputs":{"value":{"accessors":["$getWorkflowInputs"],"annotations":[{"count":18,"index":0,"kind":"idref"}],"code":"$getWorkflowInputs.inputs.outputresult","source":"$getWorkflowInputs.inputs.outputresult"}},"position":"290,1100","title":"Switch","transitions":[{"id":249,"position":"530,1130 670,1130 670,1045 690,1045","purpose":"default","sourceConnector":"right","target":{"id":278},"targetConnector":"left","title":"excel"},{"branch":"display","id":250,"position":"290,1130 80,1130 80,1185 60,1185","sourceConnector":"left","target":{"id":144}}]},{"id":256,"inputs":{},"position":"20,-420","purpose":"start","title":"For Each","transitions":[{"id":135,"inputs":{},"position":"110,-360 110,-330 100,-330 100,-310","sourceConnector":"bottom","target":{"id":262},"targetConnector":"top"}]},{"action":"gcx:wf:arcgis:query:RelationshipQueryTask","id":262,"inputs":{"layer":{"accessors":["$varCurrentLayer"],"annotations":[{"count":16,"index":0,"kind":"idref"}],"code":"$varCurrentLayer.result","source":"$varCurrentLayer.result"},"objectIds":{"accessors":["$varOIDs"],"annotations":[{"count":8,"index":0,"kind":"idref"}],"code":"$varOIDs.result","source":"$varOIDs.result"},"outFields":"*","relationshipId":{"accessors":["$forEachRelationship"],"annotations":[{"count":20,"index":0,"kind":"idref"}],"code":"$forEachRelationship.item.id","source":"$forEachRelationship.item.id"},"returnGeometry":false},"name":"queryRelationship1","position":"-20,-310","title":"Query Relationship","transitions":[{"id":265,"position":"100,-250 100,-200","sourceConnector":"bottom","target":{"id":294}}]},{"action":"gcx:wf:core::AddItems","id":278,"inputs":{"collection":{"accessors":["$FinalResultsCollection"],"annotations":[{"count":23,"index":0,"kind":"idref"}],"code":"$FinalResultsCollection.result","source":"$FinalResultsCollection.result"},"itemsToAdd":{"accessors":["$runOperation2"],"annotations":[{"count":14,"index":0,"kind":"idref"}],"code":"$runOperation2.result","source":"$runOperation2.result"}},"position":"690,1030","title":"Add Items"},{"action":"gcx:wf:core::SetProperty","id":283,"inputs":{"object":{"accessors":["$varRelationshipName"],"annotations":[{"count":20,"index":0,"kind":"idref"}],"code":"$varRelationshipName","source":"$varRelationshipName"},"propertyName":"result","propertyValue":{"accessors":["$forEachRelationship"],"annotations":[{"count":20,"index":0,"kind":"idref"}],"code":"$forEachRelationship.item.name","source":"$forEachRelationship.item.name"}},"position":"290,50","title":"Set Property","transitions":[{"id":170,"inputs":{},"position":"410,80 410,130","sourceConnector":"bottom","target":{"id":146},"targetConnector":"top"}]},{"action":"gcx:wf:app::RunOperation","description":"results.from-graphics","id":289,"inputs":{"operationName":"results.from-graphics","operationParameter":{"accessors":["$resultCollection","$varTableTitle"],"annotations":[{"count":17,"index":11,"kind":"idref"},{"count":14,"index":43,"kind":"idref"}],"code":"{\n    graphics: $resultCollection.result,\n    title: $varTableTitle.result\n}","source":"{\ngraphics:$resultCollection.result,\ntitle:$varTableTitle.result\n}\n"}},"name":"runOperation2","position":"290,960","title":"Run Operation","transitions":[{"id":230,"position":"410,1050 410,1100","sourceConnector":"bottom","target":{"id":218}}]},{"action":"gcx:wf:core::If","description":"<-- no relationship ","id":294,"inputs":{"condition":{"accessors":["$queryRelationship1","NULL"],"annotations":[{"count":19,"index":0,"kind":"idref"},{"count":4,"index":29,"kind":"idref"}],"code":"$queryRelationship1.results == NULL","source":"$queryRelationship1.results==NULL"}},"position":"-20,-200","title":"If","transitions":[{"branch":"false","id":340,"position":"220,-155 250,-155 250,-70","sourceConnector":"right","target":{"id":319},"targetConnector":"top"},{"branch":"true","id":362,"position":"-20,-155 -90,-155 -90,-40","sourceConnector":"left","target":{"id":361}}]},{"action":"gcx:wf:core::CreateValue","id":308,"inputs":{"expression":0},"name":"varExitLoop","position":"290,510","title":"Create Value","transitions":[{"id":310,"position":"410,570 410,620","target":{"id":204}}]},{"action":"gcx:wf:core::If","description":"<-- no results","id":319,"inputs":{"condition":{"accessors":["Object","$queryRelationship1"],"annotations":[{"count":6,"index":0,"kind":"idref"},{"count":19,"index":12,"kind":"idref"}],"code":"Object.keys($queryRelationship1.results).length == 0","source":"Object.keys($queryRelationship1.results).length==0"}},"position":"130,-70","title":"If","transitions":[{"branch":"false","id":322,"position":"370,-25 410,-25 410,50","sourceConnector":"right","target":{"id":283},"targetConnector":"top"},{"branch":"true","id":363,"position":"130,-25 30,-25","sourceConnector":"left","target":{"id":361}}]},{"action":"gcx:wf:core::Log","id":361,"inputs":{"message":"no result to show"},"position":"-210,-40","title":"no result to show"}]}],"deploymentConfig":{"supportedApps":{"VSW":true}},"designerVersion":"5.41.0+34","licenseInfo":{"licenseUrl":"https://dqgc02.cityofsydney.nsw.gov.au/vertigisstudio/workflow/service/auth/license"},"start":{"id":3},"transitions":[{"branch":"loop","id":131,"inputs":{},"source":{"id":127},"target":{"id":103}},{"branch":"loop","id":138,"inputs":{},"source":{"id":109},"target":{"id":121}},{"branch":"loop","id":153,"inputs":{},"source":{"id":150},"target":{"id":152}},{"branch":"loop","id":207,"source":{"id":204},"target":{"id":206}},{"branch":"content","id":226,"inputs":{},"source":{"id":220},"target":{"id":225}},{"branch":"loop","id":257,"inputs":{},"source":{"id":254},"target":{"id":256}}]}
0
Henry Haro
14 octobre 2025 18:10 Modifié
This is a huge need for us. Having the Related Records restricted to the Results Panel is extremely clunky and visually difficult. It really needs to be able to be opened in it's new panel. The way it is currently is sub-par, compared to Geocortex.
2
Lea Dyrholm Hansen
4 novembre 2025 12:15
I can't see the related records in the “Results details" when adding a layer with a related table through the layer catalog.
This is possible in Geocortex and we would like the same functionality i VSW, please!
1
Tom Flahive
13 janvier 2026 18:17
We are also moving from a Geocortex app that was used for many years to VertiGIS, and having the data links show up at the bottom, as they did in Geocortex, is very important. Currently we are using a work-around to accomplish this, but it isn't ideal.
1
Henry Haro
27 janvier 2026 16:47
Has anyone heard any movement or response from VertiGIS on including this functionality in a future update?
1
Belinda Kerr
2 février 2026 00:06
Henry Haro I havent heard anything at all from VertiGIS since I posted this.
1
Steffen Helgerod
2 février 2026 00:39
I have waited in the hopes I can transition my Geocortex to a VSW platform that was ready, but this is a major requirement for me. Very surprised when I am constantly hearing and being told feature parity is available, but simple user experience workflows are not clearly available yet.
2
Nico Burgerhart
19 février 2026 13:39
Good to hear it is planned.
1
Henry Haro
3 mars 2026 17:16
I think this is the logged change that is currently accepted as a Feature added for a future release:
https://changelogs.vertigis.com/workitems?productLine=VertiGIS+Studio&id=365786
1
Allow related tables (ie Data Links) to display in the table view rather than in the result details/results list

Commentaires

Ce n’est pas ce que vous cherchez ?
