Skip to main content
Question

Number Counter next value projection function

  • October 17, 2022
  • 3 replies
  • 260 views
K
Do Gooder (Partner)
Forum|alt.badge.img+2

Hello

I'm having a bit of task to try and make use of oracle sequences in IFS Cloud and stumbled upon number counters:

 

The solution proposed in that topic looks to be what I'm after, however I'm having trouble finding a way to specifically generate a value from a projection function. The solution detailed is very much reliant on database access, but with IFS Cloud we have to assume no DB access.

So i am looking for a projection that in essence calls ‘next_val()’ and returns the next value of the counter/sequence.

 

Is there one?

3 replies

M
Hero (Partner)
Forum|alt.badge.img+11
  • MiLeNL
  • Hero (Partner)
  • 100 replies
  • January 20, 2023

 

KieranFJ wrote:

Hello

I'm having a bit of task to try and make use of oracle sequences in IFS Cloud and stumbled upon number counters:

 

The solution proposed in that topic looks to be what I'm after, however I'm having trouble finding a way to specifically generate a value from a projection function. The solution detailed is very much reliant on database access, but with IFS Cloud we have to assume no DB access.

So i am looking for a projection that in essence calls ‘next_val()’ and returns the next value of the counter/sequence.

 

Is there one?

 

I got the exact same requirement. Did you ever find any solution?

K
Do Gooder (Partner)
Forum|alt.badge.img+2
  • KieranFJ
  • Author
  • Do Gooder (Partner)
  • 1 reply
  • January 27, 2023

No native solution i have found.

The customer requirement ended up going away but i planned either to write a custom projection to make use of the doc man number counter, or write my own solution outside of IFS and use that.

Shame really as number counter seems really close for wider use, but its missing just a bit of functionality.

M
Hero (Partner)
Forum|alt.badge.img+11
  • MiLeNL
  • Hero (Partner)
  • 100 replies
  • January 27, 2023
KieranFJ wrote:

No native solution i have found.

The customer requirement ended up going away but i planned either to write a custom projection to make use of the doc man number counter, or write my own solution outside of IFS and use that.

Shame really as number counter seems really close for wider use, but its missing just a bit of functionality.

I just thought of the same this morning 😀. Created a Custom Entity with ID1 and ID2, the Next Value function and a Custom Projection on top of it. Every time you make an API call to Projection, you will get the next value. More is not required at the moment. Indeed a shame it's not a standard function in the standard number counters projection.

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings