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

Pinned topic ClearQuest Team Api create temporary query

‏2013-05-03T11:11:19Z | api clearquest team
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
    287 Posts

    Re: ClearQuest Team Api create temporary query

    ‏2013-05-06T02:13:52Z  

    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

    Re: ClearQuest Team Api create temporary query

    ‏2013-05-06T08:08:18Z  
    • DonaldN
    • ‏2013-05-06T02:13:52Z

    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.

    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

    Re: ClearQuest Team Api create temporary query

    ‏2013-05-07T11:34:28Z  

    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?

     

     

    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

    Re: ClearQuest Team Api create temporary query

    ‏2013-05-09T14:52:53Z  

    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

     

    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

    Re: ClearQuest Team Api create temporary query

    ‏2013-05-10T03:47:49Z  

     

    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.

    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

    Re: ClearQuest Team Api create temporary query

    ‏2013-05-14T07:48:31Z  

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

    Pavel

     

    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