How do I add a filter in OAC with a regexp_like condition?

Chethana Kumari-Oracle

Summary

I need to create a report in OAC by joining two tables based on regexp_like condition. How do I specify this in OAC?

Content

Hello,

I've two separate datasets pointing to two different tables (Merged_DS_Table and Operation_List) in OAC.

I've created a report in OAC by including both the datasets and this has auto-created join between the two datasets based on the common columns between them (cs_method and cs_uri). Below is the query, it has internally used for the join condition

select * from Merged_DS_Table a, Operation_List b where a.cs_method=b.cs_method and a.cs_uri = b.cs_uri;

My requirement is to join them using following query

select * from Merged_DS_Table a, Operation_List b where a.cs_method=b.cs_method and regexp_like(a.cs_uri,b.cs_uri);

How could I include this condition in OAC? Can I create a new calculation in my report using any in-built function provided by OAC, so that I could add it as a filter?

P.S - currently, in the prepare section, I've only used "cs_method" (Please see screenshot) for the join between the datasets

Please let me know.

Thanks in advance,

Chethana