Dear all,
I am struggling with RAQL while creating data feeds in ARIS Connect. I assume that RAQL allows to create a (non-standard?) query, however I cannot find any reference documentation. Can anyone help and share a reference document, examples or how-to use RAQL please?
My use case for trying to use RAQL is join (combine) 2 data feeds based on a complex text match. I was unable to do this in the provided building blocks (or am I?).
Simplified example:
Data_feed1.name contains a business process name. Data_feed2.description contains long text witch might include a process name. The goal is to find the matching process names from both data_feeds. In pseudo-SQL:
select *
from data_feed1, data_feed2
where data_feed1.name is part of data_feed2.description
When using Oracle or MySQL, the "is part of" would translate to the INSTR() function. However, RAQL doesn't know INSTR.
Thanks for helping out.
RAQL can do a regex matching for such use cases. An example would be (using your pseudo-sql from above):
SELECT * FROM data_feed1 INNER JOIN data_feed2 WHERE matches(data_feed2.description, data_feed1.name)
This should return rows for matches as you require. Please give it a try.
The official documentation can be found here:
https://documentation.softwareag.com/mashzone_nextgen/jbp10-11/webhelp/index.htm#307660.htm