Hi All,
I need to use a Union query as below,
SyntaxEditor Code Snippet
SELECT {UseCase}.[Titleusecase] from {UseCase} where {Application}.[Id]=Null Union Select {UseCase}.[Titleusecase] from {UseCase} where {Application}.[Id]= @ApplicationId
But I am getting error in executing the query.
Can anyone help me with this, please?
Regards,
Ankita
Looks like you have communications problems with server. It's now a SQL related error.
You seem to have something wrong in SQL syntax. Instead of "where {Application}.[Id]=Null" should be "where {Application}.[Id] is Null"
What kind of error you have?
Nuno Miguel Verdasca wrote:
Hi Nuno,
Below is the error I am facing,
You filter on another entity than that you select from. Maybe {application} should be {usecase} on the where clause
Daniël Kuhlmann wrote:
Sorry Daniel, when I saw this error in the query, I was writing to him and when I published you had just published.
Hi Daniel,
Even if I correct the entity name, I am facing the following error,
But first of all, if you are filtering for an attribute from the Application table, you have to join the UseCase table with Application.
No need for apologies, it's an active community and that is how it needs to be.