Symptom
- How does the 'Like' rule work in filters for Tables/Tiles/Canvas/Story?
- How is the 'Like' rule different than 'Equal to' rule?
Environment
- SAP SuccessFactors HCM Suite
- Table/Ad-hoc
- Tiles/Dashboard
- Canvas/Detailed/Advanced
- Story/People Analytics
Resolution
Table/Tiles
Like rule works exactly like 'Equal to' rule, showing only the records that exactly match the value. One difference it that we can also add the '%' symbol to the prefix or suffix of the value to fetch all the matching entries.
As an example:
Column Name: Title
Results:
Test2020
Test2021
Test2022
Example2020
Example2021
Example2022
Filter: Title Like Test
Results:
Null
Filter: Title Like Test2020
Results:
Test2020
Filter: Title Like Test%
Results:
Test2020
Test2021
Test2022
Filter: Title Like %2020
Results:
Test2020
Example2020
Filter: Title Like %ample%
Results:
Example2020
Example2021
Example2022
Canvas
Like rule does not need any special symbols to fetch all the matching entries. It applies the formula automatically.
As an example:
Column Name: Title
Results:
Test2020
Test2021
Test2022
Example2020
Example2021
Example2022
Filter: Title Like Test
Results:
Test2020
Test2021
Test2022
Story
Similar behaviour to Table report, except the symbol used is either '*' or '?'. We also get the same message when using the Like rule:
Keywords
Table, Ad-hoc, Tiles, Dashboard, Canvas, Detailed, Advanced, Story, People Analytics, Like, Rule, Equal To, Symbols, %, *, ? , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , How To