Flow Filters for IBM Rational DOORS
To filter the record(s) based on field type – Text
To filter the record(s) based on below fields (field type 'Text'), pass the attribute name along with the value.
Object Text
rm:primaryText="test1"
Record(s) not having an empty value
rm:primaryText!= ""
Record(s) having an empty value
rm:primaryText=""
Record(s) not having the passing value
rm:primaryText!="test1"
Record(s) having any of the values(complete matching)
rm:primaryText in ["test1","test2 is good"]
For custom field type text
Everything will be the same except the key:
example : rm_property:attrDef-1001="test1"
To filter the record(s) based field type – String
To filter the record(s) based on below fields (field type 'string'), pass the attribute name along with the value.
Object Heading
doorsAttribute:objectHeading="test1"
Record(s) not having an empty value
doorsAttribute:objectHeading!= ""
Record(s) not having an empty value
doorsAttribute:objectHeading=""
Record(s) not having the passing value
doorsAttribute:objectHeading!="test1"
Record(s) having any of the String values (complete matching).
doorsAttribute:objectHeading in ["test1","test2 is good"]
Object Short Text
doorsAttribute:objectShortText="test1"
Record(s) not having an empty value
doorsAttribute:objectShortText!= ""
Record(s) having an empty value
doorsAttribute:objectShortText=""
Record(s) having the passing value
doorsAttribute:objectShortText!="test1"
Record(s) having any of the String values(complete matching)
doorsAttribute:objectShortText in ["test1","test2 is good"]
Created By
doorsAttribute:createdBy="admin"
Record(s) not having an empty value
doorsAttribute:createdBy!= ""
Record(s) having an empty value
doorsAttribute:createdBy=""
if you want to retrieve the records not having the passing value
doorsAttribute:createdBy!="admin"
Record(s) having any of String values.
doorsAttribute:createdBy in ["admin","jack"]
Last Modified By
doorsAttribute:modifiedBy="admin"
Record(s) having not empty value
doorsAttribute:modifiedBy!= ""
Record(s) having empty value
doorsAttribute:modifiedBy=""
Record(s) not having the passing value
doorsAttribute:modifiedBy!="admin"
Record(s) having any of String values.
doorsAttribute:modifiedBy in ["admin","jack"]
For customField type String
Everything will be the same except the key:
example : rm_property:attrDef-1002="test1"
To filter the record(s) based on field type – Integer
To filter the record(s) based on below fields (field type 'Integer'), pass the attribute name along with the value.
Absolute Number
doorsAttribute:absoluteNumber=1
Record(s) having greater than & equal to the value
doorsAttribute:absoluteNumber>=1
Record(s) having less than & equal to the value
doorsAttribute:absoluteNumber<=1
Record(s) having greater than value
doorsAttribute:absoluteNumber>1
Record(s) having less than value
doorsAttribute:absoluteNumber<1
Record(s) having not empty value
doorsAttribute:absoluteNumber!=""
Record(s) having empty value
doorsAttribute:absoluteNumber=""
Record(s) not having the passing value
doorsAttribute:absoluteNumber!=1
Record(s) having any of String values.
doorsAttribute:absoluteNumber in [1,2]
For customField type Integer
Everything will be the same except the key
example : rm_property:attrDef-1003=1
To filter the record(s) based on field type – Boolean
To filter the record(s) based on below fields (field type 'Boolean'), pass the attribute name along with the value.
For CustomField Boolean
rm_property:attrDef-1005=true
Record(s) having not empty value
rm_property:attrDef-1005!=""
Record(s) having empty value
rm_property:attrDef-1005=""
Record(s) having the passing value
rm_property:attrDef-1005!=true
Record(s) having any of String values.
rm_property:attrDef-1005 in [true,false]
To filter the record(s) based on field type – Date
To filter the record(s) based on below fields (field type, 'Date'), pass the attribute name along with the value.
Created On
doorsAttribute:createdOn="2010-10-08"
Record(s) having greater than & equal to the value
doorsAttribute:createdOn>="2010-10-08"
Record(s) having less than & equal to the value
doorsAttribute:createdOn<="2010-10-08"
Record(s) having greater than value
doorsAttribute:createdOn>"2010-10-08"
Record(s) having less than value
doorsAttribute:createdOn<"2010-10-08"
Record(s) not having an empty value
doorsAttribute:createdOn!=""
Record(s) having an empty value
doorsAttribute:createdOn=""
Record(s) not having the passing value
doorsAttribute:createdOn!="2010-10-08"
Record(s) having any of the String values
doorsAttribute:createdOn in ["2010-10-08","2010-06-26"]
Last Modified On
doorsAttribute:modifiedOn="2010-10-08"
Record(s) having greater than & equal to the value
doorsAttribute:modifiedOn>="2010-10-08"
Record(s) having less than & equal to the value
doorsAttribute:modifiedOn<="2010-10-08"
Record(s) having greater than value
doorsAttribute:modifiedOn>"2010-10-08"
Record(s) having less than value
doorsAttribute:modifiedOn<"2010-10-08"
Record(s) not having an empty value
doorsAttribute:modifiedOn!=""
Record(s) having an empty value
doorsAttribute:modifiedOn=""
Record(s) not having the passing value
doorsAttribute:modifiedOn!="2010-10-08"
Record(s) having any of the String values
doorsAttribute:modifiedOn in ["2010-10-08","2010-06-26"]
For customField type date
Everything will be the same except the key:
example : rm_property:attrDef-1005="2010-10-08"
To filter the record(s) based on field type – Datetime
To filter the record(s) based on below fields (field type 'Datetime'), pass the attribute name along with the value.
dcterms:modified="2010-10-08T13:59:12T"
Record(s) having greater than & equal to the value
dcterms:modified>="2010-10-08T13:59:12T"
Record(s) having less than & equal to the value
dcterms:modified<="2010-10-08T13:59:12T"
Record(s) having greater than value
dcterms:modified>"2010-10-08T13:59:12T"
Record(s) having less than value
dcterms:modified<"2010-10-08T13:59:12T"
Record(s) not having an empty value
dcterms:modified!=""
Record(s) having an empty value
dcterms:modified=""
Record(s) not having the passing value
dcterms:modified!="2010-10-08T13:59:12T"
Record(s) having any of list of datetime values
dcterms:modified in ["2010-10-08T13:59:12T","2010-10-26T11:19:11T"]
For customField type datetime
Everything will be the same except the key:
example : rm_property:attrDef-1006="2010-10-08T13:59:12T"
To filter the record(s) based on field type – Enumeration
To filter the record(s) based on below fields (field type Enumeration (single value field)), pass the attribute name along with the value.
For CustomField Enumeration
Based on Value
rm_property:attrDef-1007="Extracting"
Record(s) not having an empty value
rm_property:attrDef-1007!=""
Record(s) having an empty value
rm_property:attrDef-1007=""
Record(s) not having the passing value
rm_property:attrDef-1007!="Extracting"
Record(s) having any of list values
rm_property:attrDef-1007 in ["Extracting","Copying"]
To pass the uri as the parameter, the uri should be also enclosed by angle bracket
Based on URI
rm_property:attrDef-1007=<http://doors97.connectall.com:8080/dwa/rm/urn:rational::1-5fe9ce5c2a5b21bb-M-00000060/types/attrDef-1007#3>
Record(s) not having an empty value
rm_property:attrDef-1007!=""
Record(s) having an empty value
rm_property:attrDef-1007=""
Record(s) not having the passing value
rm_property:attrDef-1007!=<http://doors97.connectall.com:8080/dwa/rm/urn:rational::1-5fe9ce5c2a5b21bb-M-00000060/types/attrDef-1007#3>
Record(s) having any of list values
rm_property:attrDef-1007 in [<http://doors97.connectall.com:8080/dwa/rm/urn:rational::1-5fe9ce5c2a5b21bb-M-00000060/types/attrDef-1007#3>,<http://doors97.connectall.com:8080/dwa/rm/urn:rational::1-5fe9ce5c2a5b21bb-M-00000060/types/attrDef-1007#2>]
To filter the record(s) based on below fields
Input the below value to the flow filter at DOORS end
rm_property:attrDef-1007="Extracting" and rm_property:attrDef-1006>="2010-10-08T13:59:12T"