order-by DESC in entity operation in screen?

[Peter Felts]

Hi, does anyone know how to do an order-by DESC in an entity-and operation in a screen? I've got a view-entity which is pulling up orders and I want to view them to the user in descending order, but the order-by node only seems to result in and order-by ASC operation.

Please help.

[Jacopo Cappellato]

Hi Peter,

you can easily do this:

<order-by field-name="-orderDate"/>

Jacopo

Peter Felts wrote:
> Hi, does anyone know how to do an order-by DESC in an entity-and operation in a screen? I've got a view-entity which is pulling up orders and I want to view them to the user in descending order, but the order-by node only seems to result in and order-by ASC operation.
>
> Please help.
>
>
>

[Peter Felts]

That's it. Thank you.




----- Original Message ----
From: Jacopo Cappellato <[hidden email]>
To: [hidden email]
Sent: Thursday, March 20, 2008 5:03:39 PM
Subject: Re: order-by DESC in entity operation in screen?

Hi Peter,

you can easily do this:

<order-by field-name="-orderDate"/>

Jacopo

Peter Felts wrote:
> Hi, does anyone know how to do an order-by DESC in an entity-and operation in a screen? I've got a view-entity which is pulling up orders and I want to view them to the user in descending order, but the order-by node only seems to result in and order-by ASC operation.
>
> Please help.
>
>
>

[Peter Felts]

Is the minus operator an OFBiz thing or an XML thing?




----- Original Message ----
From: Peter Felts <[hidden email]>
To: [hidden email]
Sent: Thursday, March 20, 2008 5:37:01 PM
Subject: Re: order-by DESC in entity operation in screen?

That's it. Thank you.




----- Original Message ----
From: Jacopo Cappellato <[hidden email]>
To: [hidden email]
Sent: Thursday, March 20, 2008 5:03:39 PM
Subject: Re: order-by DESC in entity operation in screen?

Hi Peter,

you can easily do this:

<order-by field-name="-orderDate"/>

Jacopo

Peter Felts wrote:
> Hi, does anyone know how to do an order-by DESC in an entity-and operation in a screen? I've got a view-entity which is pulling up orders and I want to view them to the user in descending order, but the order-by node only seems to result in and order-by ASC operation.
>
> Please help.
>
>
>

[Jacopo Cappellato]

Peter Felts wrote:
> Is the minus operator an OFBiz thing or an XML thing?

An OFBiz thing.

Jacopo

>
>
>
>
> ----- Original Message ----
> From: Peter Felts <[hidden email]>
> To: [hidden email]
> Sent: Thursday, March 20, 2008 5:37:01 PM
> Subject: Re: order-by DESC in entity operation in screen?
>
> That's it. Thank you.
>
>
>
>
> ----- Original Message ----
> From: Jacopo Cappellato <[hidden email]>
> To: [hidden email]
> Sent: Thursday, March 20, 2008 5:03:39 PM
> Subject: Re: order-by DESC in entity operation in screen?
>
> Hi Peter,
>
> you can easily do this:
>
> <order-by field-name="-orderDate"/>
>
> Jacopo
>
> Peter Felts wrote:
>> Hi, does anyone know how to do an order-by DESC in an entity-and operation in a screen? I've got a view-entity which is pulling up orders and I want to view them to the user in descending order, but the order-by node only seems to result in and order-by ASC operation.
>>
>> Please help.
>>
>>
>>
>
>
>
>
>
>

[Jacopo Cappellato]

Jacopo Cappellato wrote:
> Peter Felts wrote:
>> Is the minus operator an OFBiz thing or an XML thing?
>
> An OFBiz thing.
>

"-" is converted by the OFBiz framework in the SQL equivalent clause "DESC"

> Jacopo
>
>>
>>
>>
>>
>> ----- Original Message ----
>> From: Peter Felts <[hidden email]>
>> To: [hidden email]
>> Sent: Thursday, March 20, 2008 5:37:01 PM
>> Subject: Re: order-by DESC in entity operation in screen?
>>
>> That's it. Thank you.
>>
>>
>>
>>
>> ----- Original Message ----
>> From: Jacopo Cappellato <[hidden email]>
>> To: [hidden email]
>> Sent: Thursday, March 20, 2008 5:03:39 PM
>> Subject: Re: order-by DESC in entity operation in screen?
>>
>> Hi Peter,
>>
>> you can easily do this:
>>
>> <order-by field-name="-orderDate"/>
>>
>> Jacopo
>>
>> Peter Felts wrote:
>>> Hi, does anyone know how to do an order-by DESC in an entity-and
>>> operation in a screen? I've got a view-entity which is pulling up
>>> orders and I want to view them to the user in descending order, but
>>> the order-by node only seems to result in and order-by ASC operation.
>>>
>>> Please help.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>>

[Peter Felts]

Do you know of any other operators like that? I haven't seen anything like this in the entity engine guide...






----- Original Message ----
From: Jacopo Cappellato <[hidden email]>
To: [hidden email]
Sent: Thursday, March 20, 2008 7:04:16 PM
Subject: Re: order-by DESC in entity operation in screen?

Jacopo Cappellato wrote:
> Peter Felts wrote:
>> Is the minus operator an OFBiz thing or an XML thing?
>
> An OFBiz thing.
>

"-" is converted by the OFBiz framework in the SQL equivalent clause "DESC"

> Jacopo
>
>>
>>
>>
>>
>> ----- Original Message ----
>> From: Peter Felts <[hidden email]>
>> To: [hidden email]
>> Sent: Thursday, March 20, 2008 5:37:01 PM
>> Subject: Re: order-by DESC in entity operation in screen?
>>
>> That's it. Thank you.
>>
>>
>>
>>
>> ----- Original Message ----
>> From: Jacopo Cappellato <[hidden email]>
>> To: [hidden email]
>> Sent: Thursday, March 20, 2008 5:03:39 PM
>> Subject: Re: order-by DESC in entity operation in screen?
>>
>> Hi Peter,
>>
>> you can easily do this:
>>
>> <order-by field-name="-orderDate"/>
>>
>> Jacopo
>>
>> Peter Felts wrote:
>>> Hi, does anyone know how to do an order-by DESC in an entity-and
>>> operation in a screen? I've got a view-entity which is pulling up
>>> orders and I want to view them to the user in descending order, but
>>> the order-by node only seems to result in and order-by ASC operation.
>>>
>>> Please help.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>>