I am accessing a SharePoint list were
Table 1 has the following columns – ResID, firstName, lastName, manager
Table 2 has the following columns – ResID, Role
Since it is not a SQL backend I did the Show Items with no Data
When I do this Any row that has no role does not display the manager even when the data is there on Table 1.
(does not show up but in the backend it has a value)
Has anyone faced this issue and can someone help resolve?