Hey folks, I need some help.
I have a custom field on ProdGrup.ComplementPartNum_c, which contains a delimited list of system alternate part numbers. I’m updating the list from an updatable query/dashboard, and it works just fine from there.
I want to embed the dashboard on the product group maintenance and have it pull up the list of parts for editing within the maintenance form.
It works okay on the customization except when the dashboard runs I get entries for all product groups and not only the current record in the ProdGrup dataview.
Here is the dashboard panel setup:
And the result. Notice that I get all rows from the BAQ, and not only the rows matching the current product group.
A complicating factor: The BAQ uses a CTE/Union All recursive subquery combination to feed the top level subquery, so it will generate rows for all ProdGrup rows that have the ProdGrup.ComplementPartNum_c populated with a value.
I would need to supply a parameter to filter for a product group at the lower-level subqueries. A tracker filter on the dashboard (run from the menu) filters the product group okay, though.
Maybe the CTE query is the problem, maybe not. Probably a mistake on my part.
Thoughts?
