I have question that somewhat follows this thread
I have an existing BAQ that does quite a bit and I am adding to it and what I need to do is join Job Prod table (existing in BAQ) to a new table (Job Mtl) BUT… I only want to return records that satisfy a condition in the Order Dtl table (is part of the BAQ), SalesCatID= (my thing).
If it does not satisfy this condition, I dont want any job material records
I understand that constructing the BAQ around the Order Details to only get data based on the that condition would work at a glance but remember I have a pretty substantial BAQ that I want to add Job Material info to ONLY if that condition is met (otherwise I get way too much data that I dont want)
This may be a sub query but I don’t understand how to set it up (the ICE documentation I have ready dont help me much on this topic)
Make a calculated field that does something… returning a True/false or “Keep me” or something else you can filter on.
in the Condition, you are not limited to database fields, you can also choose the calculated fields (Click on the table name and you will see CALCULATED as an option. Then you can say "MyCalculatedField equals ‘keep me’)
I agree with Tim. often we try to get the BAQ to be “perfect” when the cost of not making it perfect is minimal.
To clarify (if I understand Tim’s meaning), step 1 is in the BAQ, step 2 is in the dashboard filter.
You interpreted correctly, but I also was vague for a reason… I have used a calculated field to pass to the Dashboard for further filtering, but also used it in a sub-query and then later filter out the results (not perfect) in an upper query with additional conditions. sometimes its just easier to understand a formula in the subquery and see the results.
