Report Entity Category

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mkhalifa
    Member
    • Jan 2019
    • 48

    Report Entity Category


    At the time of creating a report I do not find the entity product Category ! EspoCrm Version 5.5.6

  • yuri
    Member
    • Mar 2014
    • 8440

    #2
    Product Category is not supported in reports.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • mkhalifa
      Member
      • Jan 2019
      • 48

      #3
      Thanks for you replay !

      Do you think it will be available in future versions.
      Do you think it's easy to change the product and product relationship from one to many to may to may?

      Comment

      • yuri
        Member
        • Mar 2014
        • 8440

        #4
        You can try to create custom/Espo/Custom/Resources/metadata/scopes/ProductCategory.json

        {
        "object": true
        }

        and clear cache.

        But there is no reason to have Product Category entity in reports.

        > Do you think it's easy to change the product and product relationship from one to many to may to may?
        It's not very easy

        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        • mkhalifa
          Member
          • Jan 2019
          • 48

          #5
          Thanks for you replay !

          OK for the category report I will try to do otherwise:

          I added a new relationship between May and May between product and product category. this has narrowed down the productcategories field that I added in the product view without any problem. Then I created a grid report on the article quote entity. In the group by I can put product.category but I can not put product.productCategories the field added in specific would not appear

          Comment

          • yuri
            Member
            • Mar 2014
            • 8440

            #6
            Group By is possible only by belongs-to relationship. Has-many is not supported.
            If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

            Comment

            Working...