HV

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.

by Helmut Barro
Posted on Wed, 11/24/2021 - 13:34

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.

0
by Harm Verschuren Author
Posted on Thu, 11/25/2021 - 17:23

In reply to by HEBA

Dear Helmut, Thank you for helping out. I'll give it a try. Do you also know where to find reference documentation and examples? TIA.

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • Profile picture for user frankweise
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock