Dev - Select Max(<column>) from <table>

[Michael Irving]

Is there a way to:

 

Select Max(<column>) from <table>

 

Without creating a view entity?

 

-----------------------------------------

Michael Irving

Keynetx, Inc. - Building Solutions for Success

Mobile: [phone]

Fax: [phone]

email: [hidden email]

 

* * * Visit Our Web Site: http://www.keynetx.net * * *

 

--------------------------------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.

 

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[David E. Jones]

I guess so, but not without doing the work on the app server instead  
of in memory.... Of course, you can use a DynamicViewEntity to avoid  
creating a view-entity definition.

You could also drop directly down to the JDBC level getting a  
Connection from the Entity Engine and such...

-David


On Jan 6, 2006, at 12:01 PM, Michael Irving wrote:

> Is there a way to:
>
>
>
> Select Max(<column>) from <table>
>
>
>
> Without creating a view entity?
>
>
>
> -----------------------------------------
> Michael Irving
> Keynetx, Inc. - Building Solutions for Success
> Mobile: [phone]
> Fax: [phone]
> email: [hidden email]
>
> * * * Visit Our Web Site: http://www.keynetx.net * * *
>
> ----------------------------------------------------------------------
> ----------
> NOTICE: If received in error, please destroy and notify sender.  
> Sender does not waive confidentiality or privilege, and use is  
> prohibited.
>
>
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev