querybuilder - phoenix need help
Budget: $10 – $30 USD
Hi all,
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.*, job.name as job_name from (select u.*, s.name as sport_name from users as u left join sport as s on (s.id=u.sportid) where userid in (1,2)) as c left join job as job on (c.jobid=job.id)
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 have problem in javascript uploading as seen in picture down
I want someone to help me in fixing this.
Thank you
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.*, job.name as job_name from (select u.*, s.name as sport_name from users as u left join sport as s on (s.id=u.sportid) where userid in (1,2)) as c left join job as job on (c.jobid=job.id)
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 have problem in javascript uploading as seen in picture down
I want someone to help me in fixing this.
Thank you