You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am working with an old database and trying to use Objection to query it. Unfortunately there are a few tables with a dot/period in their name. I've been able to use raw() to access these tables, but I haven't been able to set up a Model. One of these Models is set up like this:
But this queries the table as [Customers].[Contacts] when I want [Customers.Contacts]. Any addition of square brackets makes no difference to the output, trying double quotes surrounding the name produces ["Customers].[Contacts"], and I am unable to use the raw() function in this method.
Apart from renaming the table, is there any way to get this set up correctly?
Thanks.
The text was updated successfully, but these errors were encountered:
Hello,
I am working with an old database and trying to use Objection to query it. Unfortunately there are a few tables with a dot/period in their name. I've been able to use
raw()
to access these tables, but I haven't been able to set up a Model. One of these Models is set up like this:But this queries the table as
[Customers].[Contacts]
when I want[Customers.Contacts]
. Any addition of square brackets makes no difference to the output, trying double quotes surrounding the name produces["Customers].[Contacts"]
, and I am unable to use theraw()
function in this method.Apart from renaming the table, is there any way to get this set up correctly?
Thanks.
The text was updated successfully, but these errors were encountered: