Is it possible to apply filters on a model inside a view in Ruby on Rails?












0














Is it possible to apply filters on a model inside a view's code:



I use axlsx to generate Excel and I tried something like this inside my myview.xlsx.axlsx file:



fs = MyModel.where(:Column1 => v1, :Column2 => v2)

puts fs[0].Column1


I got an error 



undefined method Column1 for nil:NilClass


I am pretty sure there's nothing wrong with my filter so I wonder is it legal to have such a filter inside a view (and if such filters should only be placed inside a controller instead)?






ruby-on-rails axlsx







share|improve this question





























    0














    Is it possible to apply filters on a model inside a view's code:



    I use axlsx to generate Excel and I tried something like this inside my myview.xlsx.axlsx file:



    fs = MyModel.where(:Column1 => v1, :Column2 => v2)
    
puts fs[0].Column1


    I got an error 



    undefined method Column1 for nil:NilClass


    I am pretty sure there's nothing wrong with my filter so I wonder is it legal to have such a filter inside a view (and if such filters should only be placed inside a controller instead)?






    ruby-on-rails axlsx







    share|improve this question



























      0












      0








      0







      Is it possible to apply filters on a model inside a view's code:



      I use axlsx to generate Excel and I tried something like this inside my myview.xlsx.axlsx file:



      fs = MyModel.where(:Column1 => v1, :Column2 => v2)
      
puts fs[0].Column1


      I got an error 



      undefined method Column1 for nil:NilClass


      I am pretty sure there's nothing wrong with my filter so I wonder is it legal to have such a filter inside a view (and if such filters should only be placed inside a controller instead)?






      ruby-on-rails axlsx







      share|improve this question















      Is it possible to apply filters on a model inside a view's code:



      I use axlsx to generate Excel and I tried something like this inside my myview.xlsx.axlsx file:



      fs = MyModel.where(:Column1 => v1, :Column2 => v2)
      
puts fs[0].Column1


      I got an error 



      undefined method Column1 for nil:NilClass


      I am pretty sure there's nothing wrong with my filter so I wonder is it legal to have such a filter inside a view (and if such filters should only be placed inside a controller instead)?






      ruby-on-rails axlsx




      ruby-on-rails axlsx






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 17 hours ago









      ray

      895113




      895113










      asked 17 hours ago









      Biju

      928




      928
























          2 Answers
          2






          active

          oldest

          votes


















          0














          It's legal, yet not advisable to use queries in the view. It's better to move them to a controller and even better to wrap them in a method inside the model.



          In your case it looks that the query returns an empty collection, and that's why fs[0] is nil and you cannot call a method on it.






          share|improve this answer





























            2














            You can have such code in views, although you should try to avoid having logic in the view and move it to the controller or a helper. The problem here is that the active record relation is empty:



            fs = MyModel.where(:Column1 => v1, :Column2 => v2) #=> #<ActiveRecord::Relation >
            
fs[0] #=> nil


            You can use try to avoid that an exception is raised if the relation is empty and return nil instead:



            fs[0].try(:Column1) #=> nil





            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%2f53942970%2fis-it-possible-to-apply-filters-on-a-model-inside-a-view-in-ruby-on-rails%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              0














              It's legal, yet not advisable to use queries in the view. It's better to move them to a controller and even better to wrap them in a method inside the model.



              In your case it looks that the query returns an empty collection, and that's why fs[0] is nil and you cannot call a method on it.






              share|improve this answer


























                0














                It's legal, yet not advisable to use queries in the view. It's better to move them to a controller and even better to wrap them in a method inside the model.



                In your case it looks that the query returns an empty collection, and that's why fs[0] is nil and you cannot call a method on it.






                share|improve this answer
























                  0












                  0








                  0






                  It's legal, yet not advisable to use queries in the view. It's better to move them to a controller and even better to wrap them in a method inside the model.



                  In your case it looks that the query returns an empty collection, and that's why fs[0] is nil and you cannot call a method on it.






                  share|improve this answer












                  It's legal, yet not advisable to use queries in the view. It's better to move them to a controller and even better to wrap them in a method inside the model.



                  In your case it looks that the query returns an empty collection, and that's why fs[0] is nil and you cannot call a method on it.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 17 hours ago









                  mrzasa

                  8,307103878




                  8,307103878

























                      2














                      You can have such code in views, although you should try to avoid having logic in the view and move it to the controller or a helper. The problem here is that the active record relation is empty:



                      fs = MyModel.where(:Column1 => v1, :Column2 => v2) #=> #<ActiveRecord::Relation >
                      
fs[0] #=> nil


                      You can use try to avoid that an exception is raised if the relation is empty and return nil instead:



                      fs[0].try(:Column1) #=> nil





                      share|improve this answer




























                        2














                        You can have such code in views, although you should try to avoid having logic in the view and move it to the controller or a helper. The problem here is that the active record relation is empty:



                        fs = MyModel.where(:Column1 => v1, :Column2 => v2) #=> #<ActiveRecord::Relation >
                        
fs[0] #=> nil


                        You can use try to avoid that an exception is raised if the relation is empty and return nil instead:



                        fs[0].try(:Column1) #=> nil





                        share|improve this answer


























                          2












                          2








                          2






                          You can have such code in views, although you should try to avoid having logic in the view and move it to the controller or a helper. The problem here is that the active record relation is empty:



                          fs = MyModel.where(:Column1 => v1, :Column2 => v2) #=> #<ActiveRecord::Relation >
                          
fs[0] #=> nil


                          You can use try to avoid that an exception is raised if the relation is empty and return nil instead:



                          fs[0].try(:Column1) #=> nil





                          share|improve this answer














                          You can have such code in views, although you should try to avoid having logic in the view and move it to the controller or a helper. The problem here is that the active record relation is empty:



                          fs = MyModel.where(:Column1 => v1, :Column2 => v2) #=> #<ActiveRecord::Relation >
                          
fs[0] #=> nil


                          You can use try to avoid that an exception is raised if the relation is empty and return nil instead:



                          fs[0].try(:Column1) #=> nil






                          share|improve this answer














                          share|improve this answer



                          share|improve this answer








                          edited 12 hours ago

























                          answered 17 hours ago









                          Ana María Martínez Gómez

                          1,184521




                          1,184521






























                              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.





                              Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                              Please pay close attention to the following guidance:


                              • 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%2f53942970%2fis-it-possible-to-apply-filters-on-a-model-inside-a-view-in-ruby-on-rails%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

                              Image
                              Monofisismo (do grego: monos - "único, singular" e physis - "natureza") é o ponto de vista cristológico que defende que, depois da união do divino e do humano na encarnação histórica, Jesus Cristo, como encarnação do Filho ou Verbo ( Logos ) de Deus, teria apenas uma única "natureza", a divina, e não uma síntese de ambas. O monofisismo é contraposto pelo diofisismo (ou "diafisismo"), que defende que Jesus preservou em si as duas naturezas. Historicamente, o monofisismo se refere primordialmente à posição dos que (especialmente no Egito e, em menor grau, na Síria) rejeitaram as decisões do Concílio de Calcedônia em 451 (o quarto concílio ecumênico). Os membros mais moderados entre eles, porém, defendem a teologia "miafisita", que se tornou a oficial para as Igrejas Ortodoxas Orientais. Muitos ortodoxos orientais, porém, rejeitam essa classificação, mesmo como um termo genérico, mas ele é amplamente utilizado na literatura históri...
                              Read more

                              Angular Downloading a file using contenturl with Basic Authentication

                              Image
                              0 I have a contentUrl when user clicks on that,file should be downloaded. If I try to browse the contentUrl in the browser it asks for Userid and password.I believe this is Basic Authentication.I dont want user to enter UserId and Password so I am passing it Authorization(Please see below code). Url looks some thing like this: http://XXX.XXX.XX.XXX:8080/flowable-rest/service/runtime/tasks/90875/attachments/90555/content let username : string = 'admin'; let pwd : string = 'test'; let headers = new Headers(); headers.set('Accept', 'text/json'); headers.append('Content-Type', 'application/json'); headers.set('Access-Control-Allow-Origin', '*'); headers.set('Access-Control-Allow-Methods','POST, GET, OPTIONS, PUT, DELETE'); head...
                              Read more

                              Olmecas

                              Image
                              Monumento 1, uma das quatro cabeças colossais encontradas em La Venta, com altura aproximada de 3 metros Olmecas é a designação do povo e da civilização que estiveram na origem da antiga cultura pré-colombiana da Mesoamérica e que se desenvolveram nas regiões tropicais do centro-sul do atual México durante o pré-clássico, próximo de onde hoje estão localizados os estados mexicanos de Veracruz e Tabasco, no Istmo de Tehuantepec, numa zona designada área nuclear olmeca. A cultura olmeca floresceu nesta região aproximadamente entre 1500 e 400 a.C., [ 1 ] e crê-se que tenha sido a civilização-mãe de todas as civilizações mesoamericanas que se desenvolveram posteriormente. [ 2 ] No entanto, desconhece-se a sua exacta filiação étnica, ainda que existam numerosas hipóteses colocadas para tentar resolver esta questão. O etnónimo olmeca foi cunhado pelos arqueólogos do século XX, e não devem confundir-se com os muito posteriores olmecas-xicalancas que ocuparam vários locais do México...
                              Read more