Using Related Table Columns In Generated Column Expressions

Data Service
1

Good day, may I ask for addition of a feature to use columns in a related table when writing a generated column expression: eg.
(relatedTableColumn.columnName * markupPercentage) + relatedTableColumn.columnName

I’m writing to ask for addition of a feature to use columns in a related table when writing a generated column expression: eg.
(relatedTableColumn.columnName * markupPercentage) + relatedTableColumn.columnName

2

Hello @Admire_Mhlaba

You can not use relations in GeneratedColumns.
I can propose you considering to use DataView Introducing Backendless Database View Designer | Backendless

Regards, Vlad

3

Good Day all,

Would just like to enquire if there is any thought in ever allowing a generated column to be calculated off relations.

Kind Regards,
Raymond

4

Hi @Raymond_Woodley ,

There are no plans for such feature since database itself supports only generated columns based on record for which value is generated.

If you need to generate values for columns basing on data from related tables you can use CloudCode event handlers Overview - Developing Backendless Server Code with node.js or consider usage of views.

Regards, Andriy