Publisher Simple Reduce using "OR" operator

[agigliotti]

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

[stabben23]

Hi,

Why dont you put in a where statment?

//Staffan

[agigliotti]

because I have several users with different where conditions to apply.

I'm thinking to create one task for each user.

[stabben23]

Ok, can you create a bookmark with these selections? And then use simple reduce with bookmarks.

//Staffan

[agigliotti]

Yes but how I can ?

I don't know how is possible using something like OR condition...

[stabben23]

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?

[agigliotti]

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

[stabben23]

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

[agigliotti]

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

[stabben23]

That seams to be the only way, in any case in my qv-world.

//Staffan