Hi, I want to share what I’d like to achieve with Manager’s Inventory Items. I don’t think it’s currently possible. I’ve tried many things and searched forum but haven’t found a solution. So the idea is to be able to select multiple items of inventory in the advanced queries and show the chosen co…

[image] Footballmanager: Maybe this can even be implemented by adding a new filter where we can directly choose the item itself from a dropdown instead of typing the item name after “contains”. Either way, it is currently not possible to achieve this in any way. Create a custom field for your…

[image] Footballmanager: As of now, this advanced query will not show any results. @Lubos provided the solution. The reason why you did not get any results is because the “Where…” fields involve a so called “AND” operator. So in essence it would be searching where ITEM 1# AND ITEM 2# AND ITE…

Thanks for your reply lubos. But unless I’m misunderstanding, this is not the solution. On any day, I might need to select a random combination of items to view in this way. And there are more than 5k items. Your solution assumes that I already know which items I want “grouped” together when creati…

Thank you eko but this is also not it. Just tried putting both item names under a single “Where” and nothing comes up.

[image] Footballmanager: Just tried putting both item names under a single “Where” and nothing comes up. This would not work because it would look for the whole item name which would not exist, hence my reference that you can follow @Lubos advice to create a custom field and assign each of th…

Yes but I already mentioned to lubos above why this is not the solution,

[image] Footballmanager: There should be a simple way to select multiple items I believe you are looking for an “or” operator. Manager has only supported “and” between multiple search terms. However you are not the only user who has requested Manager support the “or” function. [image] Fo…

Thanks Patch for your contribution. And yes the “or” operator I believe would help this situation. I’m trying to understand your suggestion using the Batch Recode function but can’t seem to figure it out. My custom fields don’t show up in the dropdown menu of Batch Recode. [Screenshot 2024-07-14 …

To create the “or” functionality sequential search for each item(s) and mark for inclusion Subsequent search of all marked items is the “or” of prior sequential searches [image] Footballmanager: My custom fields don’t show up in the dropdown menu of Batch Recode. Oops, it appears this is y…

I guess the “or” functionality has to be added. because as of now I still can’t see how Batch Recode can solve this issue even when it implements usage of customs fields. Anyways. I hope a more simple way to do this within advanced queries gets added in future updates.

Add support for "or" filter in advanced queries

ideas

Patch July 14, 2024, 9:17am 10

To create the “or” functionality

sequential search for each item(s) and mark for inclusion
Subsequent search of all marked items is the “or” of prior sequential searches

Oops, it appears this is yet to be implemented

Topic		Replies	Views
Searching inventory items using multiple words Uncategorized	15	1748	January 21, 2019
Advanced search doesnt work with multiple value custom fileds Uncategorized	7	371	February 29, 2024
Inventory Uncategorized	11	962	June 17, 2017
New Filter Options for Invoices Uncategorized	7	1096	May 20, 2022
Item Serial Number ideas	21	2837	April 6, 2024

Add support for "or" filter in advanced queries

Related topics