Have you looked at common filters? http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=common+filter#Common-filters
-Jim On Tuesday, October 16, 2018 at 7:35:04 AM UTC-5, Rahul wrote: > > Hey Everyone, > Greetings! I have a question. I went through Auth documentation and > understood that we can add extra fields to the Auth tables. However, I > still want to be a little more clear to achieve below - I am currently > using three fields for a multi-tenant system like workspace, username and > password. Here workspace depicts where the user belongs to (see explanation > in Q1 below) I am currently using my own code to manage this stuff manually > (almost everything that auth does), now though I want to give Auth a try > and tailor it to fit my needs. I dont want to maintain that amount of code > and use the existing API. Can I get help on achieving that in the simplest > way. If it works, I would switch to using Auth > > * Q1]* How can we use Auth to add one more extra field for authentication > when I want a system to validate login based on three parameters like - > Validation needs to be done based on all three parameters specified. For > each application I can use 'n' number of unique workspaces and 'n' number > of users would belong to these workspaces. How to do this ? > > 1. *workspace *- An alpha numeric field that would store a unique name > denoting users belonging to a particular set (For example users working > in a specific location like los-angeles or washington) or an office > location like michigan, nevada or Zones like north, south .. sort-of etc. > ) > 2. *username *- Its available already > 3. *password *- Its available already > > > *Q2]* Which all tables need to be modified ? > > *Q3] *Any changes in any other code in any files ? > > I know I can clone my app multiple times and support multi-tenancy > however, if this can be achieved with Auth - that would be great. > > Regards, > > *Rahul * > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.