Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #31408
    Paul Frishert
    Participant

    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.

    #33229
    William
    Keymaster

    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?

    #33230
    Paul Frishert
    Participant

    Solves it. Thanks a lot.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.