SELECT MAX(INT_VALUE)

Question

Hi Community, 
 I'm implementing a search in VAF (C#) and was wondering if there is a handy way to get - similar to SQL - the highest number - of a Metadata-Card-Property-Int-Value of a group of certain documents 
 
 var searchBuilder = new MFSearchBuilder(env.Vault);
searchBuilder.NotObject(env.ObjVer.ObjID.ID);
searchBuilder.Class(MyClassId); //certain class
//something like
"searchBuilder.MaxValue(PD.PropertyXY);" 
 
 Or do I have to loop over all class-documents by myself and find the max by myself? 
 Thanks in advance 
 Best regards 
 Alex

Craig Hawker · Accepted Answer

Unfortunately there is no way to do this. You may be able to persist some sort of value in NVS that contains this (when an object is checked in, read the value, check whether it's higher than the stored value, then update).

Craig Hawker · Answer

Sorry, NVS = "Named Value Storage". It's a key-value-pair storage mechanism available to you. You can read/write to it through "Vault.NamedValueStorageOperations": M-Files API - VaultNamedValueStorageOperations Object

SELECT MAX(INT_VALUE)

Top Replies