There is a command similar to like SQL? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

There is a command similar to like SQL?

Received Response
21
Views
1
Comments

Summary

There is a command similar to like SQL?

Content

Hi everyone,

I in a report RTF I need to filter the data in a table, based on the content of the string.

For example, when the field "Competence" begins with "H."  insert the data in column.

Now i use this command:

<?choose:?><?when:contains(competence,'H.')?>

but, in this mode, not filter properly, because i view also when "Competence" contains "S.ACH."

There is a command similar to like SQL? or other solutions?

Thanks

Answers