locked
Getting records with offset RRS feed

  • Question

  • Hi all.
    I need to get data records with offset like this:
    SELECT * FROM my_table ORDER BY order_field ASC
    LIMIT 10, <offset_number>
    where <offset_number> is an index of the record to start from.

    I use RSSBus as transport and c# as back-end in my portal. As I see it is impossible to get offset in such way.
    I tried to use offset() or row_number() but got errors.

     Please show me the right way to do it.
     Thank you  for any help.

    Sunday, March 22, 2015 7:32 PM

All replies

  • The simplest way is probably to use a QueryExpression (rather than SQL), and use the PagingInfo to set the Count (number of records to return) and PageNumber to determine which records you receive

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Monday, March 23, 2015 2:27 PM
    Moderator
  • Thank you, that's what I need.

    I've got more detailed answer here : https://community.dynamics.com/crm/f/117/t/155740.aspx


    • Edited by Asgur Thursday, March 26, 2015 9:02 AM needless question post
    Wednesday, March 25, 2015 1:08 PM