Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Order Search Results

    Posted 12/11/19 05:25 AM
    Hi,

    I was discussing the parallel thread about reporting on inventory and my colleague suggested to use the search API. So I started digging a bit and it seems quite useful. I can create a list of items by type and control which fields are returned.

    But I can not order. I can not see a UI option for that, but I also can find if there is an option in the REST call.

    This will give 10 random reports from the store, including the creationTime:
    /bi/v1/search/cm?fields=creationTime,defaultName,selfUrl,hidden,type,disabled,id,defaultScreenTip&results=10&query=&hide_internal=all&filter=type%7Creport

    I tried to add:
    &sortOrder=creationTime

    and: order, orderBy, myOrder, yourOrder, anythingOrderly

    None of them sorts the results. Does anyone know if there is such a parameter?

    (btw, if you want to test this in your browser, you have to switch off XSRF checking, else you get a Forbidden message)

    ------------------------------
    Reinier Battenberg
    https://github.com/CognosExt
    ------------------------------

    #CognosAnalyticswithWatson