BAQ "subquery" help

[Banderson (Brandon Anderson)]

That’s called a single sub select (If I understand what I’m reading)

Basically you want a subquery to return a single value into a field, right?

This is a post that explains how to do it in classic. Like @Olga mentioned, that was missing in kinetic UI.

Previous Operation in BAQ

yes you can with a few limitations. Being that there may not be a previous op, you may return a null value. You have to use a inner sub query and that will limit you to returning only one column. If you need multiple columns with this method you may just have to make more than one query. This is the only method i know of at this time, I’m sure there may be other methods. create a inner sub query [image] bring in the joboper table (you’ll need to assign an alias), create links under subqu…