Hi,
I am getting errors while applying where clause in a views
{
"code": 1054,
"message": "Column 'related_user_objectId' does not exist in table 'BodyTypes'"
}
but this column exists in the view
I created this view months ago and it was working fine, suddenly why this error occurs?
And this error is happening not only in this view but also in other views.
I am attaching screenShots Please check.
Hello @Ayaz_Khan!
Currently queries in the View are case-sensitive for the relation column.
You need to use related_user_ObjectId instead of related_user_objectId.
We are already aware of this issue and will let you know as soon as it is resolved.
(Inner ticket BKNDLSS-27280)
Regards,
Alexander
Hi @Alexander_Pavelko ,
I also have suddenly issues when fetching data from a view from my server code. I’m selecting the userStatus field from the Users table by using the alias to_userStatus in my view. I’m getting the error Error: Unknown column 'userStatus' in 'where clause' although I’m selecting the view field to_userStatus from the view.
Is this related to the issue raised here? My app is currently broken …
Regards,
Hello @Klaas_Klever!
I think the cause is the same.
We apologize for the inconvenience, our developers are already working on fixing this problem.
I will let you know as soon as we fix it.
Regards,
Alexander
Hi @Alexander_Pavelko,
Today I am facing another error issue Please check
{
"code": 0,
"message": "Model Descriptor not found (/opt/backendless/repo/820fbb35-552c-f405-ffb9-b4d60982e100/files/servercode/JS/Poze__JS_default_coding1637155577995/PRODUCTION/model.json)",
"errorData": {}
}
it was working fine yesterday but suddenly occur today my app getting crashed.
Hello @Ayaz_Khan
The problem related to case-sensitive in the view is fixed. Can you check?
Is this problem still relevant? If yes, please provide your APP ID.
Regards,
Inna
Hi @Inna_Shkolnaya,
the issue is not resolved properly as I am facing another issue since last night in a view
with where-clause
when I am using this where clause
host_objectId = '12F1D6F3-AD7B-4703-B65A-863D162CE230' and finished = false And event_type = 'Hangout'
I received an empty response. and when I removed this " And event_type = ‘Hangout’ "
I get a proper response even “event_type = ‘Hangout’” is also present in the response object.
Please check
My APP ID = “820FBB35-552C-F405-FFB9-B4D60982E100”
myViewName = “AuctionsDetailView”
yeah sure, you can.
Thank you, I was able to reproduce your problem. Internal ticket BKNDLSS-27312 was created. We will let you know as soon as the problem is fixed. I apologize for the inconvenience.
Hello @Ayaz_Khan
We’ve just updated cloud servers with a fix for the issue you described above. Could you kindly let us know whether fix works for you well?
Regards,
Inna