3 Replies Latest reply on Jun 27, 2017 8:10 AM by MarkBanin

    Portal Sorting question


      Is there any difference or best practice as to whether you specify a sort order under "Portal setup" or whether it's done via the relationships window?

        • 1. Re: Portal Sorting question

          There's a difference.


          As for best practice, I only sort on the relationship when I absolutely want that data to be sorted a specific way ALL the time. Otherwise it's getting sorted for no reason at all whenever I'm NOT using the sorted state.


          So, portal sorting takes the performance hit ONLY when the data is loaded for that portal, but nowhere else. If you sort on the relationship, anywhere that related data is used takes a performance hit from being sorted first.

          1 of 1 people found this helpful
          • 2. Re: Portal Sorting question

            the sorting via the relationship will reflect on functions where you are pulling related data from the related table and want to preserve the order. So if you want to jump to a specific row by a key value of the sorted portal only the relationship sorting will give you consistent results.

            • 3. Re: Portal Sorting question

              Thanks guys, that makes total sense