[ https://issues.apache.org/jira/browse/EMPIREDB-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17829480#comment-17829480 ]
Rainer Döbele edited comment on EMPIREDB-417 at 3/21/24 10:43 AM: ------------------------------------------------------------------ So how about: {{cmd.where(MY_COL.like("%Hello%").and(MY_COL.like("%World%"));}} Your other use-case looks akward to me: You only need either not both. was (Author: doebele): So how about: {{cmd.where(MY_COL.like("%Hello%").and(MY_COL.like("%World%"));}} Your other use-case looks akward to me. > DBCommand Feature Request: add WHERE without overwriting > -------------------------------------------------------- > > Key: EMPIREDB-417 > URL: https://issues.apache.org/jira/browse/EMPIREDB-417 > Project: Empire-DB > Issue Type: Improvement > Components: Core > Affects Versions: empire-db-3.1.0 > Reporter: Jan Glaubitz > Priority: Trivial > > DBCommand.where always removes existing DBCompareExpr before adding the new > one. > I know this is expected behavior, but this can be annoying when you have to > add multiple constraints on the same column under coniditions. > It would be nice to have something like DBCommand.addWhereConstraints but > without the List. > Maybe a new where method that has a boolean for overwrite or not? -- This message was sent by Atlassian Jira (v8.20.10#820010)