There is a command similar to like SQL?

Dguglielmi

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

Sherry George

You need to use "starts-with" XSL function. Take a look here

https://blogs.oracle.com/xmlpublisher/entry/wildcards