Sequencing in MDO

[raj44]

Hi Everyone,

Does MDO has any ID property similar to transactionid function in MII that gets incremented after each execution cycle? We are inserting the data in MDO and would like to have one column as ID which contains value such as 1 to refer to first insertion, 2 to refer to 2nd insertion and so on...How can we achieve this using MDOs?

Thanks,

Rajeev

[raj44 · Accepted solution]

Thanks for your inputs

Actually, the sequencing can be implemented by using a persistent variable and using an Assignment block as a counter..

[swaroop_anasane · Accepted solution]

That's anyways a work around that was always there.

[former_member185280 · Accepted solution]

Are persistent properties synchronized?

[raj44 · Accepted solution]

I believe yes, since the column containing the persistent property is getting updated in sync

[swaroop_anasane]

Hi Rajeev,

You have some default columns with an MDO that records insert timestamp. You can make use of it.

Thanks,

Swaroop

[raj44]

Hi Swaroop,

So you're saying I have one column and use datenow function to insert the record? Can't we implement a sequence in the column? Also, can select MAX sql syntax be used with MDO?

Regards

Rajeev

[swaroop_anasane]

No Rajeev,

There is a set of columns that gets created automatically for every MDO created for insertion(the one that doesn't have data source). You would be able to see those in your MDO select query not on MDO object.

Please find the image below for reference. You can make use of these columns.

Thanks,

Swaroop