Filter Items based on Product Bundle

[hpotabatti]

Currently, the system does not have a provision to filter the items in the Item List based on whether they have been used in the Product Bundle. This filter will allow users in a lot of use cases to identify the Product Bundled items.

[A7medAbdin]

any update, the interisting thing it is there but I can not access it,

[Namekkural]

I would like to see this, too! Currently the only workaround would be to either create a custom report with some SQL subqueries like this:

SELECT item_code
FROM tabItem
LEFT JOIN `tabProduct Bundle` as pb ON pb.new_item_code = item_code
WHERE pb.`name` IS NULL # not head of product bundle

or there could be a server script that would automatically prefill a hidden field with a boolean value based on its status. This server script would need to be executed anytime a Product Bundle is saved and all existing items would need to be updated manually somehow.

Since both of these are not ideal, I would also love to see more flexibility here. How about giving admins a way to supply additional filters to the standard ones? We could add SQL snippets as filter blocks that any user would be able to combine with other filters. That way the UI does not need to change but users could filter for anything in any default view.

I think this approach would be the most reasonable since the filter queries use SQL under the hood anyway.