Intelligent Intersection Search

[source1Tamer]

HI,,
I'm trying to translate a query from regular query type to Texis-Metamorph query using my special function:

The following one is Working by transformation:
'medtronic' and ('aed' or '"life pack"') and not 'aedes' and not '"st jude"'
---------------------------------------
After Transformation:
'+medtronic aed life pack -aedes -"st jude" @0'

cause I know what to output,, but what should be the output transformation of the following query:

('medtronic' or 'medtronic1' or 'medtronic2' or 'medtronic3') and ('soccer1' or 'soccer1' or 'soccer2' or 'soccer3')

[mark]

(medtronic,medtronic1,medtronic2,medtronic3) (soccer1,soccer1,soccer2,soccer3)

[source1Tamer]

Is there a way to interpret this in terms of "Keywords" and "@intersection" expressions?
ex,for :
('medtronic1' or 'medtronic2' or 'medtronic3' or 'medtronic4') and ('soccer1' or 'soccer2' or 'soccer3' or 'soccer4')

Would it be like this??:

@0 medtronic1 medtronic2 medtronic3 medtronic4 @1 @0 soccer1 soccer1 soccer soccer3

and the question might come to whither I could use the intersection expressions "@x" not only between words but also between expressions .

F.Y.I
I'm trying to get a generic formula to transform complex boolean queries with multiple "and" "or" and multiple expressions(containing other ORs and ANDs)
to simple Metamorph-Ready queries containing just keywords and "+" signs for mandatory words,"-" for excluded words, and "@x" for intersections between words and expressions as well.

[mark]

Intersects (@) apply to all non required and non excluded sets within the query. More than one @ in a query is undefined.

[source1Tamer]

so, could I use the "+" sign to make expressions required??
for ex:
(medtronic,medtronic1,medtronic2,medtronic3) (soccer1,soccer1,soccer2,soccer3)

Is it valid to say :
+(medtronic,medtronic1,medtronic2,medtronic3) + (soccer1,soccer1,soccer2,soccer3)

[mark]

Yes, you may use + and - on any set. It must be abutted to the set, no space:
+(medtronic,medtronic1,medtronic2,medtronic3) +(soccer1,soccer1,soccer2,soccer3)

[source1Tamer]

ooh Great!!! this covers up 80% of query types...
Another Request...
For the opposite query:
('medtronic' and 'medtronic1' and 'medtronic2' and 'medtronic3') OR ('soccer1' and 'soccer1' and 'soccer2' and 'soccer3')

would it be like this???:
(medtronic medtronic1 medtronic2 medtronic3)
(soccer1 soccer2 soccer3 or soccer4) @0

Is that right?

[mark]

No, your guess is the same as
"medtronic medtronic1 medtronic2 medtronic3" "soccer1 soccer2 soccer3 or soccer4" @0

Your query looks like 2 distinct queries to me. 2 SQL's or a SQL OR of LIKE's.