Thanks moon but this way all users need to have write permissions to run the report and every time a user runs the reports with his name all other instances are updated with this users data.
I am trying to find a way for a user to filter his own data without affecting other users viewing the report at the same time. On Sun, Jul 24, 2016 at 11:15 AM, moon soo Lee <m...@apache.org> wrote: > How about something like > > %spark > val userName = z.getInterpreterContext.getAuthenticationInfo.getUser > z.show(sqlContext.sql(s"""select * from data where user="${userName}" """)) > > Thanks, > moon > > On Sun, Jul 24, 2016 at 3:25 PM Panayotis Trapatsas < > p.trapat...@pamediakopes.gr> wrote: > >> Does the angular way work even if the user has read-only permissions? Is >> there a way to do this without giving the user write permissions to >> notebook? >> >> On Sat, Jul 23, 2016 at 3:02 AM, Corneau Damien <cornead...@gmail.com> >> wrote: >> >>> Hi, >>> >>> Maybe Dynamic Forms ( >>> https://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/manual/dynamicform.html) >>> could help in this case? >>> It allows you to add some conditioning in your queries. >>> In this case, the user would be able to select themselves and rerun the >>> query. >>> >>> If you want to do it on a whole Notebook level, then binding values >>> could be another way ( >>> https://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/displaysystem/back-end-angular.html >>> ) >>> >>> On Sat, Jul 23, 2016 at 1:58 AM, Panayotis Trapatsas < >>> p.trapat...@pamediakopes.gr> wrote: >>> >>>> Hi, >>>> >>>> I know I can get current user with >>>> 'z.getInterpreterContext.getAuthenticationInfo.getUser' but is there a way >>>> to filter query results by the username of the current user? >>>> >>>> E.g. there are different salesman and each one wants to log in to >>>> Zeppelin and see only his own sales. >>>> >>>> -- >>>> >>>> [image: e-Travel SA] <http://pamediakopes.gr/> >>>> >>>> Panayotis Trapatsas / Lead Data Engineer >>>> p.trapat...@pamediakopes.gr / +30 6979493921 >>>> >>>> e-Travel SA >>>> Office: +30 213 0184000/ Fax: +30 211 8001181 >>>> Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece >>>> pamediakopes.gr | trip.ru | airtickets24.com | fantasticgreece.com >>>> >>>> [image: Google +] <https://plus.google.com/u/0/+PanayotisTrapatsas>[image: >>>> Stack Overflow] <http://stackoverflow.com/users/2618541/panayotis> >>>> >>> >>> >> >> >> -- >> >> [image: e-Travel SA] <http://pamediakopes.gr/> >> >> Panayotis Trapatsas / Lead Data Engineer >> p.trapat...@pamediakopes.gr / +30 6979493921 >> >> e-Travel SA >> Office: +30 213 0184000/ Fax: +30 211 8001181 >> Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece >> pamediakopes.gr | trip.ru | airtickets24.com | fantasticgreece.com >> >> [image: Google +] <https://plus.google.com/u/0/+PanayotisTrapatsas>[image: >> Stack Overflow] <http://stackoverflow.com/users/2618541/panayotis> >> > -- [image: e-Travel SA] <http://pamediakopes.gr/> Panayotis Trapatsas / Lead Data Engineer p.trapat...@pamediakopes.gr / +30 6979493921 e-Travel SA Office: +30 213 0184000/ Fax: +30 211 8001181 Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece pamediakopes.gr | trip.ru | airtickets24.com | fantasticgreece.com [image: Google +] <https://plus.google.com/u/0/+PanayotisTrapatsas>[image: Stack Overflow] <http://stackoverflow.com/users/2618541/panayotis>