WindmillWWindmill
Powered by
MarkyM
Windmill•12mo ago
Marky

Hot swap flow query for similar with additional arguement

I have a simple flow that calls a Postgres query, (with args) and then for branches from there.
I now want to replace the query with one that is very similar but has one additional argument.

I edited the query in YAML to replace the path for the sql script (which seems to save), but when I try to add the additional input transforms for the third argument, it keeps disappearing when i apply changes and go back and look at flow.

  modules:
    - id: b
      value:
        path: u/marky/ha_filtered
        type: script
        tag_override: null
        input_transforms:
          database:
            type: static
            value: $res:u/marky/sql
          hours:
            expr: flow_input.hours
            type: javascript
          voter:
            type: string
            value: ""
  modules:
    - id: b
      value:
        path: u/marky/ha_filtered
        type: script
        tag_override: null
        input_transforms:
          database:
            type: static
            value: $res:u/marky/sql
          hours:
            expr: flow_input.hours
            type: javascript
          voter:
            type: string
            value: ""


The "voter" is new with the new ha_filtered query that I want to apply to the query when running the flow. If I open the script, I can see it as an argument, but it refuses to save when I click "apply changes" in the edit yaml screen. I'm trying to just edit the flow without rebuilding it and breaking all the links by swapping out the script in the UI.

If I click in the flow on the step that runs the SQL query, the step input is like the old script and is missing the additional argument of the new one, if I edit the yaml again I see it's gone again. It does however seem to keep the correct link to the new sql script.

It's like it is hard coded with the interface of the previous sql script
image.png
WindmillJoin
3,388Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?
Recent Announcements
henri-c

We're live here https://discord.com/channels/930051556043276338/1278977038430240813

henri-c · 6d ago

rubenf

Infrastructure as code

rubenf · 4w ago

rubenf

As we're preparing for a new Windmill sandbox SDK, we took the opportunity **to open-source NSJAIL sandboxing** and make it available in CE and easier to set. In 1.634.0, just set nsjail to benefit from the tightest security and isolation per job. It's constraining so no need to use it unless you need but now you won't be restricted in security for CE if you need to.

rubenf · 4w ago

Similar Threads

for loop unresponsive in a flow
BravoBBravo / help
16mo ago
Execute a script for each flow run
DaanDDaan / help
16mo ago
Invalid flow failure while handling flow error
ShenanigansSShenanigans / help
10mo ago
Can Windmill flow have inputs as in `query` params instead of `body` ?
ym1198Yym1198 / help
3y ago