I have to configure a publisher task with simple reduce using the following condition:
(FIELD1 IN ('01,'02','10','11') OR (FIELD1 = '30' AND FIELD2 = '01'))
How can I achieve it ?
Many thanks in advance.
Why dont you put in a where statment?
because I have several users with different where conditions to apply.
I'm thinking to create one task for each user.
Ok, can you create a bookmark with these selections? And then use simple reduce with bookmarks.
Yes but how I can ?
I don't know how is possible using something like OR condition...
Ok, But will it not give you the same result even if you select Field1=01,02,10,11 or Field1=30 and Field2=01?
I'll try to be more clear...
Ex. FIELD1 = COMPANY
FIELD2 = COUNTRY
I need to select for the COMPANY = 01-02-10-11 all country while for the COMPANY= 30 only the country = 01
The results are of course different...but I need the UNION of both selections
But if you reduce the field country with 01 you will only get 01 no matter what. You can not both reduce and keep.
finally the only way is to create 2 tasks for that user, one using COMPANY = 01,02,10,11 that will create the document_1.qvw and the other task using COMPANY = 03 and COUNTRY = 01 that will create the document_2.qvw
Is this right ?
That seams to be the only way, in any case in my qv-world.
Retrieving data ...