This project is read-only.

Special and Generic values

Special values

It could be useful to use following features when comparing

Null

if you want to specify a cell with a null value, simply write an empty tag or specify (null) in your tag.
<cell/>
or
<cell></cell>
or
<cell>(null)</cell>

Empty string

If you want to specify that an empty value (string with length of 0 characters) will be a valid result, you can specify "(empty)" in your xml element.
<cell>(empty)</cell>

Boolean values

The values true, false, yes and no are valid to express a boolean. Case is not sensitive, meaning that True or YES are also valid values.
<cell>true</cell>
<cell>false</cell>
<cell>yes</cell>
<cell>no</cell>

Generic values

A generic value is a substitue for a value. Usually, when you're filling the content of the cell with a value such as my field or 100.25 or 2013-10-25, you'll want to compare this string transformed in numeric or dateTime value to the contentof your query's cell. With generic value you'll have some flexibility and be able to compare your query cell to a range of values.

Not null

If you want to specify that any non-null value will be a valid result, you can specify "(value)" in your xml element
<cell>(value)</cell>

Null or not null

If you want to specify that any value will be a valid result, you can specify "(any)" in your xml element
<cell>(any)</cell>

More to come with, (positive), (negative), ...

Last edited Oct 5, 2013 at 8:45 AM by Seddryck, version 1

Comments

No comments yet.