Hey Robert. I am sure we can help you get there. Can you show us the BAQ you are working on, and include details about what you have attempted? It should be as easy as adding JobNum to group by. If you don’t want to do it in the BAQ, you can apply the grouping to just the results by right clicking the header and turning on grouping. Drag jobnum to the group by header and you should be in business!
PlanningTable.baq (54.9 KB)
Hi Nate,
Thank you ever so much. I’ve attached the BAQ for your reference. I’m still in the process of learning! 
Sorry I should have stated, I want to group in the BAQ so that only one line shows for each job.
This is a UBAQ, or an updateable BAQ. Is that on purpose?
Hi Nate,
Yes this is a Updatable BAQ. Its to help with scheduling, well thats the intention.
There are a few issues with the BAQ I can see. First is that the tables are not linked in order properly. Link Job Head to Job Asm, to Job Op, to Job Op Dtl. I think there is more but I have to run. I will check in tomorrow. Good luck!
Fab, thanks Nate, look forward to hearing form you.
Take it easy…
Do you intend to have a sum, or count, or some other aggregate on the grouped rows?
Hi Nate,
Nope, nothing else, unless require to enable the grouping?
You have too many fields in the display list to be able to group properly. What is the data that you need to review to make the update? What update are you making? Besides being linked in the wrong order, there is also an unused parameter. For testing, I removed the updateable flag, I rearranged your tables, and removed the parameter. It is not clear from the fields you have in the display what your goal is, so let’s backup a little further and define your goal. What’s the business problem you are trying to solve here?
Hi Nate,
We’re aiming to use this as a scheduling priority update board, allowing us to modify the assigned resource, scheduling comments, lock and firm status, as well as the scheduling code, priority, and sequence.
Have you looked at the Job Scheduling Board? I think you can do most, if not all of that from there.
I only direct you there because the goal you have for this UBAQ is quite complex, and a simple update query won’t cut it. There are lots of things that happen in the background (BO methods) when you change something in the schedule. It is difficult, even for experienced users, to find all those methods, and reproduce their effect accurately.
Having said all that, if you are bound and determined to learn by fire, start with tracing.
Trace Helper Utility for Epicor ERP 10 - Epicor ERP 10 - Epicor User Help Forum (epiusers.help)
The idea is that you turn on tracing, then perform all the actions you want your UBAQ to do. The trace captures all the BO methods and parameters for you to review. Then just reproduce all that logic perfectly in your UBAQs BPM. Oh yea, you can’t use a basic UBAQ, you will certainly have to use the advanced BPM to create a custom action to tuck all this logic into.
I would try my best to use the canned tools for this one.
Good luck!
Hi Nate,
Thank you for pointing me in this direction, i shall give it a shot. Wish me luck
1 Like