Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Possible to Specify 2 CatRoot in Global?

Quote Reply
Possible to Specify 2 CatRoot in Global?
All right, just a standard line in a global:

my $cats = $relation->select ( { CatRoot => 4}, GT::SQL::Condition->new('Filter_Type','LIKE','isMain'), ['Category.Full_Name', 'Category.Name'])->fetchall_hashref;

But is it possible to filter two CatRoot's like: CatRoot => 4, 2

I have tried several combinations of this but cant get this to work.

~ ERASER


Free JavaScripts @ Insight Eye
Quote Reply
Re: [Eraser] Possible to Specify 2 CatRoot in Global? In reply to
Pass it an array ref:

my $cats = $relation->select ('Category.Full_Name', 'Category.Name', { CatRoot => [4, 2]}, GT::SQL::Condition->new('Filter_Type', 'LIKE', 'isMain'))->fetchall_hashref;

Adrian
Quote Reply
Re: [brewt] Possible to Specify 2 CatRoot in Global? In reply to
Ah yes, I see.

Many thanks.

~ ERASER


Free JavaScripts @ Insight Eye