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 :?










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 :?










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 :?










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






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









          MariusMarius

          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

                      1300-talet

                      1300-talet

                      Display a custom attribute below product name in the front-end Magento 1.9.3.8