Need to get Parameter list for Live Link Report

LorenP

I am using CWS (DocumentManagement.svc) to access RunReport. I can specify reportId and hardcode the parameters/DataValue.

Is there a way to access Parameter list dynamically using CWS C# code (SOAP)? I want to get a list of all parameters and parameter type that are associated to this report (I do not want to hardcode parameter name and value type for each report).

If there is no service or a method exists, then can I create a live link report that lists all Parameters and parent report id? Is there a table I can query?

Thank you In advance!

appuGmail

Perhaps OT programmers can give you the correct code but the ExtendedData of a LiveReport Type Node contains the parameters

I tested this code . My LR had One input called inputLabel1. My code for the LR was select ExtendedData from DTree  where DataID=%1

Is there a table I can query?   Perhaps... 

---the meat and potatoes of that.------

            ReportResult lrReportResult;

            CWS.StringValue dummy = new StringValue();

            dummy.Values = new string[] { "88553" }; this will in turn be executed as select ExtendedData from DTree  where DataID=88553

            CWS.DataValue[] inputs = new DataValue[] { dummy };

            lrReportResult = docManClient.RunReport(ref otAuth, DOCUMENT_ID, inputs);

            //OK at this point this is rather unparseable to a typical CWS programmer as the ExtendedData is an Assoc

            foreach (RowValue row in lrReportResult.Contents)

            {

                Console.Write(row.Key + ")");

                foreach (DataValue column in row.Values)

                {

                    Console.Write("\t" + column.Key + " = ");

                    if (column is IntegerValue)

                    {

                        IntegerValue value = (IntegerValue)column;

                        if (value.Values != null && value.Values.Length > 0)

                        {

                            Console.Write(value.Values[0]);

                        }

                    }

                    else if (column is StringValue)

                    {

                        StringValue value = (StringValue)column;

                        if (value.Values != null && value.Values.Length > 0)

                        {

                            Console.Write(value.Values[0]);

                        }

                    }

                    else if (column is DateValue)

                    {

                        DateValue value = (DateValue)column;

                        if (value.Values != null && value.Values.Length > 0)

                        {

                            Console.Write(value.Values[0]);

                        }

                    }

                    Console.WriteLine();

                }

                Console.WriteLine();

            }

 

You might have to take the String returned and do some parsing after converting them into a DataValue of sorts....

Ciao,

..... appnair appunair( Livelink Rocks  )

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937 

On Wed, Jan 2, 2019 at 12:51 PM eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Need to get Parameter list for Live Link Report

Posted byloren.e.pettijohn.civ@mail.mil (Pettijohn, Loren)On 01/02/2019 01:45 PM

I am using CWS (DocumentManagement.svc) to access RunReport. I can specify reportId and hardcode the parameters/DataValue.Is there a way to access Parameter list dynamically using CWS C# code (SOAP)? I want to get a list of all parameters and parameter type that are associated to this report (I do not want to hardcode parameter name and value type for each report).If there is no service or a method exists, then can I create a live link report that lists all Parameters and parent report id? Is there a table I can query?Thank you In advance!

---

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