diff options
| -rw-r--r-- | app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java b/app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java index 37a511b1..f482071a 100644 --- a/app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java +++ b/app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java @@ -37,7 +37,7 @@ public interface PostFilterDao { List<PostFilter> getAllPostFilters(); @Query("SELECT * FROM post_filter WHERE post_filter.name IN " + - "(SELECT post_filter_usage.name FROM post_filter_usage WHERE (usage = :usage AND name_of_usage = :nameOfUsage) " + + "(SELECT post_filter_usage.name FROM post_filter_usage WHERE (usage = :usage AND name_of_usage = :nameOfUsage COLLATE NOCASE) " + "OR (usage =:usage AND name_of_usage = '--'))") List<PostFilter> getValidPostFilters(int usage, String nameOfUsage); |