SQLITE_ERROR: no such column: priority.name

SAP-samples / fiori-elements-incident-management

This repository contains the sample OData V4 service material for the tutorials provided in the SAP Developer Center.

Apache License 2.0

31 stars 30 forks source link

SQLITE_ERROR: no such column: priority.name #4

Closed jcailan closed 3 years ago

jcailan commented 3 years ago

I'm getting an error:

SQLITE_ERROR: no such column: priority.name

I just did below:

Clone repo down to local VS Code
Switch branch to sampleSolution
Do npm install
Do cds watch
Open the Fiori App
Clicked Go button

sjvans commented 3 years ago

Hi @jcailan

We don't yet support query options with path expressions on SQLite, i.e., in your case $orderby:'priority/name'. It's on the roadmap for 2021. Also, we are currently working on a HANA vs. SQLite feature overview for future reference.

Best, Sebastian

ARiesterer commented 3 years ago

Hi @jcailan I have fixed this in the git repository, i.e. by again cloning the service and generating the application this error should not show up anymore when pressing the Go button within the application. Best Regards Andreas

jcailan commented 3 years ago

Thanks for your response @D051664 Andreas! I can see that you avoided the path expressions issue since it was not supported yet in SQLite.

https://github.com/SAP-samples/fiori-elements-incident-management/commit/0513e037492506d031401e613b581eff2f0b3bd4