set up auto-incrementation for a field in a custom entity

Hi ​@NINO,

You need to create a Persistent type field where data type should be String.

Select PLSQL option for default value and enter below method.

DOC_NUMBER_COUNTER_API.FETCH_NEXT_NUMBER('EVENTBUS','-')

Hope this helps.

Regards

Abdul Rehman 

Hi ​@Abdul 

1) I tried DOC_NUMBER_COUNTER_API.FETCH_NEXT_NUMBER('EVENTBUS', '-') but it didn’t work, and even when I set a hardcoded value, it doesn’t appear in my table.

For my tests, I’m using an OData call on my custom projection CustomProjectionTESTNINOTAB.

But the ID column is still null.

2. However, this call works fine.

SELECT IFSAPP.DOC_NUMBER_COUNTER_API.FETCH_NEXT_NUMBER('EVENTBUS','-') FROM DUAL

Hi ​@NINO,

First, counter value would be null for existing records, so better check by creating by some new records.

Second, use PL/SQL Expression option to get default value.

Please check above suggestions and let me know if you need further assistance.

Regards 

Abdul Rehman 

Hi ​@Abdul 

Thanks for your feedback.

As I mentioned earlier, I already tried using:

DOC_NUMBER_COUNTER_API.FETCH_NEXT_NUMBER('EVENTBUS', '-')

For testing, I’m using an OData call on my custom projection CustomProjectionTESTNINOTAB,
but the ID column still remains null.

However, when I run this directly in SQL:

SELECT IFSAPP.DOC_NUMBER_COUNTER_API.FETCH_NEXT_NUMBER('EVENTBUS', '-') FROM DUAL

it works perfectly.

Do you have any idea why the default value or PL/SQL expression isn’t being applied when inserting through OData?

Thanks again for your help.

​@NINO you can’t call the procedure directly in SQL Developper, you need to call it threw dual for exemple or using a variable to store the return result

.

BUT

when adding a custom field the call could be added directly : 

I have created a custom entity and page 

Works well from my end