PSQL Functions

33 views

Skip to first unread message

Kanat Mergenbayev

unread,

Aug 8, 2025, 4:07:07 AMAug 8

to iDempiere

Hi community.

For reports, I currently use views with some workarounds to limit the requested data. Are there any built-in features in iDempiere that allow using functions instead of views?

Carlos Antonio Ruiz Gomez

unread,

Aug 8, 2025, 4:44:38 AMAug 8

to idem...@googlegroups.com

Hi Kanat,

There is no built-in feature to manage functions within iDempiere.

You can write the functions in normal pl/pgsql and distribute them with
2Pack.

And then you can use the functions in the views which is managed within
iDempiere.

Regards,

Carlos Ruiz