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

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
Parents
  • 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
Reply
  • 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
Children
No Data