Dear Community,
In our Order Management Execution App we use various dropdown filter components.
The filters, e.g. Sales Group filter, show the value like Sales Group code and the count of sales documents for each sales group code.
However, the filter also brings up old Sales Group codes with 0 sales documents.
Is there any way to exclude the filter values with 0 sales documents?
I already tried to use a NULL filter on the filter component but this did not work.
Any ideas?
Looking forward to your replies.
Thank you and kind regards,
Michaela
Question
How to exclude values with 0 sales documents from a dropdown filter?
Hi
Thanks for your quick reply.
Unfortunately, forced filters do also not work.
Kind regards,
Michaela
+3Hi
The reason gil.liu's suggestion for forced filters isn't working is likely because your dropdown is pulling the Sales Group codes directly from your Master Data / Dimension Table. That table stores all historical codes, regardless of whether they have active transactions in your current data model.
please try these ->
Option 1: Point to the Fact/Case Table (The Quickest Fix)
Instead of using the Sales Group column from the Master table (e.g., "Sales_Group_Table"."Code"), change the dropdown's dimension to point to the corresponding column in your Sales Document / Case table.
Option 2: Use a PQL Component Filter
If your data model requires you to use the Master table, you can apply a Component Filter directly inside the dropdown component settings to evaluate the count dynamically!
codeSQL
COUNT("Sales_Document_Table"."Document_ID") > 0Just replace "Sales_Document_Table"."Document_ID" with the actual table and column name of your sales documents.
This will force the dropdown to evaluate each group code and hide any where the count is zero.
does any of options worked ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.