search for class document objects per project comapi c#

Question

I'm trying to write a report of document objects by class per project using the comapi in C#. I've wrote a search condition that iterates through each object class looking for the property definition id for the project but I'm not getting the results I'm expecting. I need some guidance as to what I'm doing wrong 
 ObjTypes oObjectTypes = mfServerApplication.LogInToVault(GetVaultGuid).ObjectTypeOperations.GetObjectTypes(); foreach (ObjType oObjType in oObjectTypes) { //foreach (PropertyDef propDef in propDefs) //{ int propertydef = 0; var searchConditions = new SearchConditions(); 
 // Add an object type filter. { // Create the condition. var condition = new SearchCondition(); 
 // Set the expression. condition.Expression.SetStatusValueExpression(MFStatusType.MFStatusTypeObjectTypeID); 
 // Set the condition. condition.ConditionType = MFConditionType.MFConditionTypeEqual; 
 // Set the value. condition.TypedValue.SetValue(MFilesAPI.MFDataType.MFDatatypeLookup, oObjType.ID); 
 // Add the condition to the collection. searchConditions.Add(-1, condition); } 
 // Add a "not deleted" filter. { // Create the condition. var condition = new SearchCondition(); 
 // Set the expression. condition.Expression.SetStatusValueExpression(MFStatusType.MFStatusTypeDeleted); 
 // Set the condition. condition.ConditionType = MFConditionType.MFConditionTypeEqual; 
 // Set the value. condition.TypedValue.SetValue(MFilesAPI.MFDataType.MFDatatypeBoolean, false); 
 // Add the condition to the collection. searchConditions.Add(-1, condition); } 
 { // Create the condition. var condition = new SearchCondition(); 
 //condition.Expression.SetPropertyValueExpression(propDef.ID, MFParentChildBehavior.MFParentChildBehaviorNone); condition.Expression.SetPropertyValueExpression(propertydef, MFParentChildBehavior.MFParentChildBehaviorNone); 
 // Set the condition. condition.ConditionType = MFConditionType.MFConditionTypeEqual; //1454 is the Arm Project id condition.TypedValue.SetValue(MFDataType.MFDatatypeMultiSelectLookup, 1454); 
 var customerObjectTypeIndirectionLevel = new PropertyDefOrObjectType(); customerObjectTypeIndirectionLevel.PropertyDef = false; // We do not care which property definition is used. customerObjectTypeIndirectionLevel.ID = oObjType.ID; // Instead care which object type it is related to. condition.Expression.IndirectionLevels.Add(-1, customerObjectTypeIndirectionLevel); 
 // Add the condition to the collection. searchConditions.Add(-1, condition); } 
 ObjectSearchResults searchRes = mfServerApplication.LogInToVault(GetVaultGuid).ObjectSearchOperations.SearchForObjectsByConditionsEx(searchConditions, MFSearchFlags.MFSearchFlagNone, SortResults: false); 
 foreach (var results in searchRes) { Console.WriteLine(results); } }

Craig Hawker · Accepted Answer

Indirections aren't used for groupings. 
 Consider an example where you want to search for all "contacts whose company is based in the UK". In that case the property you want to search on (country) is not on the contact itself, but on a related object (the company). Indirection levels are used to express that relationship. There's some more details here: Search conditions in the M-Files API . 
 You cannot directly perform a "group by" within an API search. I think you have three options: 
 
 Search for all documents, retrieve the properties for them, and then perform the grouping in your calling application.
 
 Note that the search results have a practical limit though, so in large vaults you may not be able to get them all at once. 
 Note also that you'll want to use the "GetPropertiesOfMultipleObjects" API method to retrieve batches of properties from the vault, rather than querying one-by-one.

Retrieve the projects you're interested in from the API with one search, then use that to execute one or more additional queries to retrieve the documents.
 
 You could literally run one search per project; this may be good if the number of documents per project is high. 
 Or you could perhaps create a "one of" search condition to find all documents where the "project" is "one of" a selection of projects; note again the search limit though, so this may also be a concern.

Use a reporting database. 
 
 Honestly: probably the best way to do this is to use a reporting database. The M-Files APIs aren't great at set-based queries, but SQL definitely is.

search for class document objects per project comapi c#

Top Replies