sorry i didnt understand.
how can this have it?
my $obj_rs = $schema->resultset('itemList')->serach(
{ t_id => { -in => [ $tStr ] }},
{
group_by => [ qw(i_id) ],
HAVING COUNT('t_id') = $tCount
}
);
On Saturday, September 3, 2016 1:37 AM, Ron Savage <r...@savage.net.au>
wrote:
Hi Rajeev
On 03/09/16 15:58, Rajeev Prasad wrote:
> I tried what you said and also what manual says, but it is not working....
> my tries:
> HAVING => { count('t_id') => $tCount}
> HAVING => {'COUNT_t_id' => {'=', $tCount } }
> HAVING => { count('t_id') => {'=', $tCount } }
>
> having => { 'count_employee' => { '>=', 100 } }
Those docs tell me that the SQl has to include something like:
'select ... count(t_id) as count_t_id ...
And then the having can be
having => {count_t_id => {'=', $tCount} }
--
Ron Savage - savage.net.au
