Hi everybody,
may someone help me with the query logic of the plugin data. I have already searched in the forum as well as with google. Unfortunately, without success.
However, I think the answer to my question might be quite simple for experts.
Let me explain my problem with the following example:
I want to display "property_1" and "property_2" for all entries of "class1" that have "property_3 = A" and ("property_4 = B" or "property_4 = C")
The following table shows the correct results:
---- datatable ----
cols : property_1, property_2
where: %class%= class1
and: property_3 = A
and: property_4 = B
or: %class%= class1
and: property_3 = A
and: property_5 = C
----
Regarding the table I have two questions:
a) Is there a more efficient way than including "%class%= class1" and "property_3 = A" twice in the query?
b) What are the rules when the query is excecuted? (left to right, right to left, "and" before "or" etc.)
If someone gives me good explanation I can add it to the manual page of the plugin.
Thanks a lot for your help.
Take care
Jan