Json - Auto generated employeeId

[Jillustre]

In an CreateAccountJson, is there a way to make an auto generated employeeId based of the max existing one plus 1?

[avinashchhetri]

@Jillustre,

EmployeeID is user specific not account. Are you looking to create/generate a new employeeID for each account ? Isn't employeeID part of your user attribute ?

[rushikeshvartak]

You can generate

[h_sapkota]

Could you please elaborate how we can achieve this?

Apart from using SQL generator function is there any other way !

Regards,

Hitesh Sapkota

[rushikeshvartak]

validate if that works in json or not here random number between 100 to 1000

(int)(java.lang.Math.random()*(1000-100+1)+100)

[h_sapkota]

Hi Rushikesh,

If we want to get some value incremented from max of value of users.

For Eg:

Users have employee Id in cp10 and max of all users cp10 is 101.

I want to pass max+1 as employeeid in createaccountjson i.e. 102.

How can we achieve this? First how do we find the max of cp10 from all the users data.

Regards,

Hitesh Sapkota

[rushikeshvartak]

Create dynamic attribute and use that dynamic attribute in json

[Jillustre]

Sorry for ma late answer on this. How we can do that a dynamic attribute?

[rushikeshvartak]

select max(employeeid)+1 as id from users

[h_sapkota]

Hi Jillustre,

Use select sql query in dynamic attribute to get the max value of employeeid for all the users and then add 1 value which will be your required max value + 1.

Regards,

Hitesh Sapkota