Is it possible to filter the rows which string-columns contains special substring? Expressions like .whereContains("name", "Pavel") throws exception: Exception: Filter "Contains" is not supported for mapping "String". Of course, I can easily use scala filter but DB should do it better, isn't it?
SORM Framework: whereContains
118 Views Asked by plomovtsev At
1
There are 1 best solutions below
Related Questions in SCALA
- Spark .mapValues setup with multiple values
- Where do 'normal' println go in a scala jar, under Spark
- Serializing to disk and deserializing Scala objects using Pickling
- Where has "Show Type Info on Mouse Motion" gone in Intellij 14
- AbstractMethodError when mixing in trait nested in object - only when compiled and imported
- Scala POJO Aggregator Exception
- How to read in numbers from n lines into a Scala list?
- Spark pairRDD not working
- Scala Eclipse IDE compiler giving errors until "clean" is run
- How to port Slick 2.1 plain SQL queries to Slick 3.0
- Log of dependency does not show
- Getting unary error for escaped characters in Scala
- Akka actor invoked with a function delegate - is this bad practice?
- Json implicit format with recursive class definition
- How to create a executable jar reading files from local file system
Related Questions in FILTER
- Angular Show All When No Filter Is Supplied
- Git > diffs filtered, show only certain changed classes/files
- Apply gaussian filter on text
- FFT Filtering of signal
- Rails WiceGrid with multiples attributes in the same column
- How to check if element of an array is in another array?
- filter from listbox regex
- Limit items on external list using BCS Filter
- Wordpress: custom content shows before $content
- How to filter keys of an object with lodash?
- Lowpass filter non working
- Transparent Activity in Android
- Firebase: combine filtering with ordering in swift
- Angular Filtering
- VBA Excel custom text filter by more than two texts
Related Questions in FRAMEWORKS
- MonoDB JS libraries
- adding framework to Xcode 7
- does semantic ui framework support rtl languages?
- Underscore _.findWhere not finding element in array when it exists
- Architecture for creating a JavaScript framework
- iOS 8+ framework with nested embedded framework
- How to design tree in meteor framework?
- Yii2 : Cannot Show Data in Widget GridView
- CakePHP find WHERE NOT EQUAL
- Yii 1.1.3 framework. Make and existing image to be uploaded like
- iOS framework resource files
- Migrate web application to PHP Framework
- yii2 error when trying to install all generats files
- Getting Framework related warning in Xcode 7.0
- Ember js default bundle
Related Questions in FULL-TEXT-SEARCH
- MYSQL How to search for accent characters too?
- laravel full-text search with multiple keywords together
- PostgreSQL 9.4 - Elements of jsonb array to ts_vector in
- Mongodb doctrine query builder full text search does not sort the results based on the textScore
- mysql fulltext boolean NOT operator
- Mongodb text search doesn't work on long string but works on short string
- Cannot enable Full-Text search on Azure SQL Database V12
- lucene 5.1.0 delete document from index with specific id
- How to parse user search string for Postgresql query?
- Fulltext search slow SQL V12 Azure
- MongoDB text search and geoWithin search
- full text search with multiple text input
- Lucene vs Solr, indexning speed for sampe data
- MySQL FULLTEXT search counting occurrences
- Showing previous searches in PyCharm
Related Questions in SORM
- sorm version causing activator to fail compile
- SORM Framework: whereContains
- Can I change SORM id type to UUID?
- How to using join table in SORM?
- SORM: Attempt to refer to an unpersisted entity
- SORM class cast exception
- Sorm Example causing error (not found type)
- How to build sorm for scala 2.10.1
- SORM: How can I declare many to many relationships?
- Updating data in SORM seems possible (even though I was told it aimed at immutable data...)
- Is it possible to add a transient field to SORM?
- How can we configure SORM to support utf-8?
- How to conduct db schema migration in sorm?
- SORM vs MySQL idle connection
- Sorrm how to add a column to an existing table
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
It seems like in
whereContainsthe path should refer to some collection, for example if you were searching for a name within a set of nested names of some entity.What you want is to use
whereLike("name", "Pavel"), which uses an SQLLIKEclause used for substring matching.