Function ASPROJECTKEY

Owned by Piotr Bojko
May 24, 2018

This function converts project id from to its key. With this function you can limit joins to Table PROJECTS in your query for presentation purposes.It takes one parameter:

TypeNotes
BIGINTId of a project

Examples

Comparison of name and converted id
SELECT KEY, AUX.ASPROJECTKEY(ID) FROM PROJECTS LIMIT 4