Skip to Content

Modifing Attribute before writing it into the database

Hi Folks,

I have a little problem with modification attributes before inserting them into the database.

I am currently creating a process to write my own scheduling rules in IDM 8.0 and

automatically inserting them into the tables mc_sched_rule and mc_sched_item.

Now I want to format a time e.g. 8:00 in seconds and write it like 28.800 (seconds after midnight).

But I need to convert it before the to database pass executes, else I'm getting an error.


Attribute --> Value 8:00 --> Convert it to 28.800 (seconds after midnight) --> Execute to database pass (writing it into the database).

I hope, that I made my question clear.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 15, 2018 at 12:48 PM

    Hello Berkay,

    couldn't you just work with another attribute for this. The first attribut to save the time. And then another pass, that converts the content of that attribute into your 28.800 seconds (for example), saves it in a second attribute and then writes it into the database.

    So one pass "to Identity store" and one "to Database".


    Or am I missing something here?




    Add comment
    10|10000 characters needed characters exceeded