Select statement in Reporter Query (None Specified) [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.
{{tag>category:"None Specified" author:"Paxton Scott" author:"Stephen Revelation"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Select statement in Reporter Query (None Specified) ====
=== At 23 JUN 1999 11:42:47AM Paxton Scott wrote: ===
 
 
<QUOTE>
I'd like to use this:

(WITH PART_OF=MASTER" AND COMPOSED_OF=') OR WITH PART_OF NE 'MASTER'

The only problem is the test button puts another WITH in front, making and invalid statemant.



I tried:

WITH PART_OF NE 'MASTER' OR (WITH PART-OF=MASTER" AND COMPOSED_OF=') 

 and several other variations but no joy....what is the secret?

arcs@arcscustomsoftware.com


[url=http://www.arcscustomsoftware.com/]ARCS, Inc.


[img]http://www.arcscustomsoftware.com/arcslogo.gif[/img]

</QUOTE>
----

=== At 24 JUN 1999 09:11AM Stephen Revelation wrote:  ===

<QUOTE>Paxton,



If you just skip the WITH statement, it'll put it in there automatically, so just type: 



PART_OF NE 'MASTER' OR (WITH PART-OF=MASTER" AND COMPOSED_OF=') 



and it should change to:



WITH PART_OF NE 'MASTER' OR (WITH PART-OF=MASTER" AND COMPOSED_OF=') when you test/compile it.







-Stephen Revelation

                   

</QUOTE>

----

=== At 28 JUN 1999 12:12PM Paxton Scott wrote:  ===

<QUOTE>Hi Setphen:

        Well, it SHOULD but it DOES NOT it says "(WITH is an invalid dictionary item...."

If I put a space between ( and WITH, 

It says: "invalid words. (AND EQ)...."



Other Ideas?   Thanks, arcs@arcscustomsoftware.com


[url=http://www.arcscustomsoftware.com/]ARCS, Inc.


[img]http://www.arcscustomsoftware.com/arcslogo.gif[/img]


</QUOTE>

----

=== At 28 JUN 1999 03:58PM Stephen Revelation wrote:  ===

<QUOTE>Paxton,





Apparently, and I'm assuming that this is your selection criteria query, parentheses are not valid in your statement.  I've tried using them in a similar fashion in RLIST and in my query and received the same sorts of errors. However, the logic or OR before the AND seems to have the same effect in this particular two-way logic scenario so that if you have:



PART_OF NE 'MASTER' OR WITH PART-OF EQ "MASTER" AND COMPOSED_OF EQ '' 



and then click TEST, the WITH will precede the PART-OF at the beginning and the intended logic should prevail.  I tested it here on one of my examples and all works fine. 



-Stephen Revelation

</QUOTE>

----

=== At 28 JUN 1999 04:28PM Paxton Scott wrote:  ===

<QUOTE>Thanks,Stephen

I played around some more in AREV and found my syntax error.



The following will work in OI query.  As you suggested, start with the part of the statement that does not need the ().

WITH PART_OF NE "MASTER" OR ( WITH PART_OF=MASTER' AND WITH COMPOSED_OF=')

works!

I apologize for taking your time, with my simple syntax error.



-Paxton

</QUOTE>


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