Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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.
Best Regards
Andrea
Hi,
Why dont you put in a where statment?
//Staffan
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.
//Staffan
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.
//Staffan
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 ?
AG
That seams to be the only way, in any case in my qv-world.
//Staffan