[Dbix-class] Creating 'query' objects

Will Hawes info at whawes.co.uk
Tue Jan 24 15:45:22 CET 2006

Gert Burger wrote:
> Hi
> I'm very new to DBIx::Class and I am very conduffled atm.
> I would like to create a Class based on dbixc that would always give me
> access to a query which is similiar to "select col from table group by
> col" in mysql.
> This may seem odd, but I need to access a database from another program
> which tags row's based on events, but it doesnt not have a table with
> all the events. So I have to discover the events using a group or
> distinct.
> Thanks in advance.
> Gert Burger

Sounds like "Grouping results" at 
is what you need.

The above example uses the newer (and recommended) schema-based approach 
- if you need an intro to that, please read the following too:


More information about the Dbix-class mailing list