Filter Data Based on Signed in User

Question

Hello, I am building an application using Experience Builder. It's a simple one, featuring just a map widget and a table that displays information. I need to filter the data source based on the signed-in user due to the sensitivity of the information. Is there a way to implement this in Experience Builder?

DanJiang · Answer

@Map12 I see. I'm afraid the Chart widget only allows one data source for each chart widget. You will need to configure two charts (one with layer a and one with layer b) in this case, and one will be broken if the logged in user does not have permission.

Map12 · Answer

Hi @DanJiang I understand that should work for a Map widget in Experience Builder, but does that workaround apply to any other widgets (i.e. Table or Charts)?

I'm currently (Enterprise 11.3) not able to set multiple data sources, LayerA and LayerB, for a Chart widget.

Would all widgets have to have a consolidated data source (A+B data) and be filtered by the map? I think then I would have to allow permissions on the consolidated data source and defeat the purpose.

DanJiang · Answer

Hi @qzontario ,

I am afraid that we don't support filter data records in one data source based on the signed-in users. However, if you have different data sources for different users, for example, layer A shared with user1 and layer B shared with user2, when user1 logins to the app, data in layer A will show and data in layer B will not. When Experience builder app loads resources, it will respect the sharing scope for each item. Hopefully this could be a workaround for your case.

Dan