Problem with DQL Read Activity on Process Builder

Hi, am facing a problem with a DQL Read activity with a parameter, when I try to validate the following DQL query i get a error msg.

Query

select COUNT(*) from aa_xcp_aplicaciones where folder('/CORPORATIVOS/Finanzas y Administracion/Tecnologias de la Informacion/Catalogo/Hosting Application/?/Temp')

Error msg on the same "dql read" window

[DM_QUERY_E_SYNTAX]error :"A Parser Error (syntax error) has occurred in the vicinity of: select COUNT(*) from......[path]......./Hosting Application/'100000000.

Also i get an error while debugging

select COUNT(*) from aa_xcp_aplicaciones where folder('/CORPORATIVOS/Finanzas y Administracion/Tecnologias de la Informacion/Catalogo/Hosting Application/'TEST'/Temp')

the parameter is between quotes...

Thanks

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

DCTM_Guru

As a workaround, you could define the entire DQL query as process variable and pass it into DQL as single parameter instead of trying to insert string into existing string.

All comments

DCTM_Guru

Its enclosing your value in single quotes because you defined parameter type as string. Is the value string or integer? Instead of using ?, have you tried using <dmp:param> tags directly?

nicolas_espinoza

The value is String. I tried using the <dmp:param> but i also get the parameters betwen quotes..

DCTM_Guru

Please post screen shot of your activity configuration showing DQL

nicolas_espinoza

DQL screens:

Using <dmp:param>

Using ? for parameter

parameter setting:

Thanks

DCTM_Guru

As a workaround, you could define the entire DQL query as process variable and pass it into DQL as single parameter instead of trying to insert string into existing string.

Imran_Yusubov

I guess this is a bug why don't you report it to support?

nicolas_espinoza

@Johnny, thanks it works

@Imran, I also think it is a bug

Thanks!