How can we improve the configuration of DocuWare?

Allow workflow global variables in SQL query to retreive external data.

I'm not sure if this is a formatting issue, a bug, or simply unavailable but when building a "where clause" in a workflow for assigning data from external data, I select a workflow global variable as the comparison but it always returns null.

Example: ENTRY_TYPE="PROJECT" and PROJECT_NAME=GV_gProject

However, if I simply replace "GV_gProject" with the actual hard coded string, the result is correct, so it the query is correct but the GV is not being placed into the query it would seem.

Because the wizard provides access to the global variables, this should function.

For the time being I have to write web services to perform the same queries and return the index data but would much rather have the entire process within the workflow design.

2 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Rex W. Walker shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Gilles Sauvagnat commented  ·   ·  Flag as inappropriate

    Try it using single quote for the global variable

    ENTRY_TYPE="PROJECT" and PROJECT_NAME='GV_gProject'

    Best regards

Feedback and Knowledge Base