I have a web map in Portal that has a point layer called Work Orders.

I believe it's possible to manually select points in the layer by using the Web AppBuilder Select Widget.

enter image description here

Using selected points, I would like to generate a WHERE clause by listing the WONUM values in an IN CONDITION.


wonum in ('WO1754', 'WO1756', 'WO1759', 'WO1766', 'WO1770', 'WO1772', 'WO1775', 'WO1777')

From there, I would copy the WHERE clause to a separate work order management system and paste it into the system's own filtering tool.

How can I generate a WHERE clause from selected features in Portal?

(Oracle 12c)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.