Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question

How to get max row object back

How would I obtain the maximum row from a space based on a field. For example: myObject = "Get me the object in mySpace that has the highest SEQ_ID value".. SEQ_ID is a long. h4. Attachments


{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=2495]{quote}

asked 2008-07-29 10:15:57 -0500

mzinna gravatar image

updated 2013-08-08 09:52:00 -0500

jaissefsfex gravatar image
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

You have 2 options:
- Use the GigaSpaces JDBC Driver API and use the SQL command. Not recommended option.
- Use the ExternalEntry API. See attached how. Extract the attached into \gigaspaces-xap-6.5.0-ga\examples , run the \externalentry-query\bin\startAll and later the \externalentry-query\bin\run script.

Make sure you have the extended indexing turned on for the relevant field. see the \gigaspaces-xap-6.5.0-ga\examples\externalentry-query\config\externalentry-query.properties



  1. externalentry-query.zip

answered 2008-07-29 10:32:33 -0500

shay hassidim gravatar image
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2008-07-29 10:15:57 -0500

Seen: 65 times

Last updated: Jul 29 '08