Home > Forum > Actions > Add privileges action and filtering existing datasource

Add privileges action and filtering existing datasource

0

28.11.2023

15:59

Hi all!

I am currently struggling with 'Add privileges' action.

I want to use a predefined datasource (SQL query based on WFElements), this is shown under (1) in attached picture.

The datasource I am using selects all elements from a specific formtype and needs additional filtering in SQL query window (2).

But I am unable to do that, every attempt so far resulted in syntax error.

I am sure there is a trick (which is maybe undocumented), please help!

Thanks a lot in advance & best regards, Nik

28.11.2023

19:43

Hi Nik,

I did some test and as far as I can tell the following applies.
- If you use a SQL data source, than only the connection is used. The SQL query of the data source is ignored.
- If you use a BPS internal view, the SQL query in the action is ignored.

So your only approach would be to replicate the sql query in each action. If you have global automations you could place the action in global automation and use this in the different places.

Best regards,
Daniel

Solution (0)

Helpful (1)

Wrong answer (0)

04.12.2023

08:50

In reply to: Daniel Krüger (Cosmo Consult)

Hi Daniel!

The dialog and the options unfortunately are very misleading.

Thanks for the clarification & have a good day,

best regards, Nik

Solution (0)

Helpful (0)

Wrong answer (0)