Hitachi Vantara Pentaho Community Forums
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 31

Thread: Session variable of user name?

  1. #1

    Default Session variable of user name?

    Hi everyone

    Is there a variable I can use it in SQL 'where' clause in a XACTION file? I mean that the variable will be initiated by Pentaho when the user login portal, and I can use the variable directly in XACTION where clause looks like '{name}'?

    Thanks a lot, any reply will be appretiated!

    David

  2. #2
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Session variable of user name?

    Have you looked at the sample solution action sequences?

    I suggest using grep (or another like tool) for <user

  3. #3

    Default Re:Session variable of user name?

    Hi Marc

    Thanks for your suggestion, but unforturnately, i can not find from xaction files from below:

    headcount_actual_by_region.xaction. headcount_variance_by_region.xaction etc.

    Am I on a wrong way of understanding? Where I can get the user name who have logged in and use it in the SQL sections of these xaction files?

    Please help me more, I have been held for several days!

    David

  4. #4
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Session variable of user name?

    Please see:

    samples/rules/session-region-list.xaction
    test/rules/script_rule2.xaction

  5. #5

    Default Re:Session variable of user name?

    Hi Marc

    I appreticated your prompt reply and followed the direction you flaged. I did

    1. Open headcount_variance_by_region.xaction, and add a INPUT item name is user as below


    name



    2. Edited the SQL statement in ![CDATA[ section as below
    where user_name='{user}'

    3. Login portal server as admin and refresh the portlet, but

    Nothing happen?!

    Well, I do know why it did not work when I used same path from your sample?

    Sounds like I need further help from you!

    David

  6. #6
    Join Date
    Feb 2006
    Posts
    27

    Default Re:Session variable of user name?

    Ok, if I understand this the following code...
    Code:
    <inputs>
    	<user type="string">
    		<sources>
    			<session>name</session> 
    		</sources>
    	</user>
    </inputs>
    will grab the user name from the session information. Cna you do the same for hte password as a means of a single sign on solution?

    Post edited by: jfizer, at: 05/04/2006 18:10

    Post edited by: jfizer, at: 05/04/2006 18:12

  7. #7
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Session variable of user name?

    Please zip up your action sequence and attach it for us to review when we get a chance.

  8. #8

    Default Re:Session variable of user name?

    Thanks Marc

    Please review the attachment. Thanks for your help!

    David http://forums.pentaho.org/archived_a..._by_region.zip

  9. #9

    Default Re:Session variable of user name?

    Hi Marc

    I guess I ingored a important section in my zip file. I should add not only in

  10. #10

    Default Re:Session variable of user name?

    Hi Marc, here is the new zip file. Thanks!

    David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.