phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Terrell <sterr...@oculus360.us>
Subject Re: Pagination with Phoenix
Date Wed, 17 Feb 2016 18:54:38 GMT
I was just thinking about this today.  I was going to try to implement it
by using a LIMIT <number of rows> on every query, with an addition of

  WHERE (rowkey_field_1 > last_rowkey_field_1_value_from_previous_query) OR
(rowkey_field_2 > last_rowkey_field_2_value_from_previous_query) OR …

But I haven't tried it yet.

On Wed, Feb 17, 2016 at 12:47 PM, Subramanyam Satyanarayana <
ssatyanarayana@metabiota.com> wrote:

> We have micro services built within Play  that generate Phoenix queries to
> serve RESTful requests. We are trying to figure a good way to implement
> pagination in the services.
>
> We were curious to know if there is any prescribed way of implementing
> either Row Keys ( to determine start & stop conditions for scan)  and/or
> indexes to help support this. Happy to share more details.
> —
> Regards,
>
> Subbu
>
> Manager, Platform Services
>
> Metabiota, Inc. (www.metabiota.com)
>
>
>
>
> *CONFIDENTIALITY NOTICE: The information contained in this electronic mail
> (email) transmission (including attachments), is intended by Metabiota for
> the use of the named individual or entity to which it is addressed and may
> contain information that is privileged or otherwise confidential. It is not
> intended for transmission to, or receipt by, any individual or entity other
> than the named addressee except as otherwise expressly permitted in this
> email transmission. If you have received this email in error, please delete
> it without copying or forwarding it, and notify the sender of the error by
> email reply.*
>

Mime
View raw message