Smart Query performs slowly for users using a non-base currency

Users who are defaulted to a specific currency set can choose non-base currencies when configuring smart queries.  However, when these queries are executed, they take much longer to run than for users with no currency set associated with their username, which means they only create queries using the base currency.  This can be demonstrated using the Donor List smart query.
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1. Log in with a user who has a specific currency set
2. Go to Analysis, Information Library, Add a new Smart Query
3. Create a donor list smart query
4. Choose the Date range 01/01/14 through 12/30/14
5. Set the amount greater than 999. Euros (non base currency of your choice)
This query takes several minutes to run.  

6. Save this query
7. Access the application with a user who has no default currency set.
8. Preview the same query
Now this  will run in about 2 minutes.

Environment

 Blackbaud CRM
 3.0

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.