|

»

»

»

[jira] Created: (CAY-1068) Add support for start index/offset of queries

View: New views

4 Messages — Rating Filter: Alert me

	[jira] Created: (CAY-1068) Add support for start index/offset of queries by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Add support for start index/offset of queries --------------------------------------------- Key: CAY-1068 URL: https://issues.apache.org/cayenne/browse/CAY-1068 Project: Cayenne Issue Type: Improvement Components: Cayenne Core Library Affects Versions: 3.0 Reporter: Robert Zeigler Assignee: Andrus Adamchik Priority: Minor Cayenne already allows us to programatically set a query fetch limit. It would be nice if we could also specify a fetch index/fetch offset into a query, to make it simple to fetch, eg, the 100th through the 150th results from the database. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Updated: (CAY-1068) Add support for start index/offset of queries by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anton Sakalouski updated CAY-1068: ---------------------------------- Attachment: patch.txt The feature implementation. It uses native sql-language capabilities of Mysql, Oracle, HSSQL and Postgre for the rest dbs the first "offset" rows are leaved out in JDBCResultIterator. > Add support for start index/offset of queries > --------------------------------------------- > > Key: CAY-1068 > URL: https://issues.apache.org/cayenne/browse/CAY-1068 > Project: Cayenne > Issue Type: Improvement > Components: Cayenne Core Library > Affects Versions: 3.0 > Reporter: Robert Zeigler > Assignee: Andrus Adamchik > Priority: Minor > Attachments: patch.txt > > > Cayenne already allows us to programatically set a query fetch limit. > It would be nice if we could also specify a fetch index/fetch offset into a query, to make it simple to fetch, eg, the 100th through the 150th results from the database. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Updated: (CAY-1068) Add support for start index/offset of queries by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anton Sakalouski updated CAY-1068: ---------------------------------- Attachment: patch.txt refactored version of the same patch. > Add support for start index/offset of queries > --------------------------------------------- > > Key: CAY-1068 > URL: https://issues.apache.org/cayenne/browse/CAY-1068 > Project: Cayenne > Issue Type: Improvement > Components: Cayenne Core Library > Affects Versions: 3.0 > Reporter: Robert Zeigler > Assignee: Andrus Adamchik > Priority: Minor > Attachments: patch.txt, patch.txt > > > Cayenne already allows us to programatically set a query fetch limit. > It would be nice if we could also specify a fetch index/fetch offset into a query, to make it simple to fetch, eg, the 100th through the 150th results from the database. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
	[jira] Closed: (CAY-1068) Add support for start index/offset of queries by Cayenne - Dev mailing list :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message [ https://issues.apache.org/cayenne/browse/CAY-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrus Adamchik closed CAY-1068. -------------------------------- Resolution: Fixed Fix Version/s: 3.0 > Add support for start index/offset of queries > --------------------------------------------- > > Key: CAY-1068 > URL: https://issues.apache.org/cayenne/browse/CAY-1068 > Project: Cayenne > Issue Type: Improvement > Components: Cayenne Core Library > Affects Versions: 3.0 > Reporter: Robert Zeigler > Assignee: Andrus Adamchik > Priority: Minor > Fix For: 3.0 > > Attachments: patch.txt, patch.txt > > > Cayenne already allows us to programatically set a query fetch limit. > It would be nice if we could also specify a fetch index/fetch offset into a query, to make it simple to fetch, eg, the 100th through the 150th results from the database. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.