RE: [U2] Friday query logic {Unclassified}

[HENDERSON MIKE, MR]

Try WHEN not WITH 

LIST APOPEN WHEN(ACCTS UNLIKE 52... AND ACCTS UNLIKE 29...) etc


Regards


Mike


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathleeni M 
Hunter
Sent: Wednesday, 25 June 2008 12:23 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic

If this is not working, create a dictionary item that does the 
evaluation you want and have it return a 1 if it meet the condition and a 0 if 
it does not.

Dictionary would look like 

IF FIELD[1,2] # SF OR FIELD[1,2] # SH THEN 0 ELSE IF
CONVERT(SH,,CONVERT(SF,,OCONV(FIELD,MCA))) #  THEN 0 ELSE 1


Then you would be a select based on this dictionary be equal to a 1.


-Original Message-
From: Eric Armstrong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 1:17 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic

Bill,
Sorry for not responding sooner, but I agree with the comment below. It should 
work! So if it doesn't, we have to step back and start asking other questions.

Eric


-Original Message-
From: JPB-U2UG [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 11:24 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic


I take it that you checked to make sure that the fields were associated so 
let's take a different look. Are the values separated by value marks or 
sub-value marks? What does the dictionary contain? What does the record below 
look like in the editor?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Tuesday, June 24, 2008 12:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic

Eric:

That doesn't work either.

list APOPEN WITH ANY ACCTS UNLIKE 52... OR WITH ANY ACCTS UNLIKE 29...
INVDATE
COMMENT ACCTS AMTS
APOPEN INV-DATE DESCRIPTION ACCT. ACCT/AMTS

58*6-4 06-01-08 LOAN #123456, 06/2008   5230246.04
2910  1,025.50
2365 61.08
2980273.70
5230 50.00

I wouldn't have expected this to work anyway because every MV meets one or the 
other of the criteria.  The dicts ACCTS and AMTS are associated with each other.
I would
have expected the following to work though:

list APOPEN WITH ACCTS UNLIKE 52... AND WITH ACCTS UNLIKE 29... INVDATE 
COMMENT ACCTS AMTS APOPEN INV-DATE DESCRIPTION 
ACCT. ACCT/AMTS

58*6-4 06-01-08 LOAN #123456, 06/2008   5230246.04
2910  1,025.50
2365 61.08
2980273.70
5230 50.00

Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Friday query logic {unclassified}

[MACK ANDREW, MR]

Jeffrey,

I've found that WHEN, instead of WITH, is better at limiting the values
returned to a select.

i.e. SELECT FILE WHEN FIELD UNLIKE SF... OR WHEN FIELD UNLIKE SH...

Andrew


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera
Sent: Saturday, 21 June 2008 3:26 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic

I can't get my head around the proper query logic on this Friday.

I have a FILE with mv FIELD containing strings.  I want to query records
where at least one of the FIELD values doesn't begin with SF... or
SH

To be clear:  I don't want records if any of the following occurs:

FIELD = 'SF123'
FIELD = 'SH456'
FIELD = 'SF123':@VM:'SH456'

but I do want records if any of these occur:

FIELD='PQ789'
FIELD='SF123':@VM:'XY789'
FIELD='SF123':@VM:'SH456':@VM:'GH789'


I tried

SELECT FILE WITH FIELD UNLIKE SF...SH...
and
SELECT FILE WITH FIELD UNLIKE SF... AND FIELD UNLIKE SH...

but those include records where FIELD='SF123':@VM:'SH456'. 

Then I tried 

SELECT FILE WITH NO FIELD LIKE SF...SH...
and
SELECT FILE WITH NO FIELD LIKE SF... AND NO FIELD LIKE SH...

but that throws out records where FIELD='SF123':@VM:'SH456':@VM:'GH789'
which I need to keep.  I've tried some others variants using 'EVERY' but
to no avail.

So, I'm as a loss short of writing a I-descriptor.  Anyone have their
logic cap on today?


-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

Email gives the illusion of progress even when
   nothing is happening.  unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/