My goal is to retrieve a dataset based from a combination of a LIKE
operator (since MSSQL doesn't support regex):
To illustrate my point, here is a definition prototype:
def_dataset_method(:commercial_members) do
filter(:mem_lob.like('1%'), (:mem_lob.like('2%')).sql_or)
end
"return a filtered dataset with mem_lob are like 1* or 2* "
**
The above would raise an exception.
In contrary, the following (similar) definition works:
def_dataset_method(:disenrolled) do
filter({ :disenr => 'D', :group_num => ' ' }.sql_or)
end
It looks like the "sql_or" method cannot handle "LIKE", and only hash is
supported.
So how to do I achieve my goal? Thank you.
Ken
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/bEjKesSv3ScJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
