How to create summary filters in a search expression in SuiteScript?

AI generated answer (using internal Slack threads):

To create summary filters in a search expression, you need to use the

search.createFilter()

method or filter expressions. However, keep in mind that summary filters don't work without at least one group summary column. Here is an example of how to create a summary filter using `search.createFilter()`:

javascript
search.createFilter({
    name: 'formulanumeric',
    formula: "CASE WHEN {task.custevent_taak_type.id} = 4 AND {task.status.id} != 'COMPLETE' THEN {task.internalid} ELSE null END",
    operator: 'is',
    values: "1",
    summary: search.Summary.COUNT,
})

And here is an example of a filter expression:

javascript
[
    "formulanumeric: CASE WHEN count(CASE WHEN {task.custevent_taak_type.id} = 4 AND {task.status.id} != 'COMPLETE' THEN {task.internalid} ELSE null END) = 3 THEN 1 ELSE 0 END",
    "is",
    "1",
]

If you are using a filter expression, make sure to place the count after the first CASE WHEN. If you are still encountering issues, you can load the search in code and log its filter expression. This can help you identify any discrepancies between your filter expression and the one that is actually being used. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******