Need help in getting the SQL Query in FSM

[former_member1187769]

Need to pass the Activity ID and get the Service call details in FSM .

Please help me writing a generic query which i can use it . Thanks

[Yanik_Kurzawski · Accepted solution]

Hello Venka Sai Veda Prakash Meka,

do you want to use the query in the query API? If yes, this query might help you.

(SELECT s, a.id FROM ServiceCall s JOIN Activity a ON a.object.objectId = s.id WHERE a.id = 'insert here own activity id';)

Kind Regards
Yanik