Duplicate Rows Check in Decision Table

Hi,

The first thing that comes to mind is to create a Custom Provider for this. Almost every API method of a Custom Provider takes an NdProviderContext as a parameter, and the NdProviderContext will give you access to the instantiation model (the XML structure of your table/repository entry).

For validation, you could then inspect the table to check for duplicates in the provider.

To "enable" this kind of checking, you could create a column with a value holder where the value holder type is your custom provider. Alternatively you could add the value holder to an existing column definition.

Regards,

Jostein

You can also look at the verification service.  It can detect duplicates as well as overlaps (which may be tricky to try to implement from scratch).

Carole-Ann

VP, Product Management

http://www.teitter.com/CMatignon

Thanks Jostein & Carole for your inputs.

Carole, my understanding is verification service can only be employed in the builder. It cannot be run directly from RMA when user enters any information. I could see there is facility to modify the parameters of verification service through RMA but no mechanism to actually execute it. Is there any way to accomplish this as well.

Regards,

Arun

Arun, what version of Blaze Advisor are you using? Starting from Blaze 6.6, verification query can be invoked from the RMA.

Arun,

The Verification service is readily integrated in the RMA (can be triggered from the Tools combo box).  It can also be invoked via APIs that you are welcome to integrate with your code.

Thanks,

Carole-Ann

VP, Product Management

http://www.twitter.com/CMatignon

Thanks Andrei & Carole.

I am having BA6.5.5 .NET version. As per your comments, I believe this will not have verification service invokation support through RMA. Can you please confirm.

Regards,

Arun

Sorry, it is not exposed in the RMA in 6.5.x version of Blaze.

Thanks for the response Andrei.

Regards,

Arun