Sequence with Postgres

samybill · April 24, 2022, 1:41pm

Hi all,

I am trying to create a sequence using Jmix Sequences that can start from a max value 1000 with an increment of -1 to the lower limit 0.

Any idea how one can achieve this?

Thanks,
Samy

krivopustov · April 25, 2022, 2:36pm

Hi Samy,

The Sequence class of Jmix has no parameter for lower limit. So if you are certain about your database, just use Spring’s JdbcTemplate to create and use a sequence directly through SQL.