Good Day all,
Just want to ask if I am missing something obvious, as always your help would be appreciated
I am trying to populate a dropdown with items that are specific to the user. (Truck Registration)
In the image below the table contains a property called customer, we have vehicles related to customers.
Here is the logic I have used on page entry
with a custom function to get Customer
with the data binding to the option logic.
not sure what I have missed.
But thank you in advance.
Kind Regards,
Raymond
Hello @Raymond_Woodley
Does the logic you have constructed work for you?
Regards,
Inna
Hi @Inna_Shkolnaya,
Thank you for your response, no it’s not retrieving anything at the moment.
from the pics there are two vehicles available but neither are reflected by any users.
Regards,
Raymond
Yes, I can see the problem. Unfortunately, your whereClause for the table is wrong. Your whereClause should pass the following data owner.objectId='objectId'
I think the following should help you. In the get Customer function, you need to return objectId. Monosnap
Monosnap
Regards,
Inna
Hi @Inna_Shkolnaya,
No Joy yet
As always your help is appreciated.
Regards,
Raymond
I recommend that you read the following article.
https://support.backendless.com/docs?topic=14176
Also, you have Label and Value capitalized and should be in small letters.
Regards,
Inna
Hi @Inna_Shkolnaya
My problem was not related to anything related in the article, the problem I have discovered is due to the values I require in the Owner column are a relation to another table, thus not a string. How can I structure the where clause to convert the relation data to a string, because I am certain then my problem will be resolved.
Kind Regards,
Raymond
Hi @Raymond_Woodley,
is there any chance that there is no value in the Company variable? Have you tried to print it in logs (using the print block)?
Also, you can check what data you retrieve from the table by putting the result in the variable first and then printing it too.
Could you please let us know your results?
Regards,
Stanislaw
Hi @stanislaw.grin
I have simplified things for now to try find the issue. I am not retrieving anything from the owner column in the vehicles table, but can receive string from any other column for instance make.
is there a syntax that i must use to reference the relation(which is a link) converting it to string.
Kind Regards,
Raymond
Yeah, in the Load Table object block you can see the relations input. Put there a create list with Owner (just like you did it for the sort by field, but with the Owner value inside).
Keep in mind that full user object in the Owner property will be returned
Thank you will give it a go
