Hey Guys, is it possible to add a filter to a save...
# suiteanalyticsy
Yadigar
09/26/2018, 7:12 AMHey Guys, is it possible to add a filter to a saved search based on message text? for example I want to filter all messages with Free word inside them. Thanks in advance.
t
TJ Cornelius
09/26/2018, 2:07 PM@Yadigar did you try Message contains Free?
TJ Cornelius
09/26/2018, 2:10 PM@Yadigar you could also try Formula(text) where formula is LOWER({message}) contains free.
TJ Cornelius
09/26/2018, 2:13 PM@Yadigar I just realized you're talking about filter and not criteria... I'll let you know if I come across anything
y
Yadigar
09/26/2018, 2:21 PM@TJ Cornelius Thanks again, as you can see I'm raising questions which I cannot solve by WF or Implementation (I should get skilled with SuiteScript 😉)
t
TJ Cornelius
09/26/2018, 2:41 PM@Yadigar I figured out how to make it work...
1. Add Formula(text) line to your criteria. In the formula box put LOWER({message}). Then select "contains" and just put a space for what it should contain. That will allow you to save that criteria line. At this point previewing the search will give you all results.
2. Add a Formula(text) line to your filter section. Label it something like "Message Contains."
3. Preview (or save) your search, and you can type "free" in the "Message Contains" box. When you click out of the box, it will only show results where message contains "free"
y
Yadigar
09/26/2018, 3:42 PM@TJ Cornelius AWESOME! it seems to work well, I will remember that approach.
Yadigar
09/26/2018, 3:42 PM@TJ Cornelius Thanks!