DanielYuHong How can I get data from DB Step(I am using Mysql btw). In runtime log it did log "The following query has read 4,079 records from the database into the process. The query was SELECT * FROM city". Then how can I access all these data from db.
Lukas Lieb Hi DanielYuHong To use the DB Step: Add a database configuration Add a DB Step element with e.g a "Read query" Map the record data to your data class https://developer.axonivy.com/doc/8.0/designer-guide/process-modeling/process-elements/db-step.html Kind regards Lukas
DanielYuHong Lukas Lieb I am expecting the return value would be a array or a list. Or I can access all those return rows by use record class?
Lukas Lieb Hi DanielYuHong There is also a getValues() method on the record object: https://developer.axonivy.com/doc/8.0/public-api/ch/ivyteam/ivy/scripting/objects/Record.html
DanielYuHong Lukas Lieb How can I input parameter to DB Step? I would like to construct a dynamic query?
Reguël Wermelinger You can setup a technical field with your filter before calling the DBStep. Then you can use this Dataclass field to write a query with filters. I've made a short Video, while setting up such a query:😊