AnsweredAssumed Answered

documentation on database joins of Live API Creator

Question asked by Ganesh Reddy on Apr 19, 2017
Latest reply on Apr 24, 2017 by Ganesh Reddy

I am trying to expose an api using my database whose current query looks like below. Would like to know how this can be achieved.

Select a,b,c,d,e,f,g
from abc
inner join def on abc.a=def.a and def.b=${dynamicvalue}
inner join ghi on def.c=def.d and def.e =${dynaicvalue}
inner join jkl on def.f=jkl.g
left outer join xyz on dyz.x=abc.a


Inner joins directly map to Resource and creating new Level of resources under it. 

1. How to i pass adyamicvalues to the api and use those in Join query.

2. How to i create a left outer join.