Customer query fails with "Invalid qualified name: name" error
OVPMS-2232
Roster synchronisation with Deputy
OVPMS-2189
Laboratory API
OVPMS-2082
Add support to create investigations from multiple tests and different products
OVPMS-2224
DeliveryProcessor adds a preferred product-supplier relationship even if one exists
OVPMS-2226
Customer Product Sales Report doesn't exclude template participations
OVPMS-2225
Invoice credit items
OVPMS-2212
Add support to log customer statements in the communication log
OVPMS-2223
Race condition in roster cache leads to inconsistent state
OVPMS-2221
Remove formatting from phone numbers produced by customer phone number export reports
OVPMS-2222
Improve error reporting when a business rule fails due to AccessDeniedException
OVPMS-1904
Cannot External Edit documents with single quote in name
OVPMS-2220
Add support for non-administrators to edit products
OVPMS-2187
Gap claim accounting improvement
OVPMS-2217
Follow-Up task editor doesn't support sorting of work lists
OVPMS-2218
Changing clinician during charging can remove Patient Letters
OVPMS-2216
Failed to validate Clinician of act.Clinician in invoice edit
OVPMS-2211
Prevent creation of schedules with End Time <= Start Time
OVPMS-2213
Synchronise with Smart Flow Sheet button not displayed in Products - Information
OVPMS-2215
Improve logging for WebDAV lock management
OVPMS-2214
100% discount can trigger -$0.01 item totals through rounding
OVPMS-1756
Scheduling grid shows incorrect times at start and end of daylight saving
OVPMS-1251
Boarding view renders appointments incorrectly during daylight saving
OVPMS-2210
Fix entityLink.productStockLocation relationships where the idealQty is < criticalQty
OVPMS-2208
Display validation errors when an invoice cannot be saved due to a validation error within a rule
OVPMS-2207
Integrate remtool
OVPMS-2209
Update installation docs re: MySQL character encoding
OVPMS-2201
Add jxpath function for active patient alerts
OVPMS-2198
Text PropertyChangeListener not firing for text fields
OVPMS-2199
Use the statement email template when sending ad-hoc statement emails
OVPMS-2196
Unable to dispense medication from non-privileged account
OVPMS-2193
API based Clickatell Access to Handle Errors
OVPMS-2191
Workflow - Scheduling fails to display some appointments
OVPMS-2068
Display customer communications in patient history
OVPMS-2183
Add support to delete jobs
OVPMS-2188
Order Schedule and Work List views
OVPMS-2185
Disable support to deactivate practices
OVPMS-2186
Batch expiry not updating during charging, available batches not shown in Medication editor
OVPMS-2184
Change order of payment item archetypes to better reflect use
OVPMS-2165
Change default lookup cache size to 40000
OVPMS-2179
Add support for N:1 mappings
OVPMS-2180
Exception retrieving booking
OVPMS-2181
Improve document support during invoicing
OVPMS-1065
Expand the Mapping API to support lookups
OVPMS-2176
Increase width of Reason field when displaying active alerts
OVPMS-2170
Duplicate From address to Reply-To address in mails
OVPMS-2175
Allow the medication Expiry Date to be edited when linked to a batch
OVPMS-2167
Cannot update product supplier relationship if the supplier is inactive
OVPMS-2174
"Trigger's related Job's name cannot be null" error after posting order
OVPMS-2173
Add diagnostics for OpenOffice interactions
OVPMS-2171
issue 1 of 1893

Customer query fails with "Invalid qualified name: name" error

Description

To reproduce:

1. Go to Customers - Information and press Select
2. Enter a name into the Patient field for which there are matches, and press Enter
3. In the displayed table, click on the patient Name column to sort by patient
4. clear the Patient field, and press Enter

An error will be displayed:

with an underlying error message:

This is occurring because the patient sort criteria is being used, but there is no join on patients.

Environment

None

Status

Assignee

Tim Anderson

Reporter

Tim Anderson

Labels

None

Components

Fix versions

Affects versions

Priority

Minor
Configure