How to get file id through fileficket in sql
On the server, DNN calls
UrlUtils.DecryptParameter, which calls PortalSecurity.Decrypt, which calls CryptographyProvider.DecryptParameter, ultimately using the DESCryptoServiceProvider (by default). SQL Server does provide cryptographic functions, so you can see whether it's possible to replicate that logic in the database. If it's possible to handle it on the web server, that's probably going to be quite a bit easier than doing it in SQL.
These Forums are dedicated to discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.