AnsweredAssumed Answered

Stored Query Help

Question asked by ianprogrammer on Aug 2, 2016
Latest reply on Aug 3, 2016 by ianprogrammer

Hi team,

I need to do a stored query as below

 

category IN (

(SELECT t1.persid FROM prob_ctg T1

LEFT JOIN svc_contract T2 ON T1.owning_contract = T2.id

LEFT JOIN ca_contact T3 ON T3.contact_uuid = t2.svc_advocate

where T3.contact_uuid =  U\'1709A5379638414FB20C4B99A7094642\')

) AND type = \'I\' AND active = 1

AND tenant = U\'AC66D033FBE9714DB705FACF759746BA\'

 

it is possible to make?

 

Thanks.

Outcomes