Feature Request: please enable local variables In records

Data related to the core record can be brought into context in one of 3 ways:

1. as mentioned by the other responses, you can use an Expression-back record at assemble the related data in the expression itself. This will work but will have a performance overhead as you're making two or more round-trips to the data source
2. you can make a 'VIEW' in the database, effectively bringing the data together in one place. Your record then is still entity-backed but is now referencing the VIEW rather than the original entity
3. Modern records all you to nest related data in the underling CDT which conceptually works much in the same way as a VIEW does.

Hi Stewart,

My request was not something to do with passing record source into sub rules/interfaces. For example we have user access related information in database which will allow/deny/readOnly access to certain related actions in those cases we would have to run the same query in all the related action context which uses it. We cannot use views here due to one to many relationship between tables. Also this is just one of the use case

Hi Stewart,

My request was not something to do with passing record source into sub rules/interfaces. For example we have user access related information in database which will allow/deny/readOnly access to certain related actions in those cases we would have to run the same query in all the related action context which uses it. We cannot use views here due to one to many relationship between tables. Also this is just one of the use case