Support Topics Documentation Slack YouTube Blog

Query in codeless

in-progress

(Rohan P) #1

How can i write this type of query in codeless?
Select A.person_id,A.person_name,B.person_school_name from details.person_details A, details.school_details B, where A.person_id = B.person_id ;


(Sergey Kukurudzyak) #2

Backendless does not support such query with data connectors. But you can create mysql View and call it from backendless


(Rohan P) #3

Thank you, But created views are not visible


(Rohan P) #4

it says Table not found by name ‘Table not found by name ‘mysql.person_view’. Make sure the client class referenced in the API call has the same literal name as the table in Backendless console’ (1009)


(Sergey Kukurudzyak) #5

we will recheck this scenario


(Rohan P) #6

i created a new connection. now its coming


(Rohan P) #7

The Database changes wont get reflected to the backendless?


(Sergey Kukurudzyak) #8

whenever you change something in the db schema you have to reload data connector by pressing reload button in the backendless console http://take.ms/j1MAU


(Rohan P) #9

i reloaded it. but too the view which i created did not appear here


(Anton Govorushkin) #10

Hi @Rohan_P

We were able to reproduce the problem. Indeed refresh button’s not updating DB schema. For now there is a workaround you may use to update it. Open your browser console and click refresh button. A request called tables will be sent. Route looks like:
http://<serverUrl>/<appID>/console/dataconnectors/UID/tables. You’ll need to:

  1. Right click on the request -> Copy -> Copy as cURL
  2. Paste it to any tab in terminal (command line)
  3. Add query parameter ?forceRefresh=true to the URL so it looks like:
    http://<serverUrl>/<appID>/console/dataconnectors/UID/tables?forceRefresh=true
  4. Enter
  5. Click refresh button in Backendless console again. Your View will be there

I’ve scheduled a task to make a general fix for this issue, and will notify you when it’s fixed so you could update your installation. Task ID for tracking purposes is 17923

Anton


(Rohan P) #11

Thank you @anton-govorushkin