Function ASPROJECTKEY

Owned by Piotr Bojko
May 24, 2018
1 min read

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