Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Button handy
blanktrue
color#0052CC
nameSend Feedback
linkhttps://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=isNull+-+15488773
widthauto

Table plus
applyColStyleToCelltrue
columnTypess,s,s,s
heading0
multiplefalse
columnAttributesstyle="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,

...

...

enableSorting

...

false

Syntax

isNull(variable)

Package

Alias

Pkg Usage

Description

Excerpt
hiddentrue
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 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

Parameters

Table plus
applyColStyleToCelltrue
columnTypess,s,s,

...

<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>

Info
titleAvailability

This routine is available starting with SIL Engineā„¢ 1.0.

Syntax

isNull(variable)

Description

Excerpt

Checks if the provided variable is null or has no value associated then returns "true", otherwise returns "false".

Parameters

...

Parameter name

...

Required

...

Description

...

variable

s
heading0
multiplefalse
enableSortingfalse

Parameter name

Type

Required

Description

variable

Any

Yes

Value you want to test. Value argument can be a string or a variable of any type.

Return

...

Type

boolean Boolean (true/false)

Examples

Example 1

...

Checks whether the assignee was selected for a

...

ticket.

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

Example 2

...

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

Code Block
if(isNull(timeSpent)assignee)) {
  assignee = reporter;
}

You can also use the hasInput routine function 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

Note

If isNull returns "true" the variable has no value attached. isNull returns "false" for zero for numeric variables or blank for character/string.

See also

Filter by label (Content by label)
showLabelsfalse
max25
showSpacefalse
cqllabel = "basic_routines"routine" and space = currentSpace ( )
labelsbasicarray_routines