Collection Types - Filters (500 internal error)

[rrubio]

When performing a filter under "Collection Types" i get an internal error. Under headers i can see the right filter being used. The fields is of type Int:

Filter

Header

calendar-date?page=1&pageSize=10&_sort=recId:ASC&_where[0][calendarDay]=1

NOTE: querystring query works fine see examle below:

api/calendar-date?calendarDay=${calendarDay}

HTTP Response

{"statusCode":500,"error":"Internal Server Error","message":"An internal server error occurred"}

Header

UI Error message

[brettwillis]

Hi @rrubio , I'm pretty sure that this is due to #23. The complex query format with _where is not implemented yet. I see that the admin UI has now migrated to use the _where format which means that filters applied with the UI will result in this error until I implement it. I'll put it next on my list!

To be sure, there should be some Cloud Run error output for this one, could you check at https://console.cloud.google.com/logs?

But like you say, for this simple query, the simple format should still work in the meantime calendar-date?page=1&pageSize=10&_sort=recId:ASC&calendarDay=1.

[rrubio]

@brettwillis thank you man. I'll need to confirm logs on cloud run.

[brettwillis]

@rrubio I've implemented complex queries in version 3.0.0-alpha.28. Give it a try and please let me know how it goes.

[rrubio]

@brettwillis thank you. I'll be able to check this week and provide you with an update.