<cond> attributes

extkey2

extkey2
Syntax	[extkey2 = Boolean : false]
May occur in	<cond> (any valid field)
Description	An indicator of whether the parent catalog is specified as external key (as opposed to textual value).
Remarks	See also the mnr2 attribute.

In this example all interest records are returned where the external key of InterestGroup="ext_parent" AND the external key of Interest="ext_child". Both catalogs are specified as external keys, the child catalog due to attribute extkey="true", the parent catalog due to extkey2="true".

      <request>
        <query>
          <tables>
            <table tablename="Interests"/>
          </tables>
          <fields tablename="Interests" fields="InterestGrp,Interest"/>
          <condition>
            <cond tablename="Interests" fieldname="Interest" op="=" extkey="true" value="ext_child" extkey2="true" value2="ext_parent"/>
          </condition>
        </query>
      </request>

mnr2

mnr2
Syntax	[mnr2 = unsignedShort]
May occur in	<cond> (any valid field)
Description	The tenant number for a parent catalog.
Remarks	See also the extkey2 attribute.

op

op
Syntax	[op = string]
May occur in	<cond>
Values	=, != (also <>), <, >, <=, >=, (), )( Note: These operators must be given in escaped form, e.g. "<" instead of "<" and "&lgt;" instead of ">".
Description	The comparison operator for a single condition.
Remarks	The () and )( operators mean "containing" and "not containing".

value2

value2
Syntax	[value2 = string]
May occur in	<cond> (any valid field)
Description	The value of the parent catalog.
Remarks	none

lupd

lupd
Syntax	[lupd = string]
May occur in	<cond>
Description	The value of the last-modified timestamp of a specified field.
Remarks	See query with conditions with condition on timestamp.