QTIPS - Btree.Extract
| Published By | Date | Version | Knowledge Level | Keywords |
|---|---|---|---|---|
| Sprezzatura Ltd | 01 AUG 1989 | 1.14+ | EXPERT | BTREE.EXTRACT, XREF.PARAMS |
When using BTREE.EXTRACT it can be useful to get at all those records WITHOUT a value in a field. For example, you may wish to extract all employees for whom the date of birth is not on file. Or conversely you may wish to get at all those employees who have been to University.
Calling BTREE.EXTRACT with XREF.PARAMS set to ="" or #"" does not work. Instead, the syntax <="" and >"" must be used. E.G.
PARAM ="DOB":@VM:"<=' ' ": @FM
or
PARAM = "UNI":@VM:">' ' ":@FM
(Volume 1, Issue 4, Page 3)