Topic
2 replies Latest Post - ‏2006-12-12T17:06:17Z by SystemAdmin
SystemAdmin
SystemAdmin
1189 Posts
ACCEPTED ANSWER

Pinned topic Project Console - Template Builder Help

‏2006-12-12T02:30:33Z |
Hi,

I'm trying to pull some data from ClearQuest for a report. My record type is Change Request.

It prompts me to give values for:

1. DatabaseSet
2. DatabaseLogicalName
3. Record_Type
4. Id

I am not sure what is the 4th one, Id? Any idea what is the value to be given for this?

I queried the Change Request table and took one value of Id and gave for the field. It worked fine and displayed report with just that Change Request. I need to know what would be the generic Id to be given to pull all the records at a time.

Appreciate if anyone can help with this!
Updated on 2006-12-12T17:06:17Z at 2006-12-12T17:06:17Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1189 Posts
    ACCEPTED ANSWER

    Re:Project Console - Template Builder Help

    ‏2006-12-12T03:26:05Z  in response to SystemAdmin
    You'll want to set it up a little differently.

    What you've done is gone all the way down to a specific record within
    ClearQuest.

    You might be better served if you set your OPEN to either the ClearQuest
    Database or to a ClearQuest Query.

    Please look at how the out-of-the-box templates have been set up. You can
    get a description of these templates and how they relate to each other
    from the ProjectConsole Additional information node - there is a template
    description file (sorry I don't remember the exact name) in this node.

    Cheers,

    Debra

    Debra Johnson
    PPM Marketing Engineer
    Rational software
    IBM Software Group
    Boulder, CO
    Telephone: 303-558-3301
    Cell: 303-775-9168
    debrajoh@us.ibm.com

    dw-ratdisc-admin/Raleigh/IBM@IBMUS
    Sent by: pjc-bounces@lists.ca.ibm.com
    12/11/2006 07:30 PM
    Please respond to
    pjc@lists.ca.ibm.com
    To
    pjc@lists.ca.ibm.com
    cc

    Subject
    pjc Project Console - Template Builder Help
    Hi,

    I'm trying to pull some data from ClearQuest for a report. My record type
    is Change Request.

    It prompts me to give values for:

    1. DatabaseSet
    2. DatabaseLogicalName
    3. Record_Type
    4. Id

    I am not sure what is the 4th one, Id? Any idea what is the value to be
    given for this?

    I queried the Change Request table and took one value of Id and gave for
    the field. It worked fine and displayed report with just that Change
    Request. I need to know what would be the generic Id to be given to pull
    all the records at a time.

    Appreciate if anyone can help with this!
    _______________________________________________
    pjc mailing list
    pjc@lists.ca.ibm.com
    Unsubscribe: pjc-leave@lists.ca.ibm.com

    _______________________________________________
    pjc mailing list
    pjc@lists.ca.ibm.com
    Unsubscribe: pjc-leave@lists.ca.ibm.com
    • SystemAdmin
      SystemAdmin
      1189 Posts
      ACCEPTED ANSWER

      Re: Re:Project Console - Template Builder Help

      ‏2006-12-12T17:06:17Z  in response to SystemAdmin
      Thanks for the Reply Debra.

      I looked at the template description file, but it does not tell what value to be given for the "Record ID" field to get all the Change Request records to be displayed in the report.

      Thanks,
      -Rajiv