Good day all! I was wondering if someone could giv...
# generala
Alex
10/13/2021, 3:36 PMGood day all! I was wondering if someone could give me some insight into why this suiteql query isn't working?
select vendor.id, vendor.firstname, vendor.lastname, vendor.email, vendor.isinactive from vendor where isperson = 'T' union select employee.id, employee.firstname, employee.lastname, employee.email, employee.isinactive from employeen
NElliott
10/13/2021, 3:41 PMmaybe try in suiteql channel if nobody answers
🙌 1
a
Alex
10/13/2021, 3:41 PMOh thanks!
g
GeneralKenobi
10/13/2021, 3:42 PM@Alex I just copied your query and ran it in my SuiteQL tool and did not get an error.
a
Alex
10/13/2021, 3:43 PMHuh, maybe postman is doing something funky.
g
GeneralKenobi
10/13/2021, 3:44 PMare you using a RESTlet with the query module?
a
Alex
10/13/2021, 3:45 PMNo I am just hitting the query endpoint directly from postman
Alex
10/13/2021, 3:45 PMIt works fine if I just do either employee or vendor, the union seems to cause the error for me.
Alex
10/13/2021, 3:47 PM@GeneralKenobi but I just get this back:
Copy code
{
"type": "<https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1>",
"title": "Internal Server Error",
"status": 500,
"o:errorDetails": [
{
"detail": "An unexpected error occurred. Error ID: XXXXXX",
"o:errorCode": "UNEXPECTED_ERROR"
}
]
}g
GeneralKenobi
10/13/2021, 3:58 PMI need to test that never thought of querying directlyusing POSTMAN
GeneralKenobi
10/13/2021, 3:59 PMSorry couldn't be more help,
a
Alex
10/13/2021, 4:01 PMNo worries!
I also tried doing it directly in C# using an integration test I already had setup and got the same error. Maybe there is some random setting that is preventing me from doing this. 😞
Alex
10/13/2021, 4:19 PM@GeneralKenobi got it! It's weird and I have no idea why this did it because the documentation is sparse at best but this is what worked:
select t.* from ((select id, firstname, lastname, email, isinactive from vendor where isperson = 'T') union (select id, firstname, lastname, email, isinactive from employee)) t5 Views