I have a workorder management system (WMS).
- The WMS has functionality that allows users to save queries.
- The queries are saved in a Oracle database table called
An example of a value in the
CLAUSE column would be:
((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and contains(description,'$paint') > 0 and historyflag = 0 and istask = 0 and siteid = 'SERVICES')
I would like to utilize the saved WMS queries by applying them as filters to layers in a Portal web map.
From a drop-down menu, a user would choose a
CLAUSENAME (from the
QUERY table), the widget would programmatically extract the WHERE clause value from the
CLAUSE column, and use it to automatically filter a layer.
To be clear, this would be a programmatic/custom widget solution, not manual copying and pasting.
Is it possible to do this?