4 Replies Latest reply on Dec 28, 2013 2:56 PM by philmodjunk

    Portal Filter

    hwachai

      Title

      Portal Filter

      Post

           I have a table list view with weeks and days

      WEEK 1.................. WEEK 2..................WEEK 3..................WEEK 4..................WEEK 5..................WEEK 6..................

           Sunday   ........... ....Sunday   ........... ....Sunday   ........... ....Sunday   ........... ....Sunday   ........... ....Sunday   ........... ....

           Monday ...................Monday ...................Monday ...................Monday ...................Monday ...................Monday ...................

           Tuesday ..................Tuesday ..................Tuesday ..................Tuesday ..................Tuesday ..................Tuesday ..................

           Wednesday ...........Wednesday ...........Wednesday ...........Wednesday ...........Wednesday ...........Wednesday ...........

           Thursday ...............Thursday ...............Thursday ...............Thursday ...............Thursday ...............Thursday ...............

            

           Each day have their own portal view from same tables same records, i call it "Dance Class", but filtered by date +1 or -1.

            

      Sunday -- Dance Class l  5hours l Kenny

            ------------ Aerobics Class l  1 hours  l  Miss Lee

           ------------- Street Dance Class l 1 hour  l  John

           ------------- Class C l 2 hours l Albert

           ------------- Funny Class l 2 hours l Tee

            

      Monday -- Aerobics Class l  2 hours  l  Miss Lee

           --------------Dance Class l  5hours l Kenny

           -------------- Street Dance Class l 1 hour  l  John

            

      Tuesday -- Street Dance Class l 1 hour  l  John

            -------------- Aerobics Class l  1 hours  l  Miss Lee

           --------------- Class C l 2 hours l Albert

           --------------- Funny Class l 2 hours l Tee

            

           Now i need to perform find "Street Dance Class" or another filter to change the table only display "Street Dance Class l 1 hour  l  John"

           On the same table list will only show this Result : -

      Sunday -- Street Dance Class l 1 hour  l  John

            

      Monday -- Street Dance Class l 1 hour  l  John

            

      Tuesday -- Street Dance Class l 1 hour  l  John

            

           Yea, my question is how to start? .. Can I make a trigger script that ADD in another layer of portal filter?  Or perform search on portal? .... Need some input so I can have a direction to go.

            

           Thanks ^^

           hwachai

        • 1. Re: Portal Filter
          philmodjunk

               What is the actual structure of tables and relationships. In your first example with Week 1 through Week 6. Is each row a different record? Is each column a portal or are they fields in the same record?

          • 2. Re: Portal Filter
            hwachai

                 all the "result" showing on each row if filtered by portal filter, they are from same table (records)

                 My Dance Class table

                 12/12/2013 ---- Kumah ---- Street Dance ---- 3 hours ----- In Time --- Out Time ---- Phone Number ---- 15 student

                 -------------------- Lily-- ----  XXXX Dance ---- 2 hours ----- In Time --- Out Time ---- Phone Number ---- 12 student

                 -------------------- Jason------  YYY Dance ---- 2 hours ----- In Time --- Out Time ---- Phone Number ---- 12 student

                 -------------------- Bell-- ----  XEE Dance ---- 2 hours ----- In Time --- Out Time ---- Phone Number ---- 12 student

                 13/12/2013 ---- Kumah ---- Street Dance ---- 3 hours ----- In Time --- Out Time ---- Phone Number ---- 15 student

                 14/12/2013 ---- Kumah ---- Street Dance ---- 3 hours ----- In Time --- Out Time ---- Phone Number ---- 15 student

                  

                 In my so call "simple calendar" table, every column and row have individual portal  filtered by date. So its only show the event base on the date.

                 My question, am i possible add another filter on the existing portal using trigger script?

                 My current temp solution is duplicate multiple calendars with different filter (sort by date and class), look messy. .. too many class....

                  

            • 3. Re: Portal Filter
              hwachai

                   Actually is pretty easy, but i need to refresh the portal ....

              Weeks::Filter user = "All"
                    or
                   Weeks::Filter user = Dance Class::Name
                   and
                   DayOfWeek ( Job Sheet::Date ) = 1

                   Now need a proper script to trigger the refresh portal

              • 4. Re: Portal Filter
                philmodjunk

                     This did not answer my question. I was asking about this part of your post:

                WEEK 1.................. WEEK 2..................WEEK 3..................WEEK 4..................WEEK 5..................WEEK 6..................

                     Sunday   ........... ....Sunday   ........... ....Sunday   ........... ....Sunday   ........... ....Sunday   ........... ....Sunday   ........... ....

                     Monday ...................Monday ...................Monday ...................Monday ...................Monday ...................Monday ...................

                     Tuesday ..................Tuesday ..................Tuesday ..................Tuesday ..................Tuesday ..................Tuesday ..................

                     Wednesday ...........Wednesday ...........Wednesday ...........Wednesday ...........Wednesday ...........Wednesday ...........

                     Thursday ...............Thursday ...............Thursday ...............Thursday ...............Thursday ...............Thursday ...............

                     And any time that you have portals, you have to have relationships between at least two table occurrences. What are the relationships that you are using for your portals? This last part can be key to getting a filtered portal to update while avoiding unnecessary delays.

                     Refresh WIndow [Flush Cached Join Results] Will refresh your portal, but this can also result in major delays while waiting for the entire window to update in some situations so it is an option best avoided and there are ways to avoid that option that may not require any scripting at all.