I am trying to do some work using phoenix and querybuilder but I am facing some difficulties, I need someone who is familiar with these to help me to fix these issue :)
- I want to write nasty query in query builder like this
select c.*, [login to view URL] as job_name from (select u.*, [login to view URL] as sport_name from users as u left join sport as s on (s.id=[login to view URL]) where userid in (1,2)) as c left join job as job on (c.jobid=[login to view URL])
this query only as demo ... just to know how structure
- I don't want to use DB::table() command but instead I want to use queryFactory->newQuery()
- in Phoenix migration I face this error
Index method "SPATIAL" is not allowed as seen in attachment
I want someone to help me in fixing this.