What a coincidence. I fought with the Group monster all morning:
Here are my tests: do what you want to figure out how the thing works. IMO it doesn't work nearly well enough!
<font class="small">Code:</font><hr /><pre> Set Selection Append Flag(FC Grid, <Yes>)
Set Selection Group(FC Grid, "F41021", "pqoh", <Not Equal To>, <Zero>, <Or>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, "F41021", "ITM", <Equal To>, <Zero>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021
WHERE (((LIITM = ? OR (LIPQOH <> ? OR LIPQOH > ? )))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, "F41021", "ITM", <Equal To>, <Zero>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021
WHERE ((((LIITM = ? AND LIITM = ? ) AND (LIPQOH <> ? OR LIPQOH > ? )))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE
(((LIITM = ? OR (LIITM = ? AND (LIPQOH <> ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE (((LIITM = ? OR (LIITM = ? AND (LIPQOH <> ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <Or>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE ((((LIITM = ? OR LIITM = ? ) OR (LIITM > ? AND (LIPQOH <> ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE (((LIITM = ? OR ((LIITM = ? AND LIITM > ? ) AND (LIPQOH <> ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Less Than>, <Zero>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE (((LIITM < ? OR ((LIITM = ? AND LIITM > ? ) AND (LIPQOH <> ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Less Than>, <Zero>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE (((((LIITM = ' ' AND LIITM < 0 ) AND LIITM > 0 ) AND (LIPQOH <> ? OR LIPQOH > ? )))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Less Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <Or>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE ((((LIITM = ? OR LIITM < ? ) OR (LIITM > ? AND (LIPQOH <> ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Less Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <Or>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE ((((LIITM = ? OR LIITM < ? ) OR (LIITM > ? AND (LIPQOH <> ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "pqoh", <Not Equal To>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <Or>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE ((((LIITM = ? OR LIITM = ? ) OR (LIITM > ? AND (LIPQOH <> ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "PREQ", <Greater Than>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <Or>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE ((((LIITM = ? OR LIITM = ? ) OR (LIITM > ? AND (LIPREQ > ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "PREQ", <Greater Than>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Blank>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE (((LIITM = ? OR ((LIITM = ? AND LIITM > ? ) AND (LIPREQ > ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "PREQ", <Greater Than>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Not Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Less Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE
(
(
(
(
(LIITM = ? AND LIITM > ? )
OR
(LIITM <> ? AND LIITM > ? )
)
OR
(
(LIITM < ? AND LIITM > ? )
AND
(LIPREQ > ? OR LIPQOH > ? )
)
)
)
) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "PREQ", <Greater Than>, <Zero>, <And>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Not Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Less Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE (((((LIITM = ? AND LIITM > ? ) OR (LIITM <> ? AND LIITM > ? )) OR (((LIITM < ? AND LIITM > ? ) AND LIITM > ? ) AND (LIPREQ > ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "PREQ", <Greater Than>, <Zero>, <None>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Not Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Less Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
Set Selection(FC Grid, F41021, "ITM", <Greater Than>, <Blank>, <And>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE (((((LIITM = ? AND LIITM > ? ) OR (LIITM <> ? AND LIITM > ? )) OR (((LIITM < ? AND LIITM > ? ) AND LIITM > ? ) AND (LIPREQ > ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Selection Group(FC Grid, F41021, "PREQ", <Greater Than>, <Zero>, <None>)
Set Selection Group(FC Grid, F41021, "pqoh", <Greater Than>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Not Equal To>, <Zero>, <Or>)
Set Selection(FC Grid, F41021, "ITM", <Less Than>, <Zero>, <Or>)
SELECT LILOTN,LILOCN,LIMCU,LIITM FROM CV2DTA.F41021 WHERE ((((LIITM = ? OR LIITM <> ? ) OR (LIITM < ? AND (LIPREQ > ? OR LIPQOH > ? ))))) ORDER BY LIITM ASC , LIMCU ASC , LILOCN ASC , LILOTN ASC
</pre><hr />