I'm putting together a web app in WAB Developer. it is 95% complete but the last 5% is important. I need a widget that will query a work-order table based on a the user clicking on a feature. There is no spatial info in the work-order table. So it will be on the two relating fields between data sets (upstream manhole, downstream manhole). This limits using relationships, which appears to not be supported in WAB anyway.
I'm starting to learn JS and GIS web dev, but it's a long haul to building my own widgets. Any ideas?