RLIST question (OpenInsight 32-bit Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== RLIST question (OpenInsight 32-bit Specific) ====
=== At 21 AUG 2003 01:41:10PM b cameron Works Member wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
If field of CUSTOMERS is multivalued and I want to exclude certain values from the listing how is that accomplished with RList?



Example...



LIST CUSTOMERS FLD2

Output 

0001          Bob's Stores

              JimBo's Stores

              MaryEllens Stores

0002          Bob's Stores

              Gramma's Stores



I would like to 

LIST CUSTOMERS IF FLD2 # "Bob]" FLD2

and get

0001          JimBo's Stores

              MaryEllens Stores

0002          Gramma's Stores
</QUOTE>
----

=== At 21 AUG 2003 01:57PM Richard Hunt wrote:  ===

<QUOTE>Given your select statement of...

LIST CUSTOMERS IF FLD2 # "Bob]" FLD2



use...



LIST CUSTOMERS LIMIT FLD2 # "Bob]" FLD2

</QUOTE>

----

=== At 21 AUG 2003 01:57PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Your request

--------------------------------

LIST CUSTOMERS FLD2

Output 

0001 Bob's Stores

JimBo's Stores

MaryEllens Stores

0002 Bob's Stores

Gramma's Stores



I would like to 

LIST CUSTOMERS IF FLD2 # "Bob]" FLD2

and get

0001 JimBo's Stores

MaryEllens Stores

0002 Gramma's Stores

-------------------------------------

LIST CUSTOMERS WITH FLD2 # "Bob]"

LIMIT FLD2 NOT "Bob]"

FLD 2



This handles the Multivalued issue.



HTH



Don M.

</QUOTE>

----

=== At 21 AUG 2003 02:01PM Don Miller wrote:  ===

<QUOTE>Richard ..

It works better if you use the WITH clause in conjunction with the LIMIT clause.  Otherwise, you'll get a lot of unwanted empty items.

LIST CUSTOMERS WITH FLD2 # "Bob]" 

.. and then the LIMIT statement

LIMIT FLD2 NOT "Bob]"

FLD2



Don M.

</QUOTE>

----

=== At 21 AUG 2003 02:09PM b cameron wrote:  ===

<QUOTE>That was what I was looking for, thank you both very much!!

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=77F8A184B08CB33C85256D8900612724|View this thread on the  forum...]]