[
https://issues.apache.org/jira/browse/EMPIREDB-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17829448#comment-17829448
]
Jan Glaubitz commented on EMPIREDB-417:
---------------------------------------
WHERE CREATE_USER IN (1, 2, 3, 4, 5) AND CREATE_USER = 1
(1, 2, 3, 4, 5) is a pre-selected list of records created by users the current
user is allowed to see. 1 is the ID of the user has selected in a filter.
or just
WHERE MY_COL LIKE '%hello%' AND MY_COL LIKE '%world%'
> 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)
