Fix process form relations

Hello readers,

It could occur that the form relation with the process is gone and you cannot select it in the process anymore. This can be done by selecting "remove form" in the Activity Inspector of Process Builder. A quick way to fix this:

create dm_relation object set relation_name = 'dm_process_form', set parent_id = (select r_object_id from dm_process where object_name = '{process object name}'), set child_id = (select r_object_id from dm_xfm_form where object_name = '{task object name}'), set permanent_link = 1;

If you have multiple versions of a process or form please use the r_object_id's instead of the sub-queries.

Kind regards, Marcus

Fetch all Form Adaptor DQL queries by DQL (Forms Builder)

Hello readers,

This query is very nice to quickly look into all the DQL queries used in Form Adaptors made in Forms Builder.

select r_object_id, object_name as adaptor, title as description, param_value as dql
from dmc_xfm_adaptor_config where impl_class like '%DataSourceAdaptorService';

Kind regards, Marcus