Activity Forums Salesforce® Discussions What is offset in SOQL query in salesforce ?

  • What is offset in SOQL query in salesforce ?

    Posted by Ayush on July 23, 2020 at 11:41 am

    <div jsname="ARU61" aria-controls="_LXcZX_71No_iz7sP6pijyAM1" aria-expanded="true" id="_LXcZX_71No_iz7sP6pijyAM2" jsslot="" role="button" tabindex="0" jsaction="CQwlrf;fastbutton:CQwlrf"><div jsname="xXq91c" data-kt="Kiz5yO3V5cO2jWH3lerY1cDgQ4ug7o2jjojfH8qEj8TyvaOsKeKlhpfJt_j_CQ" data-hveid="CAEQAQ" data-ved="2ahUKEwi-wKCWpePqAhUP8XMBHWrMCDkQuk4oAHoECAEQAQ"><div jsname="dcydfb" aria-labelledby="_LXcZX_71No_iz7sP6pijyAM2" id="_LXcZX_71No_iz7sP6pijyAM1" jsslot="" jsaction="CQwlrf;fastbutton:CQwlrf"><div jsname="oQYOj" data-hveid="CAEQAg" data-ved="2ahUKEwi-wKCWpePqAhUP8XMBHWrMCDkQu04oAXoECAEQAg"><div data-md="61">
    </div></div></div></div></div>

    Kirandeep replied 4 years, 4 months ago 3 Members · 2 Replies
  • 2 Replies
  • Anuj

    Member
    July 23, 2020 at 1:04 pm

    OFFSET. When expecting many records in a query's results, you can display the results in multiple pages by using the OFFSET clause on a SOQL query. For example, you can use OFFSET to display records 51–75 and then jump to displaying records 301–350. Using OFFSET is an efficient way to handle large results sets.

  • Kirandeep

    Member
    July 23, 2020 at 2:59 pm
    • OFFSET clause can be used to implement pagination in visualforce page tables.
    • OFFSET is applied to the result set returned at the time of the query

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos