Is there any way to change de id name of the table
Something like “idCars”
Hello!
I’ll give you a response soon. So sorry for the wait.
Lada Kokotova | Technical Support Engineer
Hello!
You can’t change the id name, but you can create a virtual field, which will refer to id:
You can read more here:
https://docs.8base.com/docs/8base-console/platform-tools/data-builder/#calculated-fields
Also, you can use aliases. Aliases get used to returning objects having different names than their field names.
For example:
You can read more here:
https://docs.8base.com/docs/8base-console/graphql-api/
Lada Kokotova | Technical Support Engineer
why i can’t use the relational field “vehicleID” as a value, it says "
Column with ‘vehicleid’ name doesn’t exist"
You cant use relations in expression (you can use only current table columns), it’s a limitation of the SQL engine.
You can read more about generated columns here:
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Lada Kokotova | Technical SUpport Engineer