Options
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 14 subscribers
  • Views 292 views
  • Users 0 members are here
Related

Is it possible to filter objects for properties that have multiple values?

MarcTrumpi

Hi everyone.

On one of our objects I have a property that contains 0..n values from a multi-select. I would like to search for all objects that have more than 1 value in that property. Please see an axample in the image below. I would like to find only the object 109388, which has multiple entires. How should I do that in the search function?

I already tried wildcard patterns, but that doesn't seem to be able to find multiple entries, or I'm using a wrong character.

I hope someone has some suggestions. Thanks!

Parents
  • 0

    I don't think you can do this directly with the built-in search options.

    One approach would be to add a helper property, e.g. "Number of revisions" of type Number (integer), where you store the number of values in the multi-select property for each object. You should be able to fill this property automatically for instance with the Managed Properties module. Sample rule where the dynamic value would be "Current revision(s).Count()" in your case:

    When you have this helper property filled on all objects, then you can perform a search "Number of revisions > 1".

Reply
  • 0

    I don't think you can do this directly with the built-in search options.

    One approach would be to add a helper property, e.g. "Number of revisions" of type Number (integer), where you store the number of values in the multi-select property for each object. You should be able to fill this property automatically for instance with the Managed Properties module. Sample rule where the dynamic value would be "Current revision(s).Count()" in your case:

    When you have this helper property filled on all objects, then you can perform a search "Number of revisions > 1".

Children
No Data
M-Files
M-Files Support


© 2024 M-Files, All Rights Reserved.