It seems if the criteria separator already exists in the criteria, WiTango
doesn't loose it. When I have had to create a new search with selections
needing to be grouped, after saving the file, I use WordPad to insert the
separator manually outside of WiTango and it stays there.
I insert the following wherever needed.
<CriteriaItem>
<Conjunction>or </Conjunction>
</CriteriaItem>
A bit of a hassle but it works.
-----Original Message-----
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 12:52 PM
To: '[EMAIL PROTECTED]'
Subject: Witango-Talk: Criteria Separator
All, I'm having a problem that I thought I knew the answer to but now it
seems what I "knew" is not working. My environment is Windows 2000, Witango
5 and SQL.
I have a number of selections in a search. For example,
Selection Set 1
and Selection Set 2
and Selection Set 3
and Selection Set 4
and
Selection Set 5
or Selection Set 6
I thought that by right clicking inside of the search Criteria and
dragging a criteria separator where I needed it would allow me to accomplish
the above. It looks good when I drag it but when I close the search object
and reopen it the and on the line by itself goes away and all criteria are
set to ands.
I need the query built as above where all of the first 4 are true and
either of the last two are true. What Witango seems to be giving me is:
Selection Set 1
and Selection Set 2
and Selection Set 3
and Selection Set 4
and Selection Set 5
or Selection Set 6
which is not the same logic at all.
Am I missing something? Shouldn't I be able to do this without using a
direct DBMS action?
Thanks for your help!
Sincerely,
Gene Wolf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
