Bug or User Error?????? I have 2 tables: Peo...

expressions
(Michael) #1

Bug or User Error???

I have 2 tables: People

  • (EmpID field is key, _ComputedName is the label) Crews

Some people are supervisors of crews. A supervisor’s ID (EmpID) is referenced from the Crews table.

All people belong to a crew. The Crew field is a reference to the Crews table.

I would like to show the person’s supervisor through a VC that references the Crew table and returns the crew’s supervisor - [Crew].[Supervisor]

This expression returns the expected results in the expression tester but, returns no results in the view.

I’ve written the expression two different ways with the same results: [Crew].[Supervisor]

and ANY(SELECT(Crews[Supervisor],[Crew]=[_THISROW].[Crew]))

In the expression tester, the correct [Supervisor] results are returned yet the view is blank. Is this a bug or a user error?

If anyone can take a look, the app id is GroupMgmt-285473.

(Aleksi Alkio) #2

Is this still an open issue?

(Michael) #3

@Aleksi_Alkio This seems to have been resolved. The expected results are now being returned. Thanks Aleksi.

(Aleksi Alkio) #4

Glad to hear the problem has been solved.