setting a search condition on a lookup property but with text

No idea if this is the best way to do it, but this is how I do it.  I will use the following code to get a value list item ID (you could tweak the Where method to return any number of ).

Then once you have all the IDs in an array, you can use the "one of" search defined here: developer.m-files.com/.../

hi

i don't think this would work. 

my search conditions are some lookup values (looking on an object, not value list) chosen on some metadata card.

for example

searchconditions - "2.1" - that is the text value you can see on the metadata card, but is a lookup value

                            - "1.4.3"  -||-

                            -  "3"

and so on

my search result should return objects, that have lookup values

2.1.4.3  -  because it starts with 2.1

2.1.5   -  because it starts with 2.1

1.4.3.5    - because it starts with 1.4.3

1.4.3   - because it starts with 1.4.3

3.2.1   - because it starts with 3

...

getting all IDs possible so i can search for objects is not what i want to do.

that would mean i have to get all IDs, that are on the same level or under.

for example

if i have 2.1 i would have to get all underlying IDs (it goes 4 levels deep) and the do the search for each one

2.1

2.1.1

   2.1.1.1

       2.1.1.1.1

       2.1.1.1.2

        ....

   2.1.1.2

       ....

   2.1.1.3

    ....

2.1.2

    ....

2.1.3

    ....

doing a "startswith" would be perfect. But this works on a text PD.

thank you

Have done stuff like this using a traditional search operation with 2 conditions, one to define the object type and one that use "Contains" on the object name. "StartsWith" might be better suited here.

In your case you need to run the search once for each of your selected values and add the search results to a common list. When done that list contains all of the desired objects.

Hi

Thank you for the reply.

I don't see how this would work. If i do a search for each lookup value in my search condition, i would only get results that have exactly those values in lookups.

But i also need to check for all other lookup values, that are not among the search conditions.

Like i described before:

i have let's say 4 lookup values for my search conditions.

I have to find all objects that have those lookup values or lookups that are on the next lower level.

if my search condition is "2.3" - (a lookup value)

then my search result should return objects that have lookup values such as

2.3.5

2.3.1

.......

the one "2.3" that is selected on my search condition card, is not necessarily also on the objects card.

thank you

You can search for value list items with the "starts with" condition type: Searching for value list items (m-files.com)

Once you have those items, you can doa "one of" search: Search conditions in the M-Files API

Hi Craig

 DCPDamon and you Craig are telling the same thing, so i had to re-think your logic.

I should first have to find all the search conditions from those 3 that i have set as my original search conditions, and then all objects that are connected to those lookup values.

At first i didn't get the logic behind that, because i was starting my search logic from the other end.

I wanted to search for all the objects without getting all search IDs, just "starts with", so i apologize to DCPDamon. You are both right.

i would like to accept the answer from DCPDamon, but at the same time yours, since they are telling me the same logic

Can i accept both?

thank you

Simply click the accept button next to both. A question can have two accepted answers.