9 Replies Latest reply: Jan 17, 2014 11:54 AM by 9ab3256b-d8ca-4a0a-9a9a-e37d01668fe6 RSS

    Drilldown chart to report - not filtering report value

    9ab3256b-d8ca-4a0a-9a9a-e37d01668fe6

      Hi, I created a bar chart for item type.  I would like to click the chart item and it bring me to the item report but filtered by item type.  Currently it clicks through but is not filtering by item type but pulls the whole report. 

       

      I'm following the general syntax:

      The URL syntax for a link is:

      f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly

       

      My specific link syntax is:

      select 'f?p=&APP_ID.:2:'||:app_session||':::::P2_hw_type_id:' link,

      ht.model label,

      COUNT(h.ID) value1

      from hw h, hw_type ht

      where h.hw_type_id=ht.id

      group by ht.model

       

      Where am I missing the operation to pass the clicked value into the report?

      TIA