It is taking a long time to pull patron up when scanning membership cards

When scanning a membership card in daily sales, you may find that it is taking a long time for the patron to pull up.
This may be due to Daily Sales notifications tied to complex queries.
  1. Go to Administration > Notifications under Tools.
  2. Look at the column that says Display in Daily Sales.  For Notifications with a yes in this column, click on the notification and click Edit.
  3. Note the selection name in the notification and click Save.
  4. Go to Analysis > Information Library and search for this selection.
  5. Click on the query selection and click Edit.
  6. If your criteria has OR statements, try to simplify the query or go to the Set Save Options tab and mark the checkbox to Create a Static Selection.  Click Save.
  7. Note: A static selection will not update the results of the query automatically, but it does improve performance.  For example, if new people are added to that query, your Daily Sales notification will not update and display for those new people until you refresh the static selection yourself.  To update the results of the query, go to Analysis > Information Library and search for this selection. Click on the name of the selection, then click "Click here to process the query and view the results."

Steps to Duplicate

  1. From Sales, select Daily sales,
  2. Place cursor in Patron field and scan membership card

Environment

 Altru Arts & Cultural
 Yes

Was this article helpful?