Query a query result

[Nicole_Ueberschär]

I am trying to find a way to narrow down a selection done by a query.

I tried the Query tool with an expression set but I don't want to force my user to give a value for each of the variables.

So I thought of using the operational layer from the query result somehow but I don't see a way to query this one.

As an example: I have a query defined for the user to look for those plots that are bigger than 100 ha. Now he should be able to apply on this result a different query e.g. distance to next settlement or maximum elevation (both attributes of the same layer the first   query was applied to).

How could I do that?

Thank you!

[RobertScheitlin__GISP · Accepted solution]

Nicole,

  There is not an OTB widget that supports this.

but I don't want to force my user to give a value for each of the variables

If you use WAB Developer Edition then you can add custom widgets and the Enhanced Search Widget Version 2.0.1.1 - 4/27/16 allows for search parameters that are configured but not marked as required to not be filled out. The widget will see that the parameter is null and thus not use that portion in the final SQL statement.

[Nicole_Ueberschär]

Thanks Robert. At the moment I don't have a server available to host customized widgets but I will keep it in mind.

[Nicole_Ueberschär]

Okaaaayyyyy, working on getting familiar with the customized widgets and the WAB Developer Edition now 😉