search

o1lab / xmysql

xmysql is now https://github.com/nocodb/nocodb
https://github.com/nocodb/nocodb
MIT License
174 stars 55 forks source link

Problem with XJOIN #24

Open paxpelus opened 5 years ago

paxpelus commented 5 years ago

I am using the xmysql docker image. The API is generated just fine and many of the SELECT work fine. I am trying to use XJOIN by doing this query

api/xjoin?_join=pl.instruments,_j,pr.exchanges&_on1=(pl.exchange,eq,pr.id)

and I am getting an error

{ "error": "Internal server error : whereInQueryParams.split is not a function" }

If I try calling

api/xjoin?_join=pl.instruments,_j,pr.exchanges&_on1=(pl.exchange,eq,pr.id)&_fields=pl.id,pr.id

I am getting the following error

{ "error": "Internal server error : req.query._fields.split is not a function" }

Any idea what is going on?