topic Re: Implementing User Login & Filtering in ArcGIS Web AppBuilder Questions

Implementing User Login & Filtering

EncikPiee — Tue, 22 Aug 2017 01:17:38 GMT

Hi all,

I about to develop a multiple user login to my WAB, and currently have a user login database on my SQLServer. What is the best approach to support more than 100's users login to a WAB, and what is the approach that I can filter the data, by using a set of related tables?

For example:

Example related table layer:

1) Users = {(Username : James, GroupID : 25), .....}

2) CarIDGroup = {(CarID : 2217 , GroupID : 25) , (CarID : 112, GroupID : 1), .......}

3) CarLocation = {(CarID :2217, Lat:1.333, Lng : 101.221), .......}

So, let say, James log in, and he can only see the location of CarID in a group 25 only. Do WAB has a similar function that can support this filtering?

Thanks,

Shaffie

Re: Implementing User Login & Filtering

RobertScheitlin__GISP — Tue, 22 Aug 2017 03:02:58 GMT

Shaffie,

The way I handle if is to develop a .Net website that has login and security database (not really a GIS topic, so you just need to Google it "Creating an ASP.NET Web Site with Basic User Login"). and then I paste all the standard WAB site Index.html code into the Default.aspx and now you have a .Net controlled login for your site. Now the trying to control the layer filtering could be handled using a definition query on the layer based on the authenticated user. This stuff is way to specific and customized for any code sharing though, so all I can do is share these general workflow patterns.

Re: Implementing User Login & Filtering

EncikPiee — Tue, 22 Aug 2017 06:07:39 GMT

Great! General workflow is what I need as I'm confused what to do. Anyway, thanks for the brilliant idea Robert Scheitlin, GISP.