Hi Team,

Example:

Parent Topic

      -> Topic

            -> Solution

Below is a query report that I use today to obtain certain details re. the usage of our Solutions and I would like to add Parent Topic Name and whether the Solution is Private or Public. Is this possible?

SELECT solution.solutionid "Solutionid" , KB_Topics.TOPICNAME " Topic",Solution.TITLE "Subject ",Solution.DESCRIPTION "Contents",solutioninfo.noofhits "Views",Creator.FIRST_NAME "Created By",longtodate(SolutionInfo.CREATEDTIME) "Created Time",Updater.FIRST_NAME "Last Modified By",longtodate(SolutionInfo.LASTUPDATEDTIME) "Last Modified Time",

Sol_StatusDefinition.STATUSNAME "Status" FROM Solution

INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID

LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID

LEFT JOIN AaaUser Updater ON SolutionInfo.LASTUPDATEDBY=Updater.USER_ID

LEFT JOIN AaaUser Creator ON SolutionInfo.CREATEDBY=Creator.USER_ID

LEFT JOIN Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID

LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID