Organize & sort favorites fields in query.

I like that I can mark (most) fields as Favorites in query, however, once you start to get a healthy list of fields that you use regularly (or are so difficult to find/dig down to), it loses some of its appeal because those fields can't be sorted. I found, on accident, that if you right-click and choose "organize fields" and then add a field in that window, your favorites fields will now be alphabetized...which helps, other than the fact that Volunteer Type is under "T" for type rather than "V" for volunteer. It would be great to also have the option that the favorites fields sort by the same groupings that they would be under in the regular list...i.e. all Volunteer fields grouped together, etc.

With the idea to work faster and not spend lots of time finding fields every time, I often use a template query...one that has a lot of fields already selected, field names already changed to be shorter/more useful, etc. Then I Save As and start removing fields I don't actually need in that particular instance.

  • Guest
  • Feb 26 2014
  • Attach files
  • Sharon Buysse commented
    May 03, 2018 20:56

    Jennifer, thank you for the hints.  I had to read your idea a little closer to realize you actually had a solution to my problem.  Also I didn't realize you could rename query results columns, so thank you for that tip too.  I'm new to RE, and really like the query template idea.

  • Sharon Buysse commented
    May 03, 2018 20:42

    I can't believe this idea hasn't been implemented.  when you go to organize your favorites they show up in alphabetical order....but not in the query grid.