Transform value from database


How do I change an id coming from the database like 1 to 00001?

There is no such integer like 00001.

You can transform ID coming from DB to text and add whatever you want.

You can use the Data Formatter - Text Pad formatter to add characters in front.

Just make sure the 0 is entered as string:

aa.pad(5, '0', 'left')