Results Table - Show All
Planifiée
I am trying to add an Attribute Table similar to the one in WAB to my layout in VSWeb. There is no component for it so I created a Results Table and would like to "show all" the features that I can sort by an attribute. Any ideas on how to do this? Would also like to add another table in a tab but i can probably figure that one out.
-
Commentaire officiel
It is currently in the design state. You can track the progress in the changelog under the ID 150776.
-
They don't make it easy in the new map viewer either would be nice to click a table icon and get table attributes for a layer to open with export capabilities.
1 -
Hey Luis Martinez,
It's not a perfect solution, but I just put together a decent workaround. Depending on the number of records in your layer, you may have to adjust the parameters on the ArcGIS Server side to allow for queries of >2,000 records. Or you might be able to paginate through multiple queries and append the results to the display... I haven't monkeyed around trying with that.
The json of my template workflow is attached below. Hopefully this will help out a bit.
Regards,
Brian
{"_properties":
{"isServerWorkflow":false},
"components":[
{"id":2,
"steps":
[
{"id":3,"inputs":{},
"position":"0,0",
"purpose":"start",
"title":"Start",
"transitions":[
{"id":20,
"position":"90,60 90,110",
"sourceConnector":"bottom",
"target":
{"id":19}
}
]
},
{
"action":"gcx:wf:arcgis:query:QueryTask",
"id":6,
"inputs":
{
"layer":
{
"accessors":["$layer1"],
"annotations":[
{
"count":7,
"index":0,
"kind":"idref"
}
],
"code":"$layer1.layer",
"source":"$layer1.layer"},
"outFields":"*",
"returnGeometry":true,
"where":"1=1"},
"name":"query1",
"position":"-30,220",
"title":"Query Layer",
"transitions":[
{"id":14,
"inputs":{},
"position":"90,290 90,320",
"sourceConnector":"bottom",
"target":
{"id":8},
"targetConnector":"top"}
]
},
{
"action":"gcx:wf:app::RunOperation",
"description":"Create a results display from the query results",
"id":8,
"inputs":
{
"operationName":"results.from-graphics",
"operationParameter":
{
"accessors":["$query1"],
"annotations":[
{
"count":7,
"index":12,
"kind":"idref"
}
],
"code":"{ graphics: $query1.features }",
"source":" { graphics:$query1.features }"}
},
"name":"runOperation1",
"position":"-30,320",
"title":"Run Operation",
"transitions":[
{
"id":16,
"inputs":{},
"position":"90,430 90,460",
"sourceConnector":"bottom",
"target":{"id":10}
}
]
},
{
"action":"gcx:wf:app::RunCommand",
"description":"Set the results display to the table view",
"id":10,
"inputs":
{
"commandName":"results.set-display-components",
"commandParameter":"results-table"
},
"position":"-30,460",
"title":"Run Command",
"transitions":[
{
"id":18,
"inputs":{},
"position":"90,550 90,600",
"sourceConnector":"bottom",
"target":{"id":12}
}
]
},
{
"action":"gcx:wf:app::RunCommand",
"description":"Display the query results to the user",
"id":12,
"inputs":
{
"commandName":"results.display",
"commandParameter":
{
"accessors":["$runOperation1"],
"annotations":[
{
"count":14,
"index":0,
"kind":"idref"
}
],
"code":"$runOperation1.result",
"source":"$runOperation1.result"
}
},
"position":"-30,600",
"title":"Run Command"
},
{
"action":"gcx:wf:arcgis::GetLayer",
"id":19,
"inputs":
{
"layerId":"MAP LAYER"
},
"name":"layer1",
"position":"-30,110",
"title":"Get Layer",
"transitions":[
{
"id":21,
"position":"90,180 90,220",
"sourceConnector":"bottom",
"target":
{
"id":6
},
"targetConnector":"top"
}
]
}
]
}
],
"deploymentConfig":
{
"supportedApps":
{
"GWV":true
}
}
}0 -
FYI. I was able to use a "count" attribute and adjust the Start parameter in the Query Layer activity as a way to paginate through the results.
The first time through I create a new feature set from the results of the Query Layer activity (the first 2,000 records), and then on subsequent passes I increase the Start parameter of the Query Layer activity by 2,000, and then use an Add Items activity to add the results of the additional Query Layer activity to that previously created feature set. I continue on through that if/then loop until the Query Layer activity returns no results.
At that point, I use the same RunOperation and RunCommand activities as my workflow above to display the feature set that contains all of the features.
This is the best workaround that I can come up with for now - I would think that Vertigis would be working on something to display tables since we can do it natively through the AGOL/On-Premises map viewers *shrug*. Depending on the number of records in your layer, and how many Query Layer activities have to be completed, there can be a slight delay before the table is displayed to the users.
0 -
For our customer (province of West-Vlaanderen Belgium), this functionality would be very useful. I see it has the status of planned now. Is there any information about the progress or timing of the release? Thanks in advance.
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
5 commentaires