Pass Result from Identify to Report and populate report from

Henry Haro

December 09, 2024 19:33

Hi, functional question here:

Working on building out some parcel reports in VertiGIS Studio Reporting.

Essentially, I have the map data source working on the map, obtaining a PIN selection.

Is it possible to pass a parcel PIN selected from Results to another DataSource added to the Report (a SQL Table View). I basically need to extend the resulting PIN to its associated data in the other SQL Table based on the shared PIN value. I'm assuming that the answer would lie in the Paremeters settings, but still getting acquainted with how it all works.

Thank you,

1

• 

  Gareth Evans

  December 09, 2024 20:48

  Hey Henry Haro this is certainly possible, though would be best done using a couple workflows: a client side workflow that would likely be run as a feature action on your parcel layer, and include some logic to trigger  server-side workflow that interacts with your secondary data source using a Run SQL Query. The result of that would then be massaged into input for a Run Report activity. 

  There are some useful docs here:

  • Workflow: 
    • Main Steps to Create and Run a Server Workflow
    • Example - Use a Server Workflow to Query a Database
  • Reporting:
    • Configure a Report to Take Other Values from a Workflow
    • Include Related Data in a Report

  1

Please sign in to leave a comment.