Hi, we have a client with 700+ products listed in a custom module.
We are finding it difficult to find, search for and filter fo products within the admin console.
there is no option to filter for starting letters: All | A | B | C
we can only search for item names
the display of the item name is short. as some of the item names are long and similar we cant see which product is which.
We are also using a custom field for product code. It would be helpful it the search in the back end would look through all the fields so we could search by product code.
That’s a good one @Adam.Wilson. Can’t wait for it to be implemented. It’s high on my list, but not quite high enough to get one of my precious votes yet. But just below the ones that have my current votes.
What a huge upgrade that would be over other systems.
@Erik The option to filter by starting letters sounds like a backlog request. I wonder if it could even be added to the current search functionality. Maybe a drop down that allows you to select the search type and one of the options would be "Filter by “First letter” and you could type “A” to get a list of all items that start with A. You could even have “search in [select field name/column header]”. I’m just spit-balling. @Adam.Wilson always has a way to consolidate my lofty ideas into something people could actually use. I feel like there must be examples of this kind of advanced list filtering. Anybody got an example?
Perhaps a special search syntax could be used to save having a clunky UI. Such as typing first:A to search items starting with “A”. So this could extend to numbers and special characters; first:3, first:$ and first:Ä.
In saying that, I always hated the seemingly old-school approach of the BC almanac filtering, although I did use it but probably due to a lack of other options.
I wonder if with all the other search and filtering tools implemented (ie: custom columns, column sorting, search based on custom column) if this would actually be needed though?
I don’t love the idea of having a special search syntax.
I much prefer the idea of having an “Advanced Search” toggle/button that adds a panel with advanced search UI.
@Adam.Wilson I think you’re probably right about the custom columns meeting most of these needs. I wonder if there would be a way of integrating this use case into the columns. If filters were introduced? Then there could be a filter by [field]. (i.e. filter by “a”)
Yeah, on second thoughts a search syntax probably wouldn’t be user-friendly (esp. for end-users/clients) and they can be hard to remember.
I was just trying to get away from a bunch of clunky search option. But if these are hidden away under a “Advanced Search” toggle then it’s probably fine.
A) when updating a custom module item on page 20 for example it jumps back to page 1. this is very annoying if you want to update multiple items on page 20.
B) the items per page and back and forward < > icons should be on top of or to the right of the search field rather than at the bottom. User has to scroll down to navigate.
Please collect all the suggestions for improving the list view items in one backlog item. We will discuss them with the team and make them in the next sprints.
Hi @Erik,
In order to see the full name of the item (if it is too long) you can hover the item and a tooltip with the full name will appear. We added it in past sprints for such situations.
I know, it’s been a year. So, I’ve been busy, what can I say
Finally got around to thinking about how advanced filtering might work. I considered a number of options, but ultimately I think that a query builder would be the most straight forward. I love the brevity of having some kind of text query option, or using regex, but I decided that would be too complex for most users and probably more granularity than most people need. Anywhere here is my idea for advanced search query builder for modules.
Let me know if I missed something or If something isn’t clear.
Note I didn’t actually implement the filtering capability here, I just wanted to demo the query builder.
I think some of the needs around seeing long column values and adding other fields to search might be taken care of by the custom table feature.
If I were to add one more feature to this it would be the ability to save and recall advanced search. So more concisely:
-a button to save and name advanced searches
-a drop down to recall advanced searches by name
This would be a secondary feature. I think advanced search without it would be fine as well.
I see custom reports is coming in the next sprint, so I wonder how much of this is going to be covered by custom reports. Will we have the ability to create reports of module items? Even if custom reports covers this use case, it would still be nice to have this feature in context.
I also imagine custom reports will have a query builder as well, so it might just be a matter of recycling the UI and implementing it in this context.
But just below the ones that have my current votes.
