Hi Nitin,
with the above formula, its not generating random number but the dates in Epoch time.
Can you please check or suggest any other way?
------------------------------
Aditya Gupta
Freshgravity
------------------------------
Original Message:
Sent: 05-19-2023 09:39
From: Nitin Tugave
Subject: Sql Query to generate serial/sequence number as per the output query
Hi ,
you can use below formula, it will make number from date
=now.strftime("%s%L")
regards,
Nitin Tugave
------------------------------
Nitin Tugave
eaton
Original Message:
Sent: 05-18-2023 09:34
From: Aditya Gupta
Subject: Sql Query to generate serial/sequence number as per the output query
Hi All,
Is there any way to generate serial number/sequence number in a sql query in Collection action in RIH?
I have used 'row_number() over(order by col1)' function and 'rank() over(order by col1)' function but its giving a syntax error, is there any other way to use them in Collections in RIH or any other way to generate serial numbers?
------------------------------
Aditya Gupta
Freshgravity
------------------------------