LiveReport 'User' Input Type

Wui Hong Ang

With select * from dtree where userid=%1 and Param %1 as UserID I can get a list of items that the user is owner of. However, the Input Type must be "Number "(due to the UserID param).

I would like to know if it were possible to use the Input Type of "User" to get the same result as what I can with the above. Any suggestions?

Have tried Input: User and Param:User Input 1, but that doesn't help cause to get the list of owned items, I need to refer the ownerid or createdby which are both numbers.

I could do an inner join with KUAF if i knew exactly what the UserID input type grabs. Need some help.

Bhupinder_Singh

Please see a related response I made in this thread and let me know if it helps.

 

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=16639716&objAction=viewincontainer&ShowReplyEntry=16641254#forum_topic_16641254

 

- Bhupinder

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, June 18, 2012 2:15 AM
To: eLink Recipient
Subject: LiveReport 'User' Input Type

 

LiveReport 'User' Input Type

Posted by****@cochlear.com (Ang, Wui Hong) On 06-18-2012 02:11

 

With select * from dtree where userid=%1 and Param %1 as UserID I can get a list of items that the user is owner of. However, the Input Type must be "Number "(due to the UserID param). I would like to know if it were possible to use the Input Type of "User" to get the same result as what I can with the above. Any suggestions? Have tried Input: User and Param:User Input 1, but that doesn't help cause to get the list of owned items, I need to refer the ownerid or createdby which are both numbers. I could do an inner join with KUAF if i knew exactly what the UserID input type grabs. Need some help.

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center