Checklist filter

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Karolina
    Junior Member
    • Sep 2020
    • 6

    Checklist filter

    I am currently trying to create a process that requires a function with filter by the checklist field.
    I didn't find any information in the documentation or here, so I am wondering is it at all possible to filter by the checklist type of the field? Would be extremely grateful for your help.
  • telecastg
    Active Community Member
    • Jun 2018
    • 907

    #2
    According to this post, the checklist field is searchable. https://forum.espocrm.com/forum/deve...4253#post54253 Haven't tried it myself but item is very knowledgeable so I trust his opinion

    Comment


    • item
      item commented
      Editing a comment
      Lolll telecastg, .."knowledgeable" humhum..
      i search and found 2 mismatch in code and have posted to yuri .. now my select manager work
      So i can now search more in depth
      checkList is so in database, ["A","C"]. ...
      i brainstorm : need to extract in array and make something in_array.. or make a groupBy with distinct id ?

      AdvancedPack report as "string" these kind of field .. sample
      1 record : ['A'] => count(1)
      1 record : ['A','B'] => count(1)
      2 record : ['C', 'D'] => count(2).
      1 record : ['C', 'D', 'E']. => count(1)

      what we will is :
      A => count(2)
      B => count(1)
      C => count(2)
      D => count(3)
      E => count(1)
      Last edited by item; 10-14-2020, 01:39 PM.
  • item
    Active Community Member
    • Mar 2017
    • 1476

    #3
    Not find
    Last edited by item; 10-14-2020, 01:42 PM.
    If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​

    Comment

    Working...