Workflow 5 Display SQL Query results

Sean Phayakapong

4. Mai 2020 15:50

Hello, in Workflow 4, we were able to to view the SQL query result in a table, but for Workflow 5, the array is not able to be formatted into the table. Is there a way to show the result (left panel).?

0

• 

  Gareth Evans

  6. Mai 2020 00:06

  Hey Sean

  Looks like you're pretty close. As mentioned on our call yesterday, you're seeing a bunch of objects in that results list.

   

  Can you confirm, does your server workflow use the "Convert Data Table To Feature Set" activity? I'm wondering if you need to get a featureset here rather than the raw data.

   

  These two activities may also be relevant:

  https://docs.geocortex.com/workflow/latest/help/Default.htm#wf5/help/activities/convert-data-table-to-feature-set.htm

  https://docs.geocortex.com/workflow/latest/help/Default.htm#wf5/help/activities/feature-set-from-json.htm

   

  If you're not able to make any headway, please feel free to create a support request and we can dig further.

  0
• 

  Sean Phayakapong

  6. Mai 2020 19:16

  @Gareth Evans? Hi Gareth, yes I had used the "Convert Data Table To Feature Set" activity on the server workflow. No matter the different combinations I tried I am still getting my arrays to display as [object, Object]. I shall create a support ticket. Thanks.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.