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 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Eric Armstrong Sent: Monday, June 23, 2008 12:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Friday query logic Bill, Try OR instead of AND. Eric -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2008 11:19 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Friday query logic Jeff: I could only get a single criteria to work... list APOPEN WHEN ANY ACCTS UNLIKE 52... INVDATE COMMENT ACCTS AMTS APOPEN INV-DATE DESCRIPTION ACCT. ACCT/AMTS 58*6-4 06-01-08 LOAN #123456, 06/2008 2910 1,025.50 2365 61.08 2980273.70 ...or... list APOPEN WHEN 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 2365 61.08 5230 50.00 ...but adding both criteria together with an AND/OR failed... list APOPEN WHEN ANY ACCTS UNLIKE 52... AND WHEN 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 ...using WITH instead of WHEN had no effect... list APOPEN WITH ANY ACCTS UNLIKE 52... AND 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 This is on UD v7.1.9 (Windows 2K3). Did I miss something? Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: Monday, June 23, 2008 10:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Friday query logic quote who='Eric Armstrong' date='Monday 23 June 2008' Jeff, In Universe there is a (apparently undocumented) keyword ANY which can be used, i.e. SELECT FILE WITH ANY FIELD UNLIKE SF... OR WITH ANY FIELD UNLIKE SH... which may be just what you want. Eric: You get the prize - I'm on Unidata but ANY works the same and it's exactly what I want. On your next hot day I owe you a cool beverage of your choice... -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re- disclosure) of confidential information without the written consent of the person(s
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 To unsubscribe please visit http://listserver.u2ug.org/
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 To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Friday query logic {Unclassified}
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
I was trying to do what the OP was trying, extract MVs that didn't meet the multiple criteria, negative though those may be. So, I tested for items where an MV account didn't start with 52 and 29. This worked. But I added a requirement to output just those MV accounts that didn't start with either 52 or 29. I couldn't get this to output properly because multiple limiting criteria didn't work but single criteria did. So... list APOPEN WHEN ANY ACCTS UNLIKE 52... INVDATE COMMENT ACCTS AMTS APOPEN INV-DATE DESCRIPTION ACCT. ACCT/AMTS 58*6-4 06-01-08 LOAN #123456, 06/2008 2910 1,025.50 2365 61.08 2980273.70 ...worked fine while... list APOPEN WHEN ANY ACCTS UNLIKE 52... AND WHEN 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 ...did not. However, when an item had a single valued ACCT, and that value started with either a 52 or a 29 it didn't show up so I know this aspect works fine. It's just then output of items with both in them that doesn't work. So I'd have expected the second list to output: list APOPEN WHEN ANY ACCTS UNLIKE 52... AND WHEN 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 2365 61.08 As always, thanks. Bill P.S. The dictionaries look like: 2 Dev (0)- AE DICT APOPEN ACCTS AMTS 1 Top of ACCTS in DICT APOPEN, 7 lines, 84 characters. *--: P 001: D The G/L acct#s associated with this invoice (controls field# 10) 002: 9 003: 004: ACCT 005: 5L 006: M 007: AS_9 Bottom. *--: EX Quit ACCTS in file DICT APOPEN unchanged. 2 Top of AMTS in DICT APOPEN, 7 lines, 118 characters. *--: P 001: D The amounts associated with each G/L acct# in ACCTS field. ACCTS and AMTS are related. 002: 10 003: MR2,M 004: ACCT/AMTS 005: 13R 006: M 007: AS_9 Bottom. *--: EX Quit AMTS in file DICT APOPEN unchanged. 2 Dev (0)- AE DICT APOPEN AS_9 Top of AS_9 in DICT APOPEN, 2 lines, 61 characters. *--: P 001: PH 002: ACCTS AMTS MVCHECKNO MVPDDATE MVVNAME MV_CHECKNO MV_PDDATE Bottom. 3 Intel (0)- AE APOPEN 58*6-4 Top of 58*6-4 in APOPEN, 17 lines, 144 characters. *--: P 001: 9505 002: 14757 003: 14763 004: 43*100 005: LOAN #123456, 06/2008 006: 165632 007: 0 008: 165632 009: 523022910223652298025230 010: 2460421025502610822737025000 011: 200806 012: 200805 013: 014: 015: AUTO 016: 017: 43 Bottom. Anyway...it's always something. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of JPB-U2UG 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
Re: [U2] Friday query logic
quote who='Eric Armstrong' date='Monday 23 June 2008' Jeff, In Universe there is a (apparently undocumented) keyword ANY which can be used, i.e. SELECT FILE WITH ANY FIELD UNLIKE SF... OR WITH ANY FIELD UNLIKE SH... which may be just what you want. Eric: You get the prize - I'm on Unidata but ANY works the same and it's exactly what I want. On your next hot day I owe you a cool beverage of your choice... -- 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/
RE: [U2] Friday query logic
Jeff: I could only get a single criteria to work... list APOPEN WHEN ANY ACCTS UNLIKE 52... INVDATE COMMENT ACCTS AMTS APOPEN INV-DATE DESCRIPTION ACCT. ACCT/AMTS 58*6-4 06-01-08 LOAN #123456, 06/2008 2910 1,025.50 2365 61.08 2980273.70 ...or... list APOPEN WHEN 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 2365 61.08 5230 50.00 ...but adding both criteria together with an AND/OR failed... list APOPEN WHEN ANY ACCTS UNLIKE 52... AND WHEN 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 ...using WITH instead of WHEN had no effect... list APOPEN WITH ANY ACCTS UNLIKE 52... AND 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 This is on UD v7.1.9 (Windows 2K3). Did I miss something? Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: Monday, June 23, 2008 10:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Friday query logic quote who='Eric Armstrong' date='Monday 23 June 2008' Jeff, In Universe there is a (apparently undocumented) keyword ANY which can be used, i.e. SELECT FILE WITH ANY FIELD UNLIKE SF... OR WITH ANY FIELD UNLIKE SH... which may be just what you want. Eric: You get the prize - I'm on Unidata but ANY works the same and it's exactly what I want. On your next hot day I owe you a cool beverage of your choice... -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Friday query logic
Can you do a SELECT to select the ones WITH EVERY FIELD LIKE SF... SH... and then do NSELECT to select the inverse set? - Original Message - From: Jeffrey Butera [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Friday query logic Date: Fri, 20 Jun 2008 11:25:30 -0400 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Friday query logic
I experimented with it and got much closer with: SELECT FILE WITH EVERY FIELD UNLIKE SF... AND WITH EVERY FIELD UNLIKE SH... It is not quite what you want but much closer. From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Friday query logic Date: Fri, 20 Jun 2008 11:25:30 -0400 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 im Talkathon starts 6/24/08. For now, give amongst yourselves. http://www.imtalkathon.com?source=TXT_EML_WLH_LearnMore_GiveAmongst --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Friday query logic {unclassified}
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/
RE: [U2] Friday query logic
Jeff SELECT DISTINCT @ID TO SLIST 0 FROM UNNEST FILENAME ON FIELD WHERE NOT(FIELD LIKE 'SF%' OR FIELD LIKE 'SH%') ; The SQL is less of an overhead than doing a by-exp with SAVING UNIQUE @ID in RetrieVe. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: 20 June 2008 16:26 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Friday query logic
Perhaps a UniBasic program would be workable. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeffrey Butera Sent: Friday, June 20, 2008 11:26 AM 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Friday query logic
I'm sure there's a much cleverer query-only way of doing this. But I'd just do a merge list. Select all the records into one list. Select into another all records WITH EVERY FIELD LIKE 'SF...''SH...' Then grab the difference. Katie Katie Morgan Datatel Programmer/Analyst Linfield College Integrated Technology Services 900 SE Baker St McMinnville, OR 97128-6894 [EMAIL PROTECTED] 503.883.2714 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: Friday, June 20, 2008 8:26 AM 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Friday query logic
I think you are on the right track with this one, but change the AND to OR. I wanted to include the EVERY keyword before each field but I think that is assumed. SELECT FILE WITH FIELD UNLIKE SF... AND FIELD UNLIKE SH... From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Friday query logic Date: Fri, 20 Jun 2008 11:25:30 -0400 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 im Talkathon starts 6/24/08. For now, give amongst yourselves. http://www.imtalkathon.com?source=TXT_EML_WLH_LearnMore_GiveAmongst --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Friday query logic
Use WHEN instead of WITH on MV fields? Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: Friday, June 20, 2008 8:26 AM 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Friday query logic
Why not write a new dictionary item? This can set a flag if FIELD is neither SF456 nor SH456. Let's call it VALID.FIELD I would use the following A-correlative A;IF N(FIELD) = SF456 THEN ELSE IF N(FIELD) = SH456 THEN ELSE 1 That would work at least in UniData - not sure if UV supports A-correlatives. In a V- or I-type dictionary you may have to use SUBR(OCONVS...), SUBR(IFS...) or EXTRACT because it is multi-valued (I am still not that familiar with the syntax with multivalued fields), but in principle that should do the trick. Then just SELECT FILE WITH VALID.FIELD No fancy SELECT, SQL or Basic program required Brutzman, Bill wrote: Perhaps a UniBasic program would be workable. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeffrey Butera Sent: Friday, June 20, 2008 11:26 AM 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? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/