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

                    Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

                    SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

                    은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현