Firebase Database Query-get previous 20 key before specific key?












-1















I'm trying to do pagination. I want to get previous 20 key before my specific key.



For example:



enter image description here



When i say last key i mean its last key in my array list.Its not the last key of my databse.










share|improve this question





























    -1















    I'm trying to do pagination. I want to get previous 20 key before my specific key.



    For example:



    enter image description here



    When i say last key i mean its last key in my array list.Its not the last key of my databse.










    share|improve this question



























      -1












      -1








      -1








      I'm trying to do pagination. I want to get previous 20 key before my specific key.



      For example:



      enter image description here



      When i say last key i mean its last key in my array list.Its not the last key of my databse.










      share|improve this question
















      I'm trying to do pagination. I want to get previous 20 key before my specific key.



      For example:



      enter image description here



      When i say last key i mean its last key in my array list.Its not the last key of my databse.







      firebase firebase-realtime-database






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 1 at 7:55







      UzaySan

















      asked Jan 1 at 7:49









      UzaySanUzaySan

      858




      858
























          1 Answer
          1






          active

          oldest

          votes


















          2














          If you have the specific key you can query the previous keys like this in javascript:



          db.ref("YOUR parent node name").orderByKey().endAt("THE LAST KEY").limitToLast(20).once('value)


          You can easily translate this code to any platform you are using.






          share|improve this answer
























          • It doesnt work "reference.orderByKey().endAt(list.get(list.size()-1)).limitToLast(30);" this is my code but still same

            – UzaySan
            Jan 1 at 8:52











          • please add the complete code in your question where you are getting the data. What does list contains ?

            – Umar Hussain
            Jan 1 at 8:58











          • Its my bad.your code is working fine

            – UzaySan
            Jan 1 at 9:34











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53993865%2ffirebase-database-query-get-previous-20-key-before-specific-key%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          2














          If you have the specific key you can query the previous keys like this in javascript:



          db.ref("YOUR parent node name").orderByKey().endAt("THE LAST KEY").limitToLast(20).once('value)


          You can easily translate this code to any platform you are using.






          share|improve this answer
























          • It doesnt work "reference.orderByKey().endAt(list.get(list.size()-1)).limitToLast(30);" this is my code but still same

            – UzaySan
            Jan 1 at 8:52











          • please add the complete code in your question where you are getting the data. What does list contains ?

            – Umar Hussain
            Jan 1 at 8:58











          • Its my bad.your code is working fine

            – UzaySan
            Jan 1 at 9:34
















          2














          If you have the specific key you can query the previous keys like this in javascript:



          db.ref("YOUR parent node name").orderByKey().endAt("THE LAST KEY").limitToLast(20).once('value)


          You can easily translate this code to any platform you are using.






          share|improve this answer
























          • It doesnt work "reference.orderByKey().endAt(list.get(list.size()-1)).limitToLast(30);" this is my code but still same

            – UzaySan
            Jan 1 at 8:52











          • please add the complete code in your question where you are getting the data. What does list contains ?

            – Umar Hussain
            Jan 1 at 8:58











          • Its my bad.your code is working fine

            – UzaySan
            Jan 1 at 9:34














          2












          2








          2







          If you have the specific key you can query the previous keys like this in javascript:



          db.ref("YOUR parent node name").orderByKey().endAt("THE LAST KEY").limitToLast(20).once('value)


          You can easily translate this code to any platform you are using.






          share|improve this answer













          If you have the specific key you can query the previous keys like this in javascript:



          db.ref("YOUR parent node name").orderByKey().endAt("THE LAST KEY").limitToLast(20).once('value)


          You can easily translate this code to any platform you are using.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jan 1 at 8:18









          Umar HussainUmar Hussain

          2,0651718




          2,0651718













          • It doesnt work "reference.orderByKey().endAt(list.get(list.size()-1)).limitToLast(30);" this is my code but still same

            – UzaySan
            Jan 1 at 8:52











          • please add the complete code in your question where you are getting the data. What does list contains ?

            – Umar Hussain
            Jan 1 at 8:58











          • Its my bad.your code is working fine

            – UzaySan
            Jan 1 at 9:34



















          • It doesnt work "reference.orderByKey().endAt(list.get(list.size()-1)).limitToLast(30);" this is my code but still same

            – UzaySan
            Jan 1 at 8:52











          • please add the complete code in your question where you are getting the data. What does list contains ?

            – Umar Hussain
            Jan 1 at 8:58











          • Its my bad.your code is working fine

            – UzaySan
            Jan 1 at 9:34

















          It doesnt work "reference.orderByKey().endAt(list.get(list.size()-1)).limitToLast(30);" this is my code but still same

          – UzaySan
          Jan 1 at 8:52





          It doesnt work "reference.orderByKey().endAt(list.get(list.size()-1)).limitToLast(30);" this is my code but still same

          – UzaySan
          Jan 1 at 8:52













          please add the complete code in your question where you are getting the data. What does list contains ?

          – Umar Hussain
          Jan 1 at 8:58





          please add the complete code in your question where you are getting the data. What does list contains ?

          – Umar Hussain
          Jan 1 at 8:58













          Its my bad.your code is working fine

          – UzaySan
          Jan 1 at 9:34





          Its my bad.your code is working fine

          – UzaySan
          Jan 1 at 9:34




















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53993865%2ffirebase-database-query-get-previous-20-key-before-specific-key%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Monofisismo

          Angular Downloading a file using contenturl with Basic Authentication

          Olmecas