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/
[U2] RE: UV 10.2.7 change in behaviour for XML
Brian The generated XML did include both nodes as shown in my example. using 10.1 gives ROOT REF.CODES_XML TABLE_GENDER TABLE_GENDER_VA-MV/ ... etc using 10.2.7 gives only one of the nodes ROOT REF.CODES_XML TABLE_GENDER_VA-MV/ ... etc I would have been happy to lose the REF.CODES_XML node but not the node defining the item within the file. Have we found a bug where the wrong one has been eliminated. Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/