Can Business Calculation compare strings like "like" in SQL?

Ask the Community
,
1

I would like to use the Business Calculation feature when creating a report and create a column that determines if a particular column contains a string that I specify.
Is this feasible?

Example)

■database: book

id name

1 book A
2 book B
3 book AB

■Business Calculation
・field label: contain A
・formula:
case(
When: book like ‘A’, then: ’true’,
else: ‘false’
)

id name containA

1 bookA true
2 bookB false
3 bookAB true

1 Like
2

Hi @iwakami,

For now we don’t have a plan to support like() function in the Business Calculation but we may consider supporting it with our AQL Expression.