Announcement

Collapse
No announcement yet.

Checklist filter

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #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, 02:39 PM.

  • #3
    Not find
    Last edited by item; 10-14-2020, 02:42 PM.

    Comment

    Working...
    X