I would take this approach: http://www.sqlteam.com/article/more-trees-hierarchies-in-sql
On Wed, Sep 21, 2011 at 7:23 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > I see the need for this. I need to think bout how to do it in a > backward compatible way and in a way that works on GAE without joins. > Please open a ticket about it. > > On Sep 20, 5:03 pm, António Ramos <ramstei...@gmail.com> wrote: > > * The Web2py security methods put Notes ACL to shame?* > > Can you explain why you think this way? > > > > how do i solve this problem in web2py? > > > > In a small organization (+- 100 users) it can be dificult to manage ACLs > > without being able to add group to group membership. > > > > consider my company > > > > we have this groups in the maintenance department > > > > MMC (20 users) > > ME ( 15 users) > > MI ( 10 users) > > > > MD (maintenance department) > > (all users above) > > > > so this group is composed of MMC,ME, MI and we dont repeat adding all > users > > to MD, we just add group MMC,ME,MI > > > > When we delete a person from ME, MD group automaticaly reflects the > change. > > > > In Lotus notes is very easy. > > *in web2py its impossible!* > > > > Also in web2py you have to decorate every function to allow certain users > or > > groups. In Lotus Notes if i say in my app acl that user A cannot access > it i > > dont even care that inside the app everything is free for everyone. User > A > > is blocked ! I dont have to repeat myself. > > > > 2011/9/20 Cliff <cjk...@gmail.com> > > > > > > > > > > > > > > > > > >>> web2py ... does not reach yet the Lotus Notes power of views, > ACLs, > > > formulas,calendar,etc > > > > > Not sure about that. It takes about as long to put a simple view > > > together in Web2py as in Notes. It would take a bit longer to do a > > > view with child records the first time around, but after that I don't > > > see a problem. > > > > > The Web2py security methods put Notes ACL to shame. True, it's not > > > baked in like Notes ACL but once you get the hang of it, setting up > > > authorizations for your app is pretty easy. > > > > > I'll agree on calendaring with one disclaimer: the Notes calendar > > > worked very well in the Notes client. Through a browser, not so > > > much. But my familiarity stopped with Notes v6, so maybe it's better > > > on the web now. > > > > > I'll also agree that LotusScript is blecherous. > > > > > The debugger, on the other hand, was very nice. > > > > > On Sep 20, 5:00 am, António Ramos <ramstei...@gmail.com> wrote: > > > > YESSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS > > > > > > i´m a lotus notes Developer, > > > > i have moved a lot of code to python and a few simple apps to web2py. > > > > I think xpages is way more dificult to jquery ui mobile with > web2py.So i > > > > decided to not learn xpages and go with web2py+jqueryui mobile. > > > > Also i like a lot web2py although it does not reach yet the Lotus > Notes > > > > power of views, ACLs, formulas,calendar,etc > > > > In the other side, i hate lotusscript. If Lotus Notes moved from > > > lotusscript > > > > to python .... > > > > > > Please see my workflow engine in Lotus Notes. > > > > I´d like to move it to web2py but i´m still a rookie in web2py so i > will > > > > need more time. > > > > > >http://www.youtube.com/watch?v=zMNwqAtiFOw > > > > > > Best regards > > > > António > > > > > > 2011/9/20 David Marko <dma...@tiscali.cz> > > > > > > > Are there any Lotus Notes developers using web2py? I'v been doing > Lotus > > > > > Notes development for more than 15 years and I also did two > projects > > > with > > > > > web2py recently. I really like web2py it makes me very productive, > > > comparing > > > > > to Java Server Faces based xPages in Lotus Notes, which are really, > > > really > > > > > slow to develop (to be honest I like java more, but web2py is > > > definitely > > > > > more productive in many areas). In Lotus Notes we have many smaller > or > > > > > bigger applications installed at our customers solving general > problems > > > like > > > > > CRM, document workflow, invoice approval process, projects, task > > > management > > > > > etc. I appreciate the web2py concept of one server running many > > > > > applications, SSO using CAS, its very similar to Lotus Notes > approach, > > > which > > > > > is great. > > > > > > > And now the point ... I'm thinking about creating some code > > > infrastracture > > > > > similar to LN, some general workflow engine and so and I thought > about > > > to > > > > > join forces with others maybe LN developers that have similar > > > requirements > > > > > as we have. Is there anyone interested in such thing? We discuss > here > > > or > > > > > privately ... >