*So what? You should future proof the app. Some day there might be extensions in India or something.*
Actually, the extensions are internal to the company, either phone numbers or mobile numbers, so your scenario won't ever apply. *Do you mean the extensions of the persons he supervises?* That is what he already does, which is what I don't want it to do. I'll give an example,so that you can visualize it better: Supervisor X has two extensions: 5589,5590 Supervisor X supervises two people: A and B A has two extensions: 4572,4573 B has one extension: 4321 My current query returns: 5589,5590,4572,4573,4321 What I want it to returns: 5589,5590 Conclusion: Just the Supervisor extensions quarta-feira, 16 de Setembro de 2015 às 18:15:53 UTC+1, Leonel Câmara escreveu: > > > I think in this case they won't be strings since I read the numbers from > a XML and they don't have the '+' character > > So what? You should future proof the app. Some day there might be > extensions in India or something. > > > Not all the supervisors.I want to get the extensions of a particular > supervisor > > Do you mean the extensions of the persons he supervises? If so: > > the_supervised = db(db.auth_user.Supervisor == > ParticularSupervisor.id)._select(db.auth_user.id) > extensions_of_the_supervised = > db(db.Extension.Person.belongs(the_supervised)).select() > > This will give you the extensions of everyone that is supervised by this > person. > > > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
