Hi, we want to implement a toggle to activate/deactivate a step in oms by clicking a checkbox in bac

U01967XD72P

Hi, we want to implement a toggle to activate/deactivate a step in oms by clicking a checkbox in backoffice and save to database. In which table would you save this information? It’s just a boolean is_active true or false. Depending on this state the step in oms would be executed or not. Thanks in advance for your suggestens 🙂

U04FXCTCWPP

Maybe you could create a new table for similar changeable config settings (because if you're making one now, you'll probably be making more later, too). It could have:

id_setting (int, primary key)
name (varchar(255))
fk_type (foreign key to another table that's just a table of an id and a type column, listing anything you use, like 'bool', 'string', 'int', etc.)
value (varchar(255))

And there you can then conveniently store anything like this. This setting then could look like this:

1,'is_active',1,'true'

(in the other table of types, 1 would then obviously be the id for the 'bool' type)

U01967XD72P

Thanks for your answer! Sounds like a good idea

U04FXCTCWPP

You're welcome 👍