Expand my Community achievements bar.

Workspace logined user id ?

Avatar

Former Community Member

Hi,

How do i know workspace login user id in pdf form ?

I will populate items in dropdown list with workspace user id.

( ex. select from CourseTbl where userid = '< workspace logined user id >' )

Please, refer attachment files, too.

Thanks for your concerning...

7 Replies

Avatar

Level 3

Hi,

One approach in this case could be to get the user id (from AWS_ASSIGNED_ID value using Find User service) and then populate the value in dataXML before rendering the form.

Thanks

Avatar

Former Community Member

Thanks for reply.

How can i find  sample source file ?

I'm beginner of beginner for Livecycle ES. -_-;;

Help me, Please..

Avatar

Level 10

You need to modify the Default Render ES Update 1 process for this.

1. For safer side, leave this process untouched and create a copy of this process and edit.

2. In the process, there is a variable called assignedUserId which will hold the unique user id (not your network user name)

3. Use this value and take the network user name from MySQL (Use JDBC component)

Query :

SELECT uidstring FROM EDCPRINCIPALUSERENTITY WHERE refprincipalid = assignedUserId   (replace this variable with xpath)

now the uidstring is your network user name.

4. Use your query to populate the drop-down list now.

Nith

Avatar

Level 10

On #3, instead of using the JDBC service to query the Adobe database, you should use the Find User service from Foundation to get the user information back.

Jasmin

Avatar

Level 10

Many thanks for the information Jasmin.

I don't know how why did I miss this simple logic on all my applications

Thanks a lot.

Nith

Avatar

Former Community Member

$Nith$ and Jasmin

Thanks a lot.

I will try that ! ^^

Avatar

Former Community Member

hm...i can't that. help me... :-(

i am very very beginner to LiveCycle ES....

1. For safer side, leave this process untouched and create a copy of this process and edit.

>> In Processes tab, I selected "Default Render ES Update1" and copy that. ( "New Version" in Popup Menu )
 
2. In the process, there is a variable called assignedUserId which will hold the unique user id (not your network user name)

>> I found "assignedUserId" variable.

3. Use this value and take the network user name from MySQL (Use JDBC component)

Query : SELECT uidstring FROM EDCPRINCIPALUSERENTITY WHERE refprincipalid = assignedUserId  (replace this variable with xpath)

now the uidstring is your network user name.

### Jasmin says:

     instead of using the JDBC service to query the Adobe database, you should use the Find User service from Foundation to get

     the user information back.

>> In Services tab, I found Foundation > User Lookup - 1.0 > Find User service component.

      I dropped component in Process Design and defined new variables.

      - for saving Logined user id in workspace => strLoginUserId: string
      - for displaying strLoginUserId value => xfaTestForm: xfaForm ( pdf form or xdp form )

4. Use your query to populate the drop-down list now.

>> I met error...

i explained how do above steps through attached file (png files)

i need sample file...

thanks for your helping....