Workflow Soluiton

 View Only

Workflow Integration - Maria DB Parameters?

  • 1.  Workflow Integration - Maria DB Parameters?

    Posted Jan 31, 2022 10:32 AM
    Hi All,

    I'm currently putting together workflow which needs to go an run a query from a database where it looks up an ID against the description to them populate back into the running Workflow.

    I'm in the Integration component which I have setup running queries fine but this is first one I've setup that needs to be passed a parameter. 

    I'm using an ODBC connection and in the query I have its simply:

    Select Description from Summary
    Where ID = ?summaryid

    When I trying to run this Maria DB is complaining about the ? which suggest that its not right.  Other posts for Maria DB have shown you use an @ but if I change my query the find parameters doesn't find it.

    Does anyone know how to get this working?

    Thanks in advance :)​