Log in to AnswerLog in to Follow
Utkalika Majhi
8Views
1Comments
[(Unofficial) OutSystems Forge API Example] how can I fix error could not find server in sys.server.
Question
Forge
Traditional Web
(Unofficial) OutSystems Forge API Example
Forge component by Miguel 'Kelter' Antunes
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
on 24th Mar

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
on 24th Mar
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.