5 Replies Latest reply on Jul 2, 2016 8:27 AM by ffigueiredo

    Sort summary data

    ffigueiredo

      Hi, I would like to get data in a portal summary field sorted by date of items.

      All I can get is the records summarized according to the order they have been added in the portal.

      Does anyone have an idea how to sort these results? (by ID, alphabetical order of any of records fields,...)

       

      Thanks in advance!!!

       

      Filipe

        • 1. Re: Sort summary data
          JeremyYeap

          Just double-click the portal and open the sort portal option. Then select which field you want the portal record to sort by. Hope this is helpful to you.

          • 2. Re: Sort summary data
            bigtom

            The other thing you can do is set the base sort on the relationship in the graph by double clicking the relationship box. This usually provides a faster sort than doing it in the portal. After the base sort is set you can also change the sort in the portal as suggested.

            • 3. Re: Sort summary data
              ffigueiredo

              Thank you both Jeremy and bigtom.

               

              I tried first suggestion and is ok except for one issue, that is...

              When I sort for other field other than ID, I get the same ID for all portal records, even if the hyperlinks are running correctly.

              Can you figure out what is going wrong with that?

               

              Then, I tried to set the base sort as bigtom sad, but I couldn't found where to manage it. Could you please, explain me the path.

               

              Thanks for your help!

               

              FF

              • 4. Re: Sort summary data
                bigtom

                I have no idea about your ID because I do not know how you are setting the ID.

                 

                In the relationship graph there is a small box between the tables. Usually with an "=" in the middle. Double click that and you will see the option to set the sort on the portal table.

                • 5. Re: Sort summary data
                  ffigueiredo

                  Thank you very much!

                  It worked!

                  1 of 1 people found this helpful