Invalid attribute type












1















I'm getting a strange error after filtering through customerFactory.




Exception #0 (MagentoFrameworkExceptionLocalizedException): Invalid attribute name: is_active.




private function getCustomerDetails()

{

    $collection = $this->_customerFactory->create()->getCollection()

        ->addFieldToSelect('*')

        ->addAttributeToFilter('is_active', array('eq'=>'1'));

    return $collection->getSelect();

}


If I replace is_active with something else (e.g. lastname) then it works just fine. I googled a lot, but could not find a solution to this problem.



Any ideas :?






magento2 customer collection factory







share|improve this question

























  • I think you need addFieldToFilter(''is_active',1) I think this field don't EAV

    – Naumov
    Jul 6 '16 at 16:28
















1















I'm getting a strange error after filtering through customerFactory.




Exception #0 (MagentoFrameworkExceptionLocalizedException): Invalid attribute name: is_active.




private function getCustomerDetails()

{

    $collection = $this->_customerFactory->create()->getCollection()

        ->addFieldToSelect('*')

        ->addAttributeToFilter('is_active', array('eq'=>'1'));

    return $collection->getSelect();

}


If I replace is_active with something else (e.g. lastname) then it works just fine. I googled a lot, but could not find a solution to this problem.



Any ideas :?






magento2 customer collection factory







share|improve this question

























  • I think you need addFieldToFilter(''is_active',1) I think this field don't EAV

    – Naumov
    Jul 6 '16 at 16:28














1












1








1








I'm getting a strange error after filtering through customerFactory.




Exception #0 (MagentoFrameworkExceptionLocalizedException): Invalid attribute name: is_active.




private function getCustomerDetails()

{

    $collection = $this->_customerFactory->create()->getCollection()

        ->addFieldToSelect('*')

        ->addAttributeToFilter('is_active', array('eq'=>'1'));

    return $collection->getSelect();

}


If I replace is_active with something else (e.g. lastname) then it works just fine. I googled a lot, but could not find a solution to this problem.



Any ideas :?






magento2 customer collection factory







share|improve this question
















I'm getting a strange error after filtering through customerFactory.




Exception #0 (MagentoFrameworkExceptionLocalizedException): Invalid attribute name: is_active.




private function getCustomerDetails()

{

    $collection = $this->_customerFactory->create()->getCollection()

        ->addFieldToSelect('*')

        ->addAttributeToFilter('is_active', array('eq'=>'1'));

    return $collection->getSelect();

}


If I replace is_active with something else (e.g. lastname) then it works just fine. I googled a lot, but could not find a solution to this problem.



Any ideas :?






magento2 customer collection factory




magento2 customer collection factory






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jul 7 '16 at 6:17









Marius♦

164k28312662




164k28312662










asked Jul 6 '16 at 15:17









user3713377user3713377

489




489













  • I think you need addFieldToFilter(''is_active',1) I think this field don't EAV

    – Naumov
    Jul 6 '16 at 16:28



















  • I think you need addFieldToFilter(''is_active',1) I think this field don't EAV

    – Naumov
    Jul 6 '16 at 16:28

















I think you need addFieldToFilter(''is_active',1) I think this field don't EAV

– Naumov
Jul 6 '16 at 16:28





I think you need addFieldToFilter(''is_active',1) I think this field don't EAV

– Naumov
Jul 6 '16 at 16:28










2 Answers
2






active

oldest

votes


















0














You get an error because the is_active attribute does not exist for customers in Magento2.

There is a column is_active on the customer_entity table, but if you don't have an attribute with the same code and type static you cannot use that attribute for filtering.



To understand better what I'm saying here is an example.
There is a column called lastname in the customer_entity tablebut there is also an attribute with type static called lastname.

That's why filtering by lastname` works.

From my point of view, you just found a bug, or at least an inconsistency and you should report it here.






share|improve this answer































    0














    is_active is not an attribute which available to add to select, or filter.
    You are still able to have a workaround for this problem by:



    private function getCustomerDetails()
    
{
    
    $collection = $this->_customerFactory->create()->getCollection()
    
        ->addFieldToSelect('*');
    
    $collection->getSelect()->where('is_active = ?', 1);
    
    return $collection->getSelect();
    
}


    Hope this help






    share|improve this answer























      Your Answer








      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "479"
      };
      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: false,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: null,
      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%2fmagento.stackexchange.com%2fquestions%2f124528%2finvalid-attribute-type%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














      You get an error because the is_active attribute does not exist for customers in Magento2.

      There is a column is_active on the customer_entity table, but if you don't have an attribute with the same code and type static you cannot use that attribute for filtering.



      To understand better what I'm saying here is an example.
      There is a column called lastname in the customer_entity tablebut there is also an attribute with type static called lastname.

      That's why filtering by lastname` works.

      From my point of view, you just found a bug, or at least an inconsistency and you should report it here.






      share|improve this answer




























        0














        You get an error because the is_active attribute does not exist for customers in Magento2.

        There is a column is_active on the customer_entity table, but if you don't have an attribute with the same code and type static you cannot use that attribute for filtering.



        To understand better what I'm saying here is an example.
        There is a column called lastname in the customer_entity tablebut there is also an attribute with type static called lastname.

        That's why filtering by lastname` works.

        From my point of view, you just found a bug, or at least an inconsistency and you should report it here.






        share|improve this answer


























          0












          0








          0







          You get an error because the is_active attribute does not exist for customers in Magento2.

          There is a column is_active on the customer_entity table, but if you don't have an attribute with the same code and type static you cannot use that attribute for filtering.



          To understand better what I'm saying here is an example.
          There is a column called lastname in the customer_entity tablebut there is also an attribute with type static called lastname.

          That's why filtering by lastname` works.

          From my point of view, you just found a bug, or at least an inconsistency and you should report it here.






          share|improve this answer













          You get an error because the is_active attribute does not exist for customers in Magento2.

          There is a column is_active on the customer_entity table, but if you don't have an attribute with the same code and type static you cannot use that attribute for filtering.



          To understand better what I'm saying here is an example.
          There is a column called lastname in the customer_entity tablebut there is also an attribute with type static called lastname.

          That's why filtering by lastname` works.

          From my point of view, you just found a bug, or at least an inconsistency and you should report it here.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jul 7 '16 at 6:16









          Marius♦Marius

          164k28312662




          164k28312662

























              0














              is_active is not an attribute which available to add to select, or filter.
              You are still able to have a workaround for this problem by:



              private function getCustomerDetails()
              
{
              
    $collection = $this->_customerFactory->create()->getCollection()
              
        ->addFieldToSelect('*');
              
    $collection->getSelect()->where('is_active = ?', 1);
              
    return $collection->getSelect();
              
}


              Hope this help






              share|improve this answer




























                0














                is_active is not an attribute which available to add to select, or filter.
                You are still able to have a workaround for this problem by:



                private function getCustomerDetails()
                
{
                
    $collection = $this->_customerFactory->create()->getCollection()
                
        ->addFieldToSelect('*');
                
    $collection->getSelect()->where('is_active = ?', 1);
                
    return $collection->getSelect();
                
}


                Hope this help






                share|improve this answer


























                  0












                  0








                  0







                  is_active is not an attribute which available to add to select, or filter.
                  You are still able to have a workaround for this problem by:



                  private function getCustomerDetails()
                  
{
                  
    $collection = $this->_customerFactory->create()->getCollection()
                  
        ->addFieldToSelect('*');
                  
    $collection->getSelect()->where('is_active = ?', 1);
                  
    return $collection->getSelect();
                  
}


                  Hope this help






                  share|improve this answer













                  is_active is not an attribute which available to add to select, or filter.
                  You are still able to have a workaround for this problem by:



                  private function getCustomerDetails()
                  
{
                  
    $collection = $this->_customerFactory->create()->getCollection()
                  
        ->addFieldToSelect('*');
                  
    $collection->getSelect()->where('is_active = ?', 1);
                  
    return $collection->getSelect();
                  
}


                  Hope this help







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 2 days ago









                  Tuyen NguyenTuyen Nguyen

                  368110




                  368110






























                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Magento Stack Exchange!


                      • 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%2fmagento.stackexchange.com%2fquestions%2f124528%2finvalid-attribute-type%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

                      An IMO inspired problem

                      Image
                      14 4 This problem from IMO 1988 is said to be one of the most elegant ones in functional equations. Problem : The function $f$ is defined on the set of all positive integers as follows: begin{align} f(1) = 1, f(3) &= 3, f(2n) = f(n), \ f(4n+1) &= 2f(2n+1) - f(n), \ f(4n+3) &= 3 f(2n+1) - 2f(n) end{align} Find the number of $n$ with $f(n) = n, 1 leq n leq 1988$. The main idea towards the solution is realizing that these conditions stand for the fact that $f(n)$ just reverses the digits in the binary representation of the number $n$. So, essentially the solution is finding the number of binary pallindromes $leq 1988_{10}$. My question is the following : How to reformulate the problem so that $f(n)$ reverses the digits of $n$ in its ternary representation. Or even better, can we reformulate it for a
                      Read more

                      Management

                      Image
                      Management From Wikipedia, the free encyclopedia Jump to navigation Jump to search "Manager" redirects here. For other uses, see Management (disambiguation) and Manager (disambiguation). An organization chart for the United States Coast Guard shows the hierarchy of managerial roles in that organization. Business administration Management of a business Accounting Management accounting Financial accounting Financial audit Business entities Cooperative Corporation Limited liability company Partnership Sole proprietorship State-owned enterprise Corporate governance Annual general meeting Board of directors Supervisory board Advisory board Audit committee Corporate law Commercial law Constitutional documents Contract Corporate crime Corporate liability Insolvency law International trade law Mergers and acquisitions Economics Commodity Pu
                      Read more

                      Has there ever been an instance of an active nuclear power plant within or near a war zone?

                      Image
                      36 3 The question Has there ever been a military combat going on around an active (running or in outage but not decommissioned) commercial nuclear power plant? Or dangerously near it? If yes, how did the plant and its personnel fare in such situation? Why I ask Let's assume for the scope of this question modern commercial nuclear power plants (CANDU, PWR, BWR of generation II plus all of gen III and newer) are usually reasonably safe to operate given that the engineering has been done right and there is a whole cohort of very well trained personnel on-site at all times, well rested and with considerable resources on their hands. Things hard to get with an armed conflict like the recent Syrian war raging around. I can't seem to find any reference or a comprehensive article about this, hence this question.
                      Read more