Advanced query in Job control

[Joon]

I am trying to pick and provision to target depending on the account name.

Can you please give me an advice to make this work? 

select at.taskkey in (select a.taskkey
from Arstasks a, Accounts aa
where a.accountkey=aa.accountkey and aa.name like '%-1'
and aa.endpointkey='1581')

[naveenss]

Hi @Joon,

Please see the sample Query below. Make the necessary modifications as per your requirement.

and at.taskkey in (select at1.taskkey from arstasks at1,accounts aa,endpoints ed where at1.accountkey=aa.accountkey and at1.endpoint=ed.endpointkey and aa.name like 'abc.%' and ed.endpointname='ABC' and at1.status=1)

Let me know if this helps!

[AmitM]

HI @Joon , Job control advance queries are SQL and not HQL. You need to use :

and at.taskkey in (select a.taskkey from arstasks a, accounts aa where a.accountkey=aa.accountkey and aa.name like '%-1' and aa.endpointkey='1581')

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.

[rushikeshvartak]

Its straight forward query

and at.accountname like '%-1' and at.endpoint=1581