Example Filtering Records Based on Effective Date using Context Variables
Declare RUL_EFF_DATE1 and RUL_SHORTDESC variables in TIBCO MDM Studio Rulebase Designer; specify usage="local".
Refer the Rulebase sample:
<rulebase metaversion="1.0" xmlns="http://www.tibco.com/cim/rulebase/beans">
<name>rule</name>
<declare usage="local">
<var>RUL_EFF_DATE1</var>
<datatype type="date"/>
</declare>
<declare usage="local">
<var>RUL_SHORTDESC</var>
<datatype type="string"/>
</declare>
<constraint>
<name>con</name>
<description>con</description>
<condition>
<and>
<eq>
<var>EFFECTIVEDATE</var>
<var>RUL_EFF_DATE1</var>
</eq>
<eq>
<var>SHORTDESC</var>
<var>RUL_SHORTDESC</var>
</eq>
</and>
</condition>
<action>
<access mode="hide_record"/>
</action>
</constraint>
</rulebase>
Pass the context variable in webservice request as below:
<DataService version="2.0">
<Identity>
<DirectoryPath>
<Directory type="Enterprise">Tech</Directory>
<Directory type="User">jsmith</Directory>
</DirectoryPath>
<Authentication>a</Authentication>
</Identity>
<Transaction>
<Context>
<Variable name="RUL_EFF_DATE" type="date">07/11/2011</Variable>
<Variable name="RUL_SHORTDESC" type="string">RECORD7</Variable>
</Context>
<Command type="Query">
<StartCount>1</StartCount>
<MaxCount>50</MaxCount>
<MasterCatalogRecord etype="Entity">
<ExternalKeys>
<Key name="MASTERCATALOGNAME" type="string">CUSTOMER</Key>
</ExternalKeys>
</MasterCatalogRecord>
</Command>
</Transaction>
</DataService>
This hides all records with EFFECTIVEDATE=" 2011-07-11 00:00:00.000" and SHORTDESC =Record7.
Copyright © Cloud Software Group, Inc. All rights reserved.
