<div dir="ltr">Hello Rajesh,<div><br></div><div>C::C::DBIC::API supports that under the hood, so not sure what are you going after.</div><div><br></div><div>You can either use: search=JSON.stringify(object) or construct the search passing params like: search.holder.-ilike=%mis%. Both should work out of the box.</div><div><br></div><div>Regards</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 1, 2017 at 10:24 AM, Rajesh Kumar Mallah <span dir="ltr"><<a href="mailto:mallah@redgrape.tech" target="_blank">mallah@redgrape.tech</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
<br>
Hi ,<br>
<br>
CGI::Expand collapse_hash comes to rescue ,<br>
below is a small snippet that converts the perl<br>
hash reference to the TT's dotted format using<br>
CGI::Expand.<br>
<br>
<br>
==============================<wbr>==============================<br>
#!/usr/bin/perl -w<br>
<br>
use strict;<br>
<br>
use CGI::Expand qw(expand_hash collapse_hash);<br>
use Data::Dumper;<br>
use JSON::XS;<br>
use URI::Escape;<br>
<br>
<br>
# SQL::Abstract Syntax comes here.<br>
my $where = {<br>
search => {<br>
holder1 => { -ilike => '%mis%' },<br>
mobile1 => { -ilike => '%967%' },<br>
flat_no => 'A203'<br>
}<br>
} ;<br>
<br>
<br>
<br>
my $flat_hash = collapse_hash( $where );<br>
<br>
print join '&' , map { my $k = $_; my $v = uri_escape(<br>
$flat_hash->{$k}) ; "$k=$v" } keys %{$flat_hash};<br>
<br>
print "\n";<br>
==============================<wbr>========================<br>
<br>
Output:<br>
<br>
<br>
$VAR1 = {<br>
'search.mobile1.-ilike' => '%967%',<br>
'search.holder1.-ilike' => '%mis%',<br>
'search.flat_no' => 'A203'<br>
};<br>
search.mobile1.-ilike=%25967%<wbr>25&search.holder1.-ilike=%<wbr>25mis%25&search.flat_no=A203<br>
<br>
<br>
<br>
Regds<br>
<span class="HOEnZb"><font color="#888888">Mallah.<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
<br>
<br>
><br>
> Hi ,<br>
><br>
> In continuation of previous query kindly guide how to do a<br>
> anchored or unanchored ilike search using<br>
> Catalyst::Controller::DBIC::<wbr>API::REST<br>
><br>
><br>
> I have used DBIC search with lots of search conditions in past<br>
> that uses SQL::Abstract, at this moment I need a guide(document)<br>
> on how to convert SQL::Abstract's conventions to Query parameter<br>
> format<br>
><br>
><br>
> Eg:<br>
><br>
<a href="http://10.100.102.38:3000/api/rest/general/members?list_returns=holder1&list_count=10" rel="noreferrer" target="_blank">http://10.100.102.38:3000/api/<wbr>rest/general/members?list_<wbr>returns=holder1&list_count=10</a><br>
><br>
> Returns:<br>
><br>
> {<br>
> "Result": "OK",<br>
> "Records": [<br>
> {<br>
> "holder1": "Sh. R. Krishna Kumar"<br>
> },<br>
> {<br>
> "holder1": "Sh. Sharad Kumar Srivastava"<br>
> },<br>
> {<br>
> "holder1": "Smt. Shubhra Jain ."<br>
> },<br>
> {<br>
> "holder1": "Sh. Balam Singh Negi"<br>
> },<br>
> {<br>
> "holder1": "Sh. Subodh Jain"<br>
> },<br>
> {<br>
> "holder1": "Smt. Punita Batra"<br>
> },<br>
> {<br>
> "holder1": "Sh.K C Sardana"<br>
> },<br>
> {<br>
> "holder1": "Smt. Sunita Mishra"<br>
> },<br>
> {<br>
> "holder1": "Sh. Vijay Kumar Khanna"<br>
> },<br>
> {<br>
> "holder1": "Smt. Daisy Tyagi"<br>
> }<br>
> ]<br>
> }<br>
><br>
><br>
> I need a Query param that would return all holder1 matching<br>
> Mis. ie holder1 ilike '%Mis%'<br>
><br>
><br>
> As always Thanks in anticipation of your valuable time/attention.<br>
><br>
><br>
> Regds<br>
> Mallah.<br>
><br>
><br>
><br>
><br>
><br>
> ______________________________<wbr>_________________<br>
> List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
> Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" rel="noreferrer" target="_blank">http://lists.scsys.co.uk/cgi-<wbr>bin/mailman/listinfo/catalyst</a><br>
> Searchable archive:<br>
> <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" rel="noreferrer" target="_blank">http://www.mail-archive.com/<wbr>catalyst@lists.scsys.co.uk/</a><br>
> Dev site: <a href="http://dev.catalyst.perl.org/" rel="noreferrer" target="_blank">http://dev.catalyst.perl.org/</a><br>
><br>
<br>
<br>
<br>
<br>
<br>
______________________________<wbr>_________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" rel="noreferrer" target="_blank">http://lists.scsys.co.uk/cgi-<wbr>bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" rel="noreferrer" target="_blank">http://www.mail-archive.com/<wbr>catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" rel="noreferrer" target="_blank">http://dev.catalyst.perl.org/</a><br>
</div></div></blockquote></div><br></div>