The first article A[0]=>a, B[0]=>b, C[0]=>c, A[1]=>d, B[1]=>e, C[1]=>f
Hi to all
Next time about GroupX. The following situation:
1) Content Type with A, B, C fields
2) GroupX with this content type
3) Following values of this GroupX in two articles:
The first article A[0]=>a, B[0]=>b, C[0]=>c, A[1]=>d, B[1]=>e, C[1]=>f
The second article A[0]=>g, B[0]=>h, C[0]=>c, A[1]=>a, B[1]=>i, C[1]=>j
I need a seach with following conditions: A[i]=a
AND C[i]=c. IN ONE SUBFIELD.
I have made searches with GroupX many time but only with one value. Now I can get such condition:
((t1.groupx REGEXP "(::A\\|[0-9]+\\|groupx::)1(::/A\\|[0-9]+\\|groupx::)")) AND t1.groupx REGEXP "(::C\\|[0-9]+\\|groupx::)619(::/C\\|[0-9]+\\|groupx::)" <br>
But it means that the both Articles have these conditions, because there is not defined group number ([0-9]+). And I need only first Article which have these conditions in one group.
How can I sove this problem?
Thanks in advance.