Thanks for the response, I shall relook that approach and
post when I work on it again.
Kind Regds
mallah
> Have you tried using the search parameter with JSON encoded parameters
> as suggested before?
>
> DBI::API doesn't guess if the search parameter you've provided is a
> column name or a db
Have you tried using the search parameter with JSON encoded parameters
as suggested before?
DBI::API doesn't guess if the search parameter you've provided is a
column name or a db function.
Best regards, Alex
On 2017-03-28 18:58, Rajesh Kumar Mallah wrote:
Hi ,
Thanks for the response.
(
leaving out the appending of base in RequestArguments.pm
does makes it work in my case.
--- RequestArguments.pm.orig2017-03-28 22:59:23.117637072 +0530
+++ RequestArguments.pm 2017-03-28 22:59:34.685636949 +0530
@@ -371,12 +371,11 @@
# might be a sql function instead of a colu
Hi ,
Thanks for the response.
(1) The HTTP Request is:
/api/rest/general/members?list_returns=holder1&search.member_balance(member_id)=21
(2) controller config is: https://pastebin.com/2iT1YSPm
Error log:
[2017/03/28 22:22:44]- API.pm-290: ERROR
DBIx::Class::Storage::DBI::_dbh_execute():
Hi,
please include your controller config and the http call.
Best regards, Alex
On 2017-03-19 04:49, Rajesh Kumar Mallah wrote:
Hi ,
Including member_balance(member_id) in 'search_exposes' config param
did help to proceed to some extent , but the function is being
prefixed by the table alias
Hi ,
Including member_balance(member_id) in 'search_exposes' config param
did help to proceed to some extent , but the function is being
prefixed by the table alias whereas it should be left alone.
eg:
search_exposes => [
qw/member_balance(member_id)/,
Hi ,
How to perform below search:
select member_id,holder1 from general.members where
member_balance(member_id , '2017-03-14') < 0 ;
there is a function on LHS of the condition
Regds
Mallah.
> Hello Rajesh,
>
> C::C::DBIC::API supports that under the hood, so not sure what are you
Dear Petrov,
Thanks i will try the JSON.stringify approach , the snippet was just
for spitting out what you typed , i am not sure if it would be
so easy to type out the parameters in case of complex conditions.
Warm Regards
Rajesh.
> Hello Rajesh,
>
> C::C::DBIC::API supports that under the h
Hello Rajesh,
C::C::DBIC::API supports that under the hood, so not sure what are you
going after.
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.
Regards
On Wed, Mar 1, 2017 at 10:24 AM,
Hi ,
CGI::Expand collapse_hash comes to rescue ,
below is a small snippet that converts the perl
hash reference to the TT's dotted format using
CGI::Expand.
#!/usr/bin/perl -w
use strict;
use CGI::Expand qw(expand_hash collapse_ha
10 matches
Mail list logo