11-28-2011 05:40 AM
Hello,
I am running EV8 SP4 and DA8 SP4. Analytics is not configured.
Is it possible to find all items in the archive where subject or content contain (cat or dog) and ball?
In SQL I would do the following:
SELECT *
FROM petshop p
WHERE (p.animal = 'cat' OR p.animal = 'dog')
AND p.toy = 'ball'
Is it possible to do this in DA?
Subject or Content: (cat or dog) and ball
Thank you!!
Solved! Go to Solution.
11-28-2011 03:37 PM
Yes, you can do that with DA, that is its purpose.
You have a couple options:
You can use the + sign and put the words on one line
or you can use the "Any of" in one box and put the other word in the second box. There is an "AND" between the two boxes.
11-28-2011 03:37 PM
Yes, you can do that with DA, that is its purpose.
You have a couple options:
You can use the + sign and put the words on one line
or you can use the "Any of" in one box and put the other word in the second box. There is an "AND" between the two boxes.
11-29-2011 07:30 AM