I am wanting to pull in just the first operation that is not complete. SO I have Operation complete = false, but I can’t figure how to only pull in the first line. The First() doesn’t work in Epicor.
on the subquery tab, you can tell the BAQ to only return the TOP 1 records.
1 Like
Have it setup like this:
But need only he first operation not completed to be showing up. Below is where it is showing the two rows
If I take the 300 rows and make it 1, only one row shows up for the entire BAQ.
1 Like
I assume that your operations are pulled from a subquery. If that’s the case, then make a calculated field to return the minimum oprseq number from your list of incomplete ops.
2 Likes