isNull

<ac:structured-macro ac:name="table-plus" ac:schema-version="1" data-layout="default">
<ac:parameter ac:name="applyColStyleToCell">true</ac:parameter>
<ac:parameter ac:name="heading">0</ac:parameter>
<ac:parameter ac:name="columnTypes">s,s,s,s</ac:parameter>
<ac:parameter ac:name="multiple">false</ac:parameter>
<ac:parameter ac:name="columnAttributes">style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,</ac:parameter>
<ac:parameter ac:name="enableSorting">false</ac:parameter>
<ac:rich-text-body>
<table data-layout="default">
<colgroup>
<col style="width: 76.0px;" />
<col style="width: 278.0px;" />
<col style="width: 106.0px;" />
<col style="width: 266.0px;" />
</colgroup>
<tbody>
<tr>
<td>
<p><strong>Syntax</strong></p>
</td>
<td>
<p>isNull(variable)</p>
</td>
<td>
<p><strong>Package</strong></p>
</td>
<td>
<p></p>
</td>
</tr>
<tr>
<td>
<p><strong>Alias</strong></p>
</td>
<td>
<p></p>
</td>
<td>
<p><strong>Pkg Usage</strong></p>
</td>
<td>
<p></p>
</td>
</tr>
</tbody>
</table>
</ac:rich-text-body>
</ac:structured-macro>
<h2>Description</h2>
<p><ac:structured-macro ac:name="excerpt" ac:schema-version="1" data-layout="default">
<ac:parameter ac:name="hidden">true</ac:parameter>
<ac:rich-text-body>
Checks if the provided variable is null or has no value associated then returns "true", otherwise returns "false".
</ac:rich-text-body>
</ac:structured-macro>
<p>Checks if the provided variable is null or has no value associated then returns "true", otherwise returns "false".</p></p>
<h2>Parameters</h2>
<ac:structured-macro ac:name="table-plus" ac:schema-version="1">
<ac:parameter ac:name="applyColStyleToCell">true</ac:parameter>
<ac:parameter ac:name="columnTypes">s,s,s,s</ac:parameter>
<ac:parameter ac:name="heading">0</ac:parameter>
<ac:parameter ac:name="multiple">false</ac:parameter>
<ac:parameter ac:name="enableSorting">false</ac:parameter>
<ac:rich-text-body>
<table data-layout="default">
<colgroup>
<col style="width: 170.0px;" />
<col style="width: 97.0px;" />
<col style="width: 108.0px;" />
<col style="width: 305.0px;" />
</colgroup>
<tbody>
<tr>
<th>
<p>Parameter name</p>
</th>
<th>
<p>Type</p>
</th>
<th>
<p>Required</p>
</th>
<th>
<p>Description</p>
</th>
</tr>
<tr>
<td>
<p>variable</p>
</td>
<td>
<p>Any</p>
</td>
<td>
<p>Yes</p>
</td>
<td>
<p>Value you want to test. Value argument can be a string or a variable of any type.</p>
</td>
</tr>
</tbody></table></ac:rich-text-body></ac:structured-macro>
<h2>Return Type</h2>
<p><strong>Boolean (true/false)</strong></p>

<h2>Examples</h2>
<h3>Example 1</h3>
<p>Checks whether the assignee was selected for a ticket.</p>
<ac:structured-macro ac:name="code" ac:schema-version="1">
<ac:plain-text-body>
<![CDATA[if(isNull(assignee)) {
assignee = reporter;
}]]>
</ac:plain-text-body>
</ac:structured-macro>

<h3>Example 2</h3>
<p>The following line checks whether the <strong>Time Spent</strong> field contains any work logged on the ticket.</p>
<ac:structured-macro ac:name="code" ac:schema-version="1">
<ac:plain-text-body>
<![CDATA[if(isNull(assignee)) {
assignee = reporter;
}]]>
</ac:plain-text-body>
</ac:structured-macro>
<p>You can also use the <ac:link><ri:page ri:content-title="hasInput"/></ac:link> routine to check whether certain fields were filled out during a workflow transition. And among those fields you can also check the work logged in particular.</p>

<h2>Note</h2>
<p><ac:structured-macro ac:name="note" ac:schema-version="1">
<ac:rich-text-body>
<p>If <strong>isNull</strong> returns "true" the variable has no value attached. <strong>isNull</strong> returns "false" for <strong>zero</strong> for numeric variables or <strong>blank</strong> for character/string.</p>
</ac:rich-text-body>
</ac:structured-macro></p>

<h2>See also</h2>
<p><ac:structured-macro ac:name="contentbylabel" ac:schema-version="4">
<ac:parameter ac:name="showLabels">false</ac:parameter>
<ac:parameter ac:name="max">25</ac:parameter>
<ac:parameter ac:name="showSpace">false</ac:parameter>
<ac:parameter ac:name="cql">label = "basic_routines" and space = currentSpace ( )</ac:parameter>
<ac:parameter ac:name="labels">array_routines</ac:parameter>
</ac:structured-macro></p>

Syntax

isNull(variable)

Description

Parameters

Return type

boolean (true/false)

Examples

Example 1 - checking whether the assignee was selected for a ticket 

if(isNull(assignee)) {
  assignee = reporter;
}

Example 2 - checking whether work was logged on ticket

The following line checks whether the Time Spent field contains any work logged on the ticket.

isNull(timeSpent)

You can also use the hasInput routine to check whether certain fields were filled out during a workflow transition. And among those fields you can also check the work logged in particular.

Notes

See also

• Page:
  logPrint
• Page:
  print
• Page:
  isNull
• Page:
  isNotNull