On Tue, Dec 18, 2012 at 12:29:10PM +0200, Octavian Rasnita wrote:
> From: "Peter Rabbitson"
>
>
> > On Tue, Dec 18, 2012 at 10:53:25AM +0200, Octavian Rasnita wrote:
> >> From: "Peter Rabbitson"
> >>
> >> > On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
> >> >> I am doing
From: "Peter Rabbitson"
> On Tue, Dec 18, 2012 at 10:53:25AM +0200, Octavian Rasnita wrote:
>> From: "Peter Rabbitson"
>>
>> > On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
>> >> I am doing such a order with the following SQL:
>> >>
>> >> ...
>> >> ORDER BY
>> >> (dep
On Tue, Dec 18, 2012 at 10:53:25AM +0200, Octavian Rasnita wrote:
> From: "Peter Rabbitson"
>
> > On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
> >> I am doing such a order with the following SQL:
> >>
> >> ...
> >> ORDER BY
> >> (department = 'Marketing') DESC,
> >> (
From: "Peter Rabbitson"
> On Tue, Dec 18, 2012 at 10:53:25AM +0200, Octavian Rasnita wrote:
>> From: "Peter Rabbitson"
>>
>> > On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
>> >> I am doing such a order with the following SQL:
>> >>
>> >> ...
>> >> ORDER BY
>> >> (dep
On Tue, Dec 18, 2012 at 10:53:25AM +0200, Octavian Rasnita wrote:
> From: "Peter Rabbitson"
>
> > On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
> >> I am doing such a order with the following SQL:
> >>
> >> ...
> >> ORDER BY
> >> (department = 'Marketing') DESC,
> >> (
From: "Peter Rabbitson"
> On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
>> I am doing such a order with the following SQL:
>>
>> ...
>> ORDER BY
>> (department = 'Marketing') DESC,
>> (department = 'Sales') DESC,
>> (department = 'Financial') DESC,
>> (department =
On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
> I am doing such a order with the following SQL:
>
> ...
> ORDER BY
> (department = 'Marketing') DESC,
> (department = 'Sales') DESC,
> (department = 'Financial') DESC,
> (department = 'IT') DESC,
> (department = 'Oper
I am doing such a order with the following SQL:
...
ORDER BY
(department = 'Marketing') DESC,
(department = 'Sales') DESC,
(department = 'Financial') DESC,
(department = 'IT') DESC,
(department = 'Operations') DESC,
...
But there is no special way to use this with DBIx::Class :-/
Hi,
In MySQL is possible to do something like:
select * from table_name order by field(department, 'Marketing', 'Sales',
'Financial', 'IT', 'Operations');
In other databases it should be done differently
Is it possible to do this search with DBIC?
--Octavian