Viewing 3 posts - 1 through 3 (of 3 total)
Viewing 3 posts - 1 through 3 (of 3 total)
- You must be logged in to reply to this topic.
Since the last database update something has been changed in the views within the database.
Earlier I had a report in which I selected some fields from view_invoices, this worked perfect. Now the select for the specific fields is overruled and all fields are shown. What has been changed?
For example:
select code
from view_invoices
In the SQL viewer it reports the codes (patients) and in a report it reports all fields now.
Hi Meslogie
That does sound very strange. Although this should not make a difference I wondered if you did the first table as the “inv” table instead and then you join the “view_invoices” onto that. So it would look like the SQL below.
select code
from inv
left join view_invoices on (view_invoices.id=inv.id)
Please remember that any fields you are before the “from” will have to be prefaced with “view_invoices.”
Does this fix the problem?
Solves it. Thanks a lot.