How to set NULL value to nillable element in TIBCO?
Scenario: I had
nillable element of type datetime. I needed to set value only when incoming
value was datetime, otherwise I had to send null.
Sample
XSD:
<?xml version="1.0"
encoding="UTF-8"?>
<xs:schema
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns="http://www.tibco.com/schemas/FunctionsTest/Schema.xsd3"
targetNamespace="http://www.tibco.com/schemas/FunctionsTest/Schema.xsd3"
elementFormDefault="qualified"
attributeFormDefault="unqualified">
<xs:element
name="empStatus">
<xs:complexType>
<xs:sequence>
<xs:element
name="Status" type="xs:dateTime" nillable="true"
minOccurs="0"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Solution:
Input
Request:
- Right click on element and select: Statement->Surround with Choice
- Select 1 when condition and otherwise
- In when condition should be something like this: string-length(value)>0
- If condition is true -> insert value
- Click on the element in otherwise section and select “!” in menu. Then: Content->Set explicit Nil
Test
Results:
Input: with NULL value
Output:
Input: with value
Output:
