Customer Portal

Get Involved. Join the Conversation.

Topic

    Richard Keevil
    Using Grid widget to display discussionsAnswered
    Topic posted July 21, 2016 by Richard KeevilGold Trophy: 10,000+ Points 
    180 Views, 3 Comments
    Title:
    Using Grid widget to display discussions
    Content:

    The Grid/multiline widgets seems to be the way to output the results of a report. 

    I have written a report to display all Discussions and use grid/resultinfo/paginator to allow a means to display it and page through the results.

    176 is the report that's referenced in all widget descriptions but is geared towards handling Answers.  Using this report, I am able to filter the grid based on a 'p' URL parameter and want to emulate this for Discussions.

    I cant see a way to get a discussion based report to act in the same way. I cant see anything obvious in the report settings to define this behaviour, but I have seen that the filters of 176 use things such as answers.search_cpx, search, nl, search, fnl, search_ex etc. I don't seem to be able to use what I see in 176 to duplicate the product URL filtering in my new report.

    Using my same block of code and just changing the reportID with a URL parameter to show a specific product, Answers works ans expected but Discussion just shows everything.

    Is this possible with Discussions, am I just being blind/uneducated?

     

    Version:
    16.2
    Code Snippet:

    Best Comment

    Richard Keevil

    Bingo!

    So I had to join the Products table to Discussion (ss_questions.prod_id = products.id) and add a filter to products.prod_hierarchy [in list] = All items and ensure that "Make this filter selectable at run time".

    Now my Grid/Multiline filters my report on the 'p' URL parameter!

    Comment

     

    • Richard Keevil

      Bingo!

      So I had to join the Products table to Discussion (ss_questions.prod_id = products.id) and add a filter to products.prod_hierarchy [in list] = All items and ensure that "Make this filter selectable at run time".

      Now my Grid/Multiline filters my report on the 'p' URL parameter!

    • Erica (Leep) Anderson

      Thanks for taking the time to mark a best answer and share what solved your question, Richard. We appreciate it, especially how it creates valuable content to help other members who have the same question (particularly around Community Self Service as that is a newer area of the product!) and tells other members know this thread has been solved.

      Best,
      Erica, Community Manager

    • Sophie Campbell

      Thanks for sharing your findings, Richard!