How to check a property value to make sure it is unique?

Hi Jeff, 

Generally, you would need to search for the particular document and by specific property and its value. I've done it in some cases based on document id where we needed to treat them unique. The code is however in C#/VAF framework.

I could imagine you can use the same in VBScript but I haven't used for a long time.

Here some examples from portal how you could search based on metadata (VAF optimized however): https://developer.m-files.com/Frameworks/Vault-Application-Framework/Searching/. This would be particular example: https://developer.m-files.com/Frameworks/Vault-Application-Framework/Helpers/MFSearchBuilder/#restricting-by-property .

Best,

Dejan

Hi Jeff, 

Generally, you would need to search for the particular document and by specific property and its value. I've done it in some cases based on document id where we needed to treat them unique. The code is however in C#/VAF framework.

I could imagine you can use the same in VBScript but I haven't used for a long time.

Here some examples from portal how you could search based on metadata (VAF optimized however): https://developer.m-files.com/Frameworks/Vault-Application-Framework/Searching/. This would be particular example: https://developer.m-files.com/Frameworks/Vault-Application-Framework/Helpers/MFSearchBuilder/#restricting-by-property .

Best,

Dejan

Yes, basically the customer is registering objects into the vault and each must have a unique ID number that suits the customer's desired format. (e.g., "A2023042401, B984375987...") If someone tries to register an object and uses an ID number that already exists, we want to reject that. (There is unfortunately no particular logic to the numbering, so we can't use automatic property defs.)

We don't want to make a value list because the number of objects can reach six figures. So I assume it would follow 

1. Get input value.

2. Search for that value across all objects where this property is defined

3. Raise error if found.

For this I think you can use Compliance Kit's Unique Object Enforcement, where you add filter on properties to check, and if it is found, it will raise an error.