1 Reply Latest reply on Sep 30, 2016 5:16 PM by Brad Shuel

    Filter on category to get see all category of item

    joost Velthuis

      Hi all,

       

      I know the title of this discussion is very vageau.. so i am gonna try to explan..

      i have a database that has the titles of documents saved. These documents contains topics and the topics contains words.

      it is the spit out of the LDA algoritme.

       

      I want to make a dashboard that you can get other topics when u want filter on a topic.

      this is want i want: the user filters on topic 1. Topic  1 apears in several documents. These documents that contains more topics than topic 1.

      for example Document X has topic 1 but also topic 4,6,8. The thing is that when the user filters on topic 1 he also wants to see that de document contain topic 4,6,8.

      Can somebody help me with this,...

       

      Thanks!

       

      Joost

       

      p.s. when i write this with an subqeury in sql i can manage to get it.

       

      The subquery is like this:

       

      Select *

      from Topic T

      inner join Topic_Document WT

      on T.Topic_ID = WT.Topic_ID

      where T.Topic_ID In

        (Select Wt.Topic_ID

        from Topic T

        inner join Topic_Document WT

        on T.Topic_ID = WT.Topic_ID

        where Wt.Document_ID = 2)