+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: User Support (https://discussions.corebos.org/forumdisplay.php?fid=6)
+--- Thread: Suggestions needed: product filter (based on relation) (/showthread.php?tid=2065)
Suggestions needed: product filter (based on relation) - Svemar - 01-06-2021
Hello,
We have a need to filter out products (and later detele them) which were not used (not active, were not quoted, not ordered and not sold).
Would it be possible to do this through interface?
Is it possible to have custom filter condition witch looks if the product has any relation?
Thanks
RE: Suggestions needed: product filter (based on relation) - radu - 01-08-2021
Since those are not directly related i don't see how you could display them in filters. Maybe if you get those values in some custom fields on products you could then filter on those.
RE: Suggestions needed: product filter (based on relation) - joebordes - 01-13-2021
There is currently no way to do that (yet). It is something that has appeared in the past but we have never gotten to it.
I usually just get the IDs from the database and use them to delete the products either with a web service loop if I need the workflows to trigger or with a direct DB update if not.
RE: Suggestions needed: product filter (based on relation) - Svemar - 01-14-2021
OK, clear,
I added check box custom field to product in order to to mark "used" ones.
Then added workflow to mark product "used" when Inventory details is creaded for that product.
So for all new (this year imported) products i will be able to know which of them where not used after one year, when new pricelists were available, so not used ones, coudl be deleted, because there is no need to keep them in the system.
So now i will build SQL querry with the relation existance at vtiger_inventoryrproductelate table checking and will mark the matching records as "used" once.
But it would be nice to have this type of filter, let it be a custom query type or something similar.
RE: Suggestions needed: product filter (based on relation) - joebordes - 01-14-2021
working on it
RE: Suggestions needed: product filter (based on relation) - Svemar - 01-14-2021
(01-14-2021, 09:01 PM)joebordes Wrote: working on it
Perfect, hope this future option will helps others