[SOLVED] Failed to parse query: Syntax error at position 13 in 'data/make/en-US asc'


#1

I have…

  • [ x] Checked the logs and have provided uploaded a log file and provided a link because I found something suspicious there.

Nothing is showing up in the logs.

I’m submitting a…

  • [ ] Regression (a behavior that stopped working in a new release)
  • [x ] Bug report
  • [ ] Performance issue
  • [ ] Documentation issue or request

Current behavior

I click on a <th> to sort the column for a schema and I get an error:

Failed to parse query: Syntax error at position 13 in 'data/make/en-US asc'.

Query: $orderby=data/make/en-US asc

I’ve seen this with a couple of my schemas.

Expected behavior

The column should sort by ASC or DESC without spitting out an error.

Minimal reproduction of the problem

Click on a column to sort that column

Environment

  • [x ] Self hosted with docker
  • [ ] Self hosted with IIS
  • [ ] Self hosted with other version
  • [ ] Cloud version

Version: Deleted all my squidex and mongo images on my machine and ran docker-compose again to download the latest ones from Docker Hub. So I have the latest Squidex build.

Browser:

  • [x ] Chrome (desktop)
  • [ ] Chrome (Android)
  • [ ] Chrome (iOS)
  • [ ] Firefox
  • [ ] Safari (desktop)
  • [ ] Safari (iOS)
  • [ ] IE
  • [ ] Edge

Others:

The “Updated” column for every Schema is always sortable. $orderby=lastModified desc

Tested: $orderby=data/make/en_US asc and this seems to work. So I guess it’s a bug in how Squidex forms the query using the UI.


#2

I think the problem is that “-” is not allowed in odata and the column must replace it with underscore “_”


#3

Okay. Is it fixable?


#4

Of course, just a string.Replace :wink:


#5

Sorry, for the delay. It is fixed in the dev tag.


#6

Yep saw it was fixed the other day. Thanks!


#7

It is finally deployed.


#8