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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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