+18
On a custom LU, I’d like to create a read-only reference field to expose MY_CLT.ROWVERSION in the client presentation. Expressions or SQL statements against t.rowversion or v.objversion don’t appear to work. Is there a way to show this field to the users, short of creating another persistent field?
(My preference would be a solution that exposes the field without intermediate functions so the database can honor an index on it.)
Best answer by paul harland
View original
+24
hi Kevin,
the following works fine in Apps 10. I’m guessing you’ve tried this, in which case it must be a difference Apps 9 vs. 10… (?)
+18
This is what I ended up using:
TO_DATE(v.objversion, 'YYYYMMDDHH24MISS')
The GET_ function in the _CLP package means there’s no way to enable indexing. 
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.