We can access the user settings column directly by bracket notation (e.g [my setting]) in another table but if it's a reference, we cannot directly read its member. Wouldn't be an expected behavior?

A column in user settings can be read by

  • [my setting]
  • USERSETTINGS(“my setting”)

in another table.

If [my setting] is reference, I cannot read like [my setting].[id].
Note that there is no name conflict. I don’t have any column with named “my setting” in the current table.

Is it a bug?

0 15 613
15 REPLIES 15
Top Labels in this Space