Query results won't sort on multiple fields if Constituent Date Last Changed is included

When attempting to sort a query using the field Constituent Date Last Changed, other sort fields fail. It is possible to sort on Constituent Date Last Changed OR other sort fields, but not both.
We have evaluated this issue and have determined the cause is the data types for Date Added and Date Last Changed have a DATETIME data type. In this scenario the sort order on the backend tables of Raiser’s Edge sort by a date AND time stamp mm/dd/yyyy hh:mm:ss.ms. This may cause the sort order in Query to appear incorrectly when multiple sort fields are selected and the user cannot see on the front end what time is stamped on these records.
In this case, we believe the risks and challenges outweigh the potential benefit of resolving this issue. We strive to select the most impactful changes and issues to address with each release to accelerate the rate at which we deliver new features while sustaining the highest level of quality for our customers. Alternatively, users can export the Query results and sort outside of Raiser’s Edge.


Steps to Duplicate

  1. Create a Constituent Query
  2. In the Sort tab, include  Constituent Date Last Changed and any other sort criteria
  3. Only the first criteria will be respected.

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.