Filter field where value contain word

Follow

Miguel Filho

August 21, 2020 00:22

I want to know if there is any kind of way that allows me to filter a field based on "contains word" criteria.

 

Example: My cube has a fild with a thousand of products name.

I want to filter all products that contains the word "black" on its name.

 

It would be simmilar to the *like* function in SQL. product_name like '%black%'

 

Edit: Just to make clear, I need this funcionality to be available for all the users

1

• 

  Barry Gaffey August 21, 2020 15:34 (Edited August 21, 2020 15:40)

  Miguel Filho

  Absolutely, you can set such a thing as a filter on a dashboard, widget, or formula on any dashboard
  
  

  JAQL syntax

  {
  "contains": "mm"
  }

   

  You can also use 'like' just as you described e.g.

  

  {
  "like": "%black%"
  }

   

  1

  Comment actions Permalink
• 

  Miguel Filho August 21, 2020 19:45

  Thanks so much Barry Gaffey , it is actually easier than I tought. (:

  1

  Comment actions Permalink

Please sign in to leave a comment.