Options
  • Locked Locked
  • Replies 5 replies
  • Subscribers 11 subscribers
  • Views 268 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Using OR in search to connect properties

bpascal
Hey guys,

I really love M-Files and what it can do, especially the search and filter functions.
However, there is something that is quite essential and yet missing.

I know that one can do a Boolean search and use the operator OR. Yet I am unable to find this function in advanced search (i.e. when connecting properties, the default connector is AND and there seems to be no way to change this  :( )

Any help appreciated - maybe it is possible and just a bit hidden?

Best regards
Pascal
  • ...or is it maybe possible to do a Boolean OR-search with properties using a specific syntax in the default search field/ search window? :D
  • Just in case anyone had the same question:

    I just found out that using an M-Files URL, it is possible to do a search with the OR-operator - one simply adds a comma between the two values one wants to go for :)

    An example:

    It is not possible to search for all the objects created by EITHER user X OR user Y in the default search in M-Files Desktop by just using property filters (the property filters are simply added, which logically results in an AND-search, which is not what one always wants in every scenario).

    However, with the following URL one can achieve the desired OR-search:

    m-files://search/test?propertyvalue=25/4,6


    test is the name of the vault.
    propertyvalue=25 is the CreatedBy Property
    4 would be the ID of user X, 6 the ID of user Y

    The result of executing the URL is that a window with M-Files Desktop pops up and shows us all the objects created by either user x or user y - just as intended 8)
    hope that helps if anyone had the same question
  • You can use the "one of" operator in the client to do the same search for values in a single property: www.m-files.com/.../property_based_conditions.html Then you would select multiple values from the value list by holding down the Ctrl key.

  • You can use the "one of" operator in the client to do the same search for values in a single property:

    Wow, I wasn't aware of that - thank you very much for the hint!! "one of" obviously is quite straightforward and I would have gotten the idea right away if we used M-Files in English - however, the German translation of the operator is a bit unlucky (in my opinion) so I hadn't even tried that ;D ;D

    Thanks again!! That operator helps a lot in many cases.
    Keep up the fantastic work of M-Files :)

    Regards
    Pascal
  • As it's related (but not directly an answer to your question, Pascal, sorry), note that the Developer Portal has an example of how to create COM API search conditions that use this approach to work around the "OR" limitation: https://developer.m-files.com/APIs/COM-API/Searching/SearchConditions/#executing-a-one-of-search

    Sorry to hijack the thread. ;)

    Regards,

    Craig.
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.