Two columns from same BAQ in App Studio where list?

CMoerchen · September 12, 2025, 5:39pm

Hello!

I am building a dashboard for time entry review, with the data coming from a BAQ that displays in a grid panel. I’m trying to create different views for the grid that will filter if an employee is late or early.

I would like to compare a column from the BAQ with another column in the same BAQ, but I’m not sure what the syntax for that looks like:

Is there a way to do this within App Studio, or am I better off changing the BAQ?

Randy · September 12, 2025, 5:48pm

What kind of datatype is the “Calculated_EarlyStart” field?

Sometimes I put these kinds of conditionals into the BAQ and use that to filter the grids instead.

CMoerchen · September 12, 2025, 6:18pm

LaborHed_ClockInTime and Calculated_EarlyStart are both decimal.

And yeah that might be the way to go, I didn’t know if there was a way to do it in App Studio or not

Randy · September 12, 2025, 6:21pm

Are you trying to do a view option like this? That’s done in a different spot in App Studio.

CMoerchen · September 12, 2025, 6:29pm

I am! I thought View Options was the place, is there somewhere else I should be working?

Randy · September 12, 2025, 6:39pm

That’s in Advanced - View Options