Topic
6 replies Latest Post - ‏2013-05-14T07:48:31Z by FabrizioDutra
FabrizioDutra
FabrizioDutra
4 Posts
ACCEPTED ANSWER

Pinned topic ClearQuest Team Api create temporary query

‏2013-05-03T11:11:19Z |
Hello, 
 
I would like to use the Java Team API as substitute of the Perl scripts that we actually we use. 
 
Principally I would like to use the CM Server  to made the operations without direct connection to ClearQuest database. 
 
After various tries, I find that the example's provider use the cqjni.jar and needs  a local configuration of ClearQuest :it not accesses the CMserver.
 
Can you indicate what is the correct provider to access the CM server?.
 
Another problem that I have is relate to create a temporary Query. 
The only way to create a temporary query in the Team API it is registered this in the User Personal Folder and than remove it. That operation loses a lot of time and it is not practical.
 

It is not possible made a query, as in Perl, that is not registered at a folder and only exist during the operation?  

  • DonaldN
    DonaldN
    204 Posts
    ACCEPTED ANSWER

    Re: ClearQuest Team Api create temporary query

    ‏2013-05-06T02:13:52Z  in response to FabrizioDutra

    The only supported provider is the local/native provider, unfortunately, as you have found out.

    If you want to utilize the CM Server, you should consider the OSLC API.

    • FabrizioDutra
      FabrizioDutra
      4 Posts
      ACCEPTED ANSWER

      Re: ClearQuest Team Api create temporary query

      ‏2013-05-06T08:08:18Z  in response to DonaldN

      The problem is that the OSCL API  has the same problem that cannot use temporary queries.

      Using the local provider how I can create a temporary query, a query not registred,  or this can be do only with the Perl Api?

       

       

      • pdubovitsky
        pdubovitsky
        376 Posts
        ACCEPTED ANSWER

        Re: ClearQuest Team Api create temporary query

        ‏2013-05-07T11:34:28Z  in response to FabrizioDutra

        The following link might be useful
        https://jazz.net/wiki/bin/view/Main/CqOslcV2#Query_Capabilities

        OSLC where statement is missing some of the regular queries capabilities (for instance, "not" operation), but it is possible to find a workaround in most cases.

        Pavel

        • FabrizioDutra
          FabrizioDutra
          4 Posts
          ACCEPTED ANSWER

          Re: ClearQuest Team Api create temporary query

          ‏2013-05-09T14:52:53Z  in response to pdubovitsky

           

          The problem is related with the performance.
           
          I need to do recursively generate lot  of queries to made a report.
           
          In perl it is not a problem, but with  OSCL and CM API is necesary an existing query at user folder.
          Create that query, and remove it, produce a performance lost.
          Because of that I 'm asking  if exist a way to do a query without create it on a folder.
          • pdubovitsky
            pdubovitsky
            376 Posts
            ACCEPTED ANSWER

            Re: ClearQuest Team Api create temporary query

            ‏2013-05-10T03:47:49Z  in response to FabrizioDutra

            With OSLC you can create a "temporary" query. I am not sure why do you think that some "user folder" query is required.

            Pavel

            • FabrizioDutra
              FabrizioDutra
              4 Posts
              ACCEPTED ANSWER

              Re: ClearQuest Team Api create temporary query

              ‏2013-05-14T07:48:31Z  in response to pdubovitsky

               

              I have confused it  with the REST API, sorry.
               
              On other hand the actual perl script use BuildSQLQuery, because of performance issue. In OSCL this is not posible, right?
               
              Anyway I'll try the OSCL.
               
              Thanks for the answer