BusinessObjects Board

Run jobs with different query transformations conditions.

dataservices job design
#1

Hi

I have one table with the following values.

EmpID Fname Lname Product

123 Kerry dine cedar
435 john henry manu
456 david lorry inddes

I just mentioned only 3 records. But in real table, there are 80 records.

I have two separate jobs. What i need to do is i need to run these two jobs with different quey conditions each time.

ie. When i run first job first time, query conditions will be ‘where EmpID = 123’. When i run second job first time, query condition will be ‘where Product = cedar’.

Is there anyway that i can load all these table values into array type and get these values in the Query transformation one by one?.

Is there any way that i can call these two jobs one by one with different query transformation?. I think you understand my problem.

veparala (BOB member since 2008-02-18)

Push-down SQL functionality examples
#2

The most direct approach would be pushdown_sql() in the where clause - don’t like it. What about

where (EmpID = 123 and $var = 1) or (Product = ‘cedar’ and $var=2)

?

I hope the database optimizer will figure out that if the first part reads

(EmpID = 123 and 2 = 1)

the expression evaluates to false always and skips that part.

Werner Daehn :de: (BOB member since 2004-12-17)

#3

Can you please send me any examples which uses push-down functionality?

But ultimately i need to start this process only once. That means once i start the process, these two jobs will get the values one by one from table and exceute it.

Thanks

veparala (BOB member since 2008-02-18)

#4

Werner Daehn :de: (BOB member since 2004-12-17)