Filter on every column in the grid possible?

[RetroMan]

Hi there,

Following the 5 beta builds and thrilled about this new product! At work we use Microsoft Dynamics which offers a grid view very similar to MM. In Dynamics, hitting <ctrl>-G brings up a row below each column that acts like a filter, which also works with boolean operators. This is extremely powerful, the user is able to build all sorts of queries "on the fly". Could this be implemented?

[Peke]

Hi,
Are you referring to Grid Filtering Options on Dynamics eg. https://docs.microsoft.com/en-us/dynami ... rtcut-keys ?

Can you Make few screenshots of both MM5 (add elements where you think it should be placed) and Dynamics (blur any sensitive data) so that we can see what your actual idea is?

[RetroMan]

Yes, exactly! I am referring to the "Grid filtering options". Activating them opens a line between the column headers and the data. On this line, for each column a filter box appears. The user can very easily build queries with it, f.i. put "*rinc*" in the artist filter box, "*ove*" in the title filter box and ">255" in the bitrate filter box; getting all tracks of Prince - When doves cry with a bitrate of 256 or more as a result. At my work I use this in various master databases and it's extermely powerful and fast.

I have made some screenshots. I don't seem to have a way of hosting them online; would it be possible to e-mail them to you? You can e-mail me at nexus7ab@gmail.com so I can reply with the pics. I have made examples with test data so you may freely use them online.

RetroMan

[Peke]

Hi,
Use tutorial in my signature to upload them here.

I know how that works you can set that in almost any spreadsheet app.

[RetroMan]

Thanks for the tutor, that worked!

Just another brief explanation: With CTRL-G the user activates a column filter on each and every column that is displayed in the grid. The column filters together always work as an AND. Within each column it is possible to work with boolean expressions.

Here are some examples:

Filtering on a text string in the column "Klantnaam":
https://www.dropbox.com/s/v4mnjvlz3ujsu ... 1.png?dl=0

Filtering on a text string in the column "postcode":
https://www.dropbox.com/s/o3yl1gybi3krq ... 2.png?dl=0

Filtering on a text string in the column "Klantnaam" AND in the column "postcode" AND in "vervolgnaam 1" AND in "vervolgnaam 2" AND a boolean in "klantengroep" ruling out all records that have the string "EXT" in it.
https://www.dropbox.com/s/q2x99enn1jw5d ... 3.png?dl=0

To clarify: The results are always the same dbase record, as lazy me didn't make more than one test record in the dbase. But trust me, this works extremely fast and handy on master databases with hundreds of thousands of dbase records.

I think the mm4 filter is not as powerful and user friendly as it could be. Would this method (as you say, often seen in spreadsheets) be possible to implement?

RetroMan

[Peke]

Hi,
was waiting for you to upload images, but they are still missing, You used Dropbox instead of proposed imgbb and drop box will preview only for you I do not see them.

[Barry4679]

Hi RetroMan,

you can fix public visibility to your Dropbox images like this:

• point Windows Explorer to your Dropbox images

• right click, and take option Copy Dropbox link ... it copies a public link to the image into your clipboard

• update your previous post, and replace the preview links that you used

[RetroMan]

I'm sorry, I have the DropBox app installed but I don't get that option by right-clicking on the images. Send an e-mail to me and I'll return the images to you.

[Barry4679]

I'm sorry, I have the DropBox app installed but I don't get that option by right-clicking on the images. Send an e-mail to me and I'll return the images to you.

I'm not from MM. Just a customer like you.

Sorry, maybe I wasn't clear enough.
Copy the image into your Dropbox folder ... and then find the image in the Dropbox folder, using Windows File Explorer, and right click it in explorer.

But there are multiple options for configuring Dropbox support on your PC ... So if the above still doesn't work for you try this ... create the link to each image as described there, and copy those links into your post.

[RetroMan]

I guess it works now. I hope it is clear now, can this method of filtering be added?

[RetroMan]

Hi Peke,
It should be OK now!

Hi,
was waiting for you to upload images, but they are still missing, You used Dropbox instead of proposed imgbb and drop box will preview only for you I do not see them.

[Peke]

Hi,
Hmmm, you are right the feature is exactly like this one https://www.educba.com/filter-column-in-excel/ for spreadsheet apps.

I use it also a lot in spreadsheets and it is very useful to narrow data, just wonder how to define it without confusing users. Not sure that adding another raw below header would benefit as it can be defined as "Quick content filter" which is feature of column browser.