Django: How do I combine a list and a queryset, paginate both of them and iterate through them in the template?How to combine 2 or more querysets in a Django view?How do I do a not equal in Django queryset filtering?django - convert a list back to a querysetHow to get the current URL within a Django template?How to concatenate strings in django templates?How to convert a Django QuerySet to a listHow to perform OR condition in django queryset?How do I find the duplicates in a list and create another list with them?Django - iterate number in for loop of a templateDjango multiple queryset combine into a pagination

What is monoid homomorphism exactly?

Is crescere the correct word meaning to to grow or cultivate?

What does のそ mean on this picture?

Can an Iranian citizen enter the USA on a Dutch passport?

Game artist computer workstation set-up – is this overkill?

Changing stroke width vertically but not horizontally in Inkscape

Why increasing of the temperature of the objects like wood, paper etc. doesn't fire them?

Which version of the Squat Nimbleness feat is correct?

What is the meaning of 「隣のおじいさんは言いました」

Huffman Code in C++

Hostile Divisor Numbers

What word describes the sound of an instrument based on the shape of the waveform of its sound?

Do Jedi mind tricks work on Ewoks?

What is more safe for browsing the web: PC or smartphone?

Debian 9 server no sshd in auth.log

How to say something covers all the view up to the horizon line?

Why would a military not separate its forces into different branches?

Playing Doublets with the Primes

Is throwing dice a stochastic or a deterministic process?

How to use awk to extract data from a file based on the content of another file?

How would you say "You forget wearing what you're wearing"?

What is a common way to tell if an academic is "above average," or outstanding in their field? Is their h-index (Hirsh index) one of them?

TIP120 Transistor + Solenoid Failing Randomly

When do British people use the word "cookie"?



Django: How do I combine a list and a queryset, paginate both of them and iterate through them in the template?


How to combine 2 or more querysets in a Django view?How do I do a not equal in Django queryset filtering?django - convert a list back to a querysetHow to get the current URL within a Django template?How to concatenate strings in django templates?How to convert a Django QuerySet to a listHow to perform OR condition in django queryset?How do I find the duplicates in a list and create another list with them?Django - iterate number in for loop of a templateDjango multiple queryset combine into a pagination






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








0















I'm finishing up my leader-board. I currently return the top 100 leaders for a given category. I need to attach the current rank to the results.



At first I tried the forloop.counter variable in the template, but since the results are paginated by 10 results at a time, each new page reset the counter.



 def leaderboard(request):
stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
rank = list(range(1, 101))
paginator = Paginator(stats, 10)
page = request.GET.get('page')
results = paginator.get_page(page)
context = 'results': results, 'rank': rank


currently returning wrong rank on page 2,3 etc










share|improve this question




























    0















    I'm finishing up my leader-board. I currently return the top 100 leaders for a given category. I need to attach the current rank to the results.



    At first I tried the forloop.counter variable in the template, but since the results are paginated by 10 results at a time, each new page reset the counter.



     def leaderboard(request):
    stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
    rank = list(range(1, 101))
    paginator = Paginator(stats, 10)
    page = request.GET.get('page')
    results = paginator.get_page(page)
    context = 'results': results, 'rank': rank


    currently returning wrong rank on page 2,3 etc










    share|improve this question
























      0












      0








      0








      I'm finishing up my leader-board. I currently return the top 100 leaders for a given category. I need to attach the current rank to the results.



      At first I tried the forloop.counter variable in the template, but since the results are paginated by 10 results at a time, each new page reset the counter.



       def leaderboard(request):
      stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
      rank = list(range(1, 101))
      paginator = Paginator(stats, 10)
      page = request.GET.get('page')
      results = paginator.get_page(page)
      context = 'results': results, 'rank': rank


      currently returning wrong rank on page 2,3 etc










      share|improve this question














      I'm finishing up my leader-board. I currently return the top 100 leaders for a given category. I need to attach the current rank to the results.



      At first I tried the forloop.counter variable in the template, but since the results are paginated by 10 results at a time, each new page reset the counter.



       def leaderboard(request):
      stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
      rank = list(range(1, 101))
      paginator = Paginator(stats, 10)
      page = request.GET.get('page')
      results = paginator.get_page(page)
      context = 'results': results, 'rank': rank


      currently returning wrong rank on page 2,3 etc







      django list templates pagination django-queryset






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 23 at 4:48









      crappy_hackercrappy_hacker

      414




      414






















          1 Answer
          1






          active

          oldest

          votes


















          0














          The answer wasn't that hard: I just used zip to combine the list and queryset. For the pagination I just repeated the same paginate steps for the rank that I used for the queryset with new variable names. Finally, I iterated through the zipped variable in the template:



           def leaderboard(request):
          stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
          rank = list(range(1, 101))
          paginator = Paginator(stats, 10)
          page = request.GET.get('page')
          stats = paginator.get_page(page)

          paginator2 = Paginator(rank, 10)
          page2 = request.GET.get('page')
          rank = paginator2.get_page(page2)

          rank_and_query = zip(rank, stats)
          context = 'rank_and_query': rank_and_query


           % for rank,stats in rank_and_query %
          <li> rank : stats.leader </li>
          % endfor %





          share|improve this answer























            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%2f55310704%2fdjango-how-do-i-combine-a-list-and-a-queryset-paginate-both-of-them-and-iterat%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









            0














            The answer wasn't that hard: I just used zip to combine the list and queryset. For the pagination I just repeated the same paginate steps for the rank that I used for the queryset with new variable names. Finally, I iterated through the zipped variable in the template:



             def leaderboard(request):
            stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
            rank = list(range(1, 101))
            paginator = Paginator(stats, 10)
            page = request.GET.get('page')
            stats = paginator.get_page(page)

            paginator2 = Paginator(rank, 10)
            page2 = request.GET.get('page')
            rank = paginator2.get_page(page2)

            rank_and_query = zip(rank, stats)
            context = 'rank_and_query': rank_and_query


             % for rank,stats in rank_and_query %
            <li> rank : stats.leader </li>
            % endfor %





            share|improve this answer



























              0














              The answer wasn't that hard: I just used zip to combine the list and queryset. For the pagination I just repeated the same paginate steps for the rank that I used for the queryset with new variable names. Finally, I iterated through the zipped variable in the template:



               def leaderboard(request):
              stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
              rank = list(range(1, 101))
              paginator = Paginator(stats, 10)
              page = request.GET.get('page')
              stats = paginator.get_page(page)

              paginator2 = Paginator(rank, 10)
              page2 = request.GET.get('page')
              rank = paginator2.get_page(page2)

              rank_and_query = zip(rank, stats)
              context = 'rank_and_query': rank_and_query


               % for rank,stats in rank_and_query %
              <li> rank : stats.leader </li>
              % endfor %





              share|improve this answer

























                0












                0








                0







                The answer wasn't that hard: I just used zip to combine the list and queryset. For the pagination I just repeated the same paginate steps for the rank that I used for the queryset with new variable names. Finally, I iterated through the zipped variable in the template:



                 def leaderboard(request):
                stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
                rank = list(range(1, 101))
                paginator = Paginator(stats, 10)
                page = request.GET.get('page')
                stats = paginator.get_page(page)

                paginator2 = Paginator(rank, 10)
                page2 = request.GET.get('page')
                rank = paginator2.get_page(page2)

                rank_and_query = zip(rank, stats)
                context = 'rank_and_query': rank_and_query


                 % for rank,stats in rank_and_query %
                <li> rank : stats.leader </li>
                % endfor %





                share|improve this answer













                The answer wasn't that hard: I just used zip to combine the list and queryset. For the pagination I just repeated the same paginate steps for the rank that I used for the queryset with new variable names. Finally, I iterated through the zipped variable in the template:



                 def leaderboard(request):
                stats = Leaderboard.objects.all().order_by('-most_hits')[:100]
                rank = list(range(1, 101))
                paginator = Paginator(stats, 10)
                page = request.GET.get('page')
                stats = paginator.get_page(page)

                paginator2 = Paginator(rank, 10)
                page2 = request.GET.get('page')
                rank = paginator2.get_page(page2)

                rank_and_query = zip(rank, stats)
                context = 'rank_and_query': rank_and_query


                 % for rank,stats in rank_and_query %
                <li> rank : stats.leader </li>
                % endfor %






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Mar 23 at 5:10









                crappy_hackercrappy_hacker

                414




                414





























                    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%2f55310704%2fdjango-how-do-i-combine-a-list-and-a-queryset-paginate-both-of-them-and-iterat%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

                    How to preserve electronics (computers, tablets and phones) for hundreds of years Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) The network's official Twitter account is up and running again. What content…How might modern humans leave a message for 50,000 years?How would an aquatic race develop computers?How do we make computers care for human life?Keeping supplies for 1000 yearsWhat will cell phones become in 100 years?What body armor protects against a laser?Could a society attain 1800s technology if limited to using copper and bronze?Electricity power (magic) and electronicsScavenging metal resources in post-apocalypse after 100 yearsWhy would precursors create devices that can survive and still work after hundreds of years?

                    155 수학 과학 기타 둘러보기 메뉴eh추가해eh문서를 완성해

                    Convert JSON to MapSimplest way to convert a string representing JSON array into Java array List of key value pairsHow to take String JSON values into HashMapConvert a JSON String to a HashMapCreating BSON object from JSON stringJSONObject - How to get a value ?Better Map ConstructorReading JSON from Url javaUpdate columns if input values are not null otherwise ignore and keep the existing values of column in databaseHow to store object represented as Json string into Couchbase Lite?Go JSON into MapHow do I efficiently iterate over each entry in a Java Map?Sort a Map<Key, Value> by valuesHow to round a number to n decimal places in JavaCan comments be used in JSON?How do I read / convert an InputStream into a String in Java?How can I pretty-print JSON in a shell script?What is the correct JSON content type?How can I deserialize JSON to a simple Dictionary<string,string> in ASP.NET?Why does Google prepend while(1); to their JSON responses?Parse JSON in JavaScript?