How do i display a collection of data tables in the ResultsTable?

Sean McClurkan

April 05, 2016 16:11

Essentials 4.5 HTML5 2.6

 

I've got a workflow where I execute SQL Query tasks and return data tables.  I've added the data tables to a colleciton of data tables, but I can't find a way to "name" the collection so that it can be referenced by the viewer command "ShowResultsTable" which takes the name of a collection.

 

When I use Query Tasks and FeatureSets, I simply SelectFeatures into a "named" collection by defining a string variable and using that variable in the SelectFeatures activity for the name of the collection I'm selecting into.

 

Since my DataTables are not "selections", I can't select them into a named collection.  When I use the CreateCollection activity, there is no mechanism for assigning it a name since there is no Name property for a Generic.ICollection.

 

If I convert the DataTable to a FeatureSet, there is no featureclass to configure the SelectFeatures activity against, so the tabs in the ResultsTable are just thin, almost invisible, lines above the table.  I'd really rather not create a bunch of empty featureclasses in the database just to have a configuration mechanism in Manager.

 

Am I missing something obvious?  Probably.

0

• 

  Kevin Penner

  April 05, 2016 23:17

  Hi Sean,

   

  Try the last option which was convering the DataTable to a FeatureSet. On the SelectFeatures activity take a look at the 'Label Format', 'Description Format' and 'Long Descriptions Format' parameters which are on the right hand side of the screen.

   

  Let us know if that solves the problem.

   

  -Kevin

  0

Please sign in to leave a comment.