Skip to Content (Press Enter)
UserImage.jpg
Utkalika Majhi
14Views
1Comments
[(Unofficial) OutSystems Forge API Example] how can I fix error could not find server in sys.server.
Question
Forge
Traditional Web
Application Type
Traditional Web
Service Studio Version
11.10.16 (Build 40209)
Platform Version
11.11.1 (Build 29104)
While testing this query:- 

SELECT {Book}.[BookName] from {Book}
JOIN {UserBookIssue} ON {Book}.[Id]={UserBookIssue}.[BookId]
Join {User}.[Id] ON {UserBookIssue}.[BookId]={User}.[Id]
where {UserBookIssue}.[UserId]=5

I get error:-could not find server in sys.servers

0
0
24 Mar 2021
Copy Link
2021-06-16 06-20-58
Cezar Francisco

Must just be a typo error. I would  change 

"Join {User}.[Id]"  to "Join {User}" 

eg:

SELECT {Book}.[BookName] from {Book}
JOIN {UserBookIssue} ON {Book}.[Id]={UserBookIssue}.[BookId]
Join {User} ON {UserBookIssue}.[BookId]={User}.[Id]
where {UserBookIssue}.[UserId]=5

joining {UserBookIssue}.[BookId] with {User}.[Id] might be incorrect though.

should it be:

SELECT {Book}.[BookName] from {Book}
JOIN {UserBookIssue} ON {Book}.[Id]={UserBookIssue}.[BookId]
Join {User} ON {UserBookIssue}.[UserId]={User}.[Id]
where {UserBookIssue}.[UserId]=5


0
0
24 Mar 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.