Filter by Column : Powerful filtering/searching tool for all columns

:warning: IMPORTANT: Needs at least v13.7.5
v1.7.0 (Jul 12, 2024) :

  • Added support for datetimeoriginal and datetimecreated columns.
  • Added extra protection when attempting to read Evaluator columns that use values not available for filesystem directories.
  • Other minor fixes.
2 Likes

:warning: IMPORTANT: Needs at least Directory Opus v13.9.1

v1.8.0 (Aug 11, 2024) :

  • Added support for Streams and Signed By columns.
  • Improved handling of values and their correct conversion to the registered type (in case it differs from the original type).
  • Data types of most built-in columns can now be overridden.
  • Enhanced data conversion to the "number" type.
  • Other minor improvements.
3 Likes

v1.8.1 (Aug 16, 2024) :

  • In dialog mode, the columns combobox now works properly as a search bar. When you type something, the cursor stays at the end instead of jumping to the beginning.

Small update, but a very needed one!

1 Like

This script column,error come out. (using Filter by Column v1.8.1)

image

you can try it. thank you!

Did you try using quotes around the column's keyword? That should work.
I didn’t realize until recently that spaces are actually valid in a keyword...

I wonder if there is a way to 'Sort by Selected'. I'm looking for this.

For use after running the Dopus 'Select By Pattern' feature, and so everything that got selected by the pattern is moved to the top, like a group. Still in alphabetical order, or by order of the current column filter, but the idea is to divide what is selected from what is not selected, for easy review of what the 'Select By Pattern' selected.

To answer my own question, so it's not followed up on in this thread:
With help from PassThePeas I learned that I can hide things based on their selection.

Hide selected:

Select HIDESEL NOPATTERN

Hide unselected:

Select HIDEUNSEL NOPATTERN

Show whatever has been hidden by these commands (doesn't affect the H attribute)

Select NOPATTERN SHOWHIDDEN

I made a three-button button for this. And can add these commands to whatever I want, to do multiple steps like select by pattern then hide the unselected. Not as good as a selected to top group because you can't compare the selected with the unselected, but close enough.

Some functional suggestions are not known whether they can be realized:
1.Currently, you can only filter the current directory. Can you combine it with everything to increase the filtering range: current directory (default), current directory and subdirectories, global
2.Call the dopus filter and filter it after using the filter.

I'm glad you're still using the command. Thanks.

  1. The search submode allows you to search in subdirectories as well.
    Regarding Everything, there is probably not much sense to add support in terms of speed, since the old SDK is still being used, so only very few properties could be fetched quickly.
    Filtering on subdirectories is pointless IMO, as the item must be visible in the lister first.
  2. In an unreleased version I've added support for this. Although I'm not too happy with the result in terms of speed, so there's definitely room for improvement, whenever I get some free time.

Thanks for the feedback!

Thank you very much for your answer.

Sorry, maybe I didn't describe the scenario clearly.
Here's an example: filter files or folders modified today in the current directory and all its subdirectories
Dialog mode seems to filter only the current directory, not subdirectories.
If there is, please tell me the specific operation; if there is no, please add a toggle button


About dialog mode,I also think of some areas that can be improved. I don't know if they can be realized.

  1. Added top button. When I switch folders, the dialog remains.
  2. linked to the current directory. When I switch folders, I want the dialog box to respond immediately and update the filter entries
    3.Embed dopus panel. When the dialog box pops up, you can embed dopus main program like cell property window, displayed on the right side

In that specific mode, press F4, to open a subdialog, where there's a 'Search' button, that lets you search through all subdirectories. I agree that adding a button somewhere in the main UI could be useful for some. Noted.

  1. Do you mean the dialog should stay on top when switching to another tab? Because it already does.
  2. This was added in an unreleased version (v.2.0).
  3. I'm not sure what you mean. Sorry.

I'm sorry, that's not what I meant.Switch to another tab and the dialog does not disappear; however, just change the folder path on the current tab or close the current tab and the dialog disappears automatically.

Thank you so much for taking my advice and I look forward to its release.

When I press F9, the meta properties window is automatically embedded to the right of the dopus main program.


wish I could embed the pop-up dialog to the right of the dopus main program, like this

Move the dopus main program window, the right panel will follow the mobile.They become a whole

Ah yes, that was by design. there's now an option to follow the active tab, so if you close or change the path, it will follow the active tab's path (if any).

That would be cool, but it's not possible at the moment. I suggested it a while ago, so you can "sign in" to the petition if you want to. Maybe that will move it up the suggestion in its list—who knows?

Also, I'll probably release a test version for those interested. I kind of like that approach when developing scripts—TBH, this command's new version has just been sitting around collecting dust for a while. By working with people who are actually using it, I can focus better and get a clearer idea of what needs more or less attention.

1 Like

FYI, I managed to finish an "alpha" version of this command that includes several changes, mostly for the "dialog mode":

  • You can now "follow the active tab", which is easily switchable at runtime from the dialog itself.
  • You can now monitor changes in the active filedisplay (anything that can change filedisplay content) so the dialog auto-updates accordingly. This is also changeable at runtime.
  • You can load and use Opus pre-saved filters. Accesible from a menu.
  • You can save FBC filters for later use. Accesible from a menu.
  • There are changes in the way the command decides when to rebuild its "values database." For example, when it detects a new item, it will only retrieve the new values instead of rebuilding the entire database.
  • Other minor changes and corrections.

@sunnyzt or anyone interested in testing, you know what to do.

1 Like

v1.8.2 (2025-06-13) :

  • Added support for cleanup functions when uninstalling the script.
    (Note: This only works when uninstalling the script via the Script Management window.)

This is more of a maintenance release, since a new, leveled-up script is on the way. If you're already using this one, you'll definitely want to replace it with the new upcoming succesor.

3 Likes

Waiting for your new, leveled-up script!
Thanks much!

Every time I open DO, the error message shown in the picture below pops up.

Looks like you are calling it from the wrong place (the correct place is from the column header context menu)

Excellent script!! It's exactly what I was looking for! Just one question: in FAYT filtering mode, is there nothing that can undo the filter (like a key)? For example: I use FAYT in filter mode, which will hide all files that do not satisfy my search criteria and leave only those that do, but what if now I wanted to return to the previous state, where all files were displayed (as happens with DOpus' own filter bar), is this not possible without having to reload or another equally impractical means?

Thanks. And unfortunately, I think this one does not support that.
FWIW, I made its successor some time ago, and that one does do it. But I never finished it due to lack of motivation (the features I personally do not use would still be missing).
If there were some demand, I could upload it as a preview. The last script (TagMaster), in its preview, had a decent reception, and that helped me a lot with its development.

3 Likes