-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Monday, June 30, 2003 12:23 PMTo: eLink RecipientSubject: Reporting on Livelink Polls Reporting on Livelink Polls Posted by HPcaUser2 (Beppu, mark Q) on 06/30/2003 01:11 PM In LL 9.1 polls are a nice feature, but can any one help me with trying to extract the information into a live report? Have been looking at the Dtree and the LLpolling tables. Any help would be great thanks.
We have also writtena similar report for polls that gives who has voted and the name of the poll.
As far as we can tell the polls are designedto be blind and we cannot find any poll data except the general summary.
The table LLPolling does not hold any dataexcept the comment number (we have not yet found where the comments are held)and the general summary of votes against the poll id
-----OriginalMessage-----From: eLink Discussion: LivelinkLiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 02 July 2003 21:43To: eLink RecipientSubject: RE Reporting on LivelinkPolls - who voted
RE Reporting on Livelink Polls - who voted
Posted by MLindsay (Lindsay, Marie) on 07/02/2003 04:42 PM
In reply to: Reporting on Livelink Polls
Posted by HPcaUser2 (Beppu, mark Q) on 06/30/2003 01:11 PM
Message from Marie Lindsay <marie@opentext.com> via eLink
I wrote a LiveReport to tell me what users voted in a poll. (It's not really possible to tell how they voted, as far as I can tell.) I haven't explored the schema enough to see more than this.
select lastname, firstname from kuaf where id in (select userid from llpolling where id = %1 and userid not in (0, -1) )
Inputs: Type - Number
Prompt - Poll ID
Param %1: User Input 1
-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Monday, June 30, 2003 12:23 PMTo: eLink RecipientSubject: Reporting on Livelink Polls
Reporting on Livelink Polls
In LL 9.1 polls are a nice feature, but can any one help me with trying to extract the information into a live report? Have been looking at the Dtree and the LLpolling tables. Any help would be great thanks.
