Select on dynamic table, column "**" is ambiguous

2018-07-25 Thread Dylan Heitz
I need help to find how to solve this issue. I created a class extending AbstractQueryableTable which implements TranslatableTable and CustomColumnResolvingTable. I managed to perform query by specifying the fields like : String query = "select name,ID,My_Metadata:field FROM Document WHERE

Bindable Baz.bind(DataContext) issue

2018-08-09 Thread Dylan Heitz
Hello, I'm trying to convert my SQL query in JSON query so elasticsearch can find what I look for. This is what I have : query = "select * FROM user WHERE name='john' LIMIT 10" It must be serialized in JSON for querying in elasticsearch like this : "query": { "bool": { "must": {

Re: Bindable Baz.bind(DataContext) issue

2018-08-09 Thread Dylan Heitz
Thank you Vladimir and Andrei, Well I thought that the query wasn't executed correctly since it gave me no results but I just found out this was another issue... So this is working fine even with an array of terms for filters. But it can be useful later to know where this is done :) Thanks