setting a search condition on a lookup property but with text

Question

Hi 
 
 i would like to set a search condition on a lookup property but i have to search for a text value within: 
 so i would like to use 
 SearchCondition sc = new SearchCondition(); sc.ConditionType= MFConditionType.MFConditionTypeStartsWith; 
 how can i do this on a lookup value? 
 for example: 
 in a multi lookup there are several selected values for my search criteria 
 1) 1.4.3.2 
 2) 2.3 
 3) 1.1.4 
 
 now i have to find all objects, that have selected values in their lookups, but there can also be values such as: 
 1) 1.4.3.2.5 -> this one starts with the first search criteria 1.4.3.2 so it should be in the result collection 
 2) 2.3.4.5 -> this one starts with the second criteria 2.3 so it should be in the result collection 
 ... 
 
 so i have to find all objects that have values in a lookup that start with 1.4.3.2 and 2.3 and so on. - from the search criteria 
 how can this be done? 
 
 thank you

DCPDamon · Accepted Answer

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 ). 
 int[] invoiceOriginId = vault.ValueListItemOperations .GetValueListItems(vault.ValueListOperations.GetValueListIDByAlias("My Alias")) .Cast<ValueListItem>() .Where(i => i.Name == "SO") .Select(i => i.ID); 
 
 Then once you have all the IDs in an array, you can use the "one of" search defined here: developer.m-files.com/.../

Craig Hawker · Answer

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

setting a search condition on a lookup property but with text

Top Replies