Would be great to have the same fields that are already available in REPORTS be available in QUERIES.

For example, I can make a report displaying the Account Name and the SORT NAME, but I can't make a query that finds constituents with BUSINESS NAME FORMATS where the ACCOUNT NAME is not the same as the SORT NAME. I could really use this for data cleanup, but I can't because there is no field in a query for a SORT NAME. :-(

  • Guest
  • Feb 17 2016
  • Already Works That Way.
Reports/Queries
  • Attach files
  • Guest commented
    March 08, 2017 19:23

    There are quite a few fields that you can report on that you can't query on.  Examples:  Country Code, Creation Date, Creation Time, Email (First Address), Household Relationship, Last Modified By, Last Modified Date, Last Modified time   etc.  Please make the query fields and the report fields the same.  Thank you.

    Attachments Open full size
  • Guest commented
    February 22, 2016 20:50

    not all fields that are available in reports are available in queries.  They should be the same.

    Attachments Open full size
  • Mike Rusche commented
    February 22, 2016 20:47

    There is a field in query called Name Formats.  From there you can choose Business and find those accounts with a Business Name Format.  (It is under The Account area of query)

    Attachments Open full size

Related ideas