319
edits
Changes
→Report Query Filtering
Finally, ImsmaQuery language can support the "IN" operator. The IN operation takes a comma separated, double quoted list, bounded by parentheses as it's value. As in:
localId IN ("value1", "value2", "value3")
====ImsmaQuery Examples====
localId LIKE "MF-HQ-%"
endDate > 2010-09-01 AND endDate <2010-09-30
links.toGuid = "$P{ItemGUID}" and type = "ProgressReport"
areaSize < 1000.0
status ="Active" OR status = "Transitional"
{{note | Numeric fields should always have the ''value'' portion of the filter set to a decimal.
Dates should use the format yyyy-MM-dd.
Strings from lookup tables (i.e. ImsmaEnum) should always refer to the key value rather than the translated value.}}
==the SQL Field==