Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

How can i set null to Else condition on CaseWhen Expression? #1315

Closed
lucasortigoso opened this issue Aug 10, 2021 · 1 comment
Closed

How can i set null to Else condition on CaseWhen Expression? #1315

lucasortigoso opened this issue Aug 10, 2021 · 1 comment

Comments

@lucasortigoso
Copy link

Hello,

I need to put NULL value on else condition on Case When expression like below. How can i do that?

SqlExpressionBuilder.case() .When( TblOne.foo.isNotNull(), wrapAsExpression<DateTime>(TblTwo.slice(TblTwo.createdDate.max()).select { TblTwo.foo eq TblOne.foo }) ) .Else(***how to put null here****)
Tapac added a commit that referenced this issue Aug 17, 2021
@Tapac
How can i set null to Else condition on CaseWhen Expression? #1315
23254bf
@Tapac
Copy link
Contributor

Tapac commented Aug 17, 2021

Op.nullOp() added to cover the case. Will be released soon

@Tapac Tapac closed this as completed Aug 17, 2021
SchweinchenFuntik pushed a commit to SchweinchenFuntik/Exposed that referenced this issue Oct 23, 2021
@Tapac @SchweinchenFuntik
How can i set null to Else condition on CaseWhen Expression? JetBrain…
11d1b7b 
…s#1315
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Tapac @lucasortigoso