Use Search table in Display Form with dependent form items

Carmen Durham

January 07, 2019 20:35

Is it possible to use Search tables within a Display Form using dependent form items?  Or do you HAVE to use a Search Table Parameter Query and Display Results Picker?

 

I have a Cityworks Employee table with Organization (Sewer, Construction and Inspection, Engineering, Parks and Grounds, etc) and Employee Name.  It is set up in GCE as a search table.

 

I would like to make use of the dependent form items in a Form where the user will pick the "Organization" and then once the Organization is chosen, the next combo box will be limited to only the employees within the chosen "organization".

 

If this is possible with a DisplayForm, please provide the syntax (expecially for the Query URL).  I tried a few things without luck.  

 

If I cannot use the DisplayForm, please indicate that this is the case.

 

Thanks,

 

Carmen

0

• 

  Permanently deleted user

  March 07, 2019 20:10

  Hi Carmen, 

   

  This is possible, to some extent.  For the combobox, an example of the syntax would be:

  • Task Url: https://gedemo.geocortex.com/Geocortex/Essentials/Prod/REST/sites/LA_County_/searchtables/Park_Trees_Search_Table
  • Where Clause: Name={0}
  • Display Field / Value Field: COMMON_NAME

  "Name" in the where clause is the name of the parameter on your Search Table.

   

  {0} will be provided by a previous form item, supplid by the "Cascading ID" property. 

   

  Display Field/Value Field should be any field that the search table returns.

   

  If your search table or site are secured, then you would also need to use runtime modifications to provide an Essentials token, which you can get from a GetRequestInfo activity.

   

  You should be able to test the Search Table REST endpoint if you need to do any troubleshooting, by constructing the url the same way that the workflow would.  Eg.

   

  https://gedemo.geocortex.com/Geocortex/Essentials/Prod/REST/sites/LA_County_/searchtables/Park_Trees_Search_Table/query?where=Name%3DCOMMON%20FIG

   

  If your search table has multiple parameters, it gets more complicated- you would need to supply values for each search table parameter in the where clause.  I'm pretty sure this is possible, but I don't remember the format off-hand.

  0

Please sign in to leave a comment.