diff options
| author | Docile-Alligator <25734209+Docile-Alligator@users.noreply.github.com> | 2023-10-21 04:15:13 +0000 |
|---|---|---|
| committer | Docile-Alligator <25734209+Docile-Alligator@users.noreply.github.com> | 2023-10-21 04:15:13 +0000 |
| commit | fe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb (patch) | |
| tree | 1a6e5a10d7676606001570d41a22ba13d1bfbf4e | |
| parent | af04240dfa014b5d61ac0c83ea57b7983e086dd4 (diff) | |
| download | infinity-for-reddit-fe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb.tar infinity-for-reddit-fe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb.tar.gz infinity-for-reddit-fe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb.tar.bz2 infinity-for-reddit-fe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb.tar.lz infinity-for-reddit-fe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb.tar.xz infinity-for-reddit-fe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb.tar.zst infinity-for-reddit-fe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb.zip | |
Finish applying comment filter.
| -rw-r--r-- | app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java b/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java index e6163aa5..68785fb8 100644 --- a/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java +++ b/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java @@ -36,9 +36,9 @@ public interface CommentFilterDao { @Query("SELECT * FROM comment_filter") List<CommentFilter> getAllCommentFilters(); - @Query("SELECT * FROM comment_filter WHERE comment_filter.name IN " + - "(SELECT comment_filter_usage.name FROM comment_filter_usage WHERE (usage = :usage AND name_of_usage = :nameOfUsage) " + - "OR (usage =:usage AND name_of_usage = '--'))") + @Query("SELECT * FROM comment_filter WHERE (comment_filter.name IN " + + "(SELECT comment_filter_usage.name FROM comment_filter_usage WHERE (usage = :usage AND name_of_usage = :nameOfUsage COLLATE NOCASE)))" + + " OR (comment_filter.name NOT IN (SELECT comment_filter_usage.name FROM comment_filter_usage))") List<CommentFilter> getValidCommentFilters(int usage, String nameOfUsage); @Transaction |