Function ASPROJECTNAME
This function converts project id from to its name. With this function you can limit joins to Table PROJECTS in your query for presentation purposes.
It takes one parameter:
Type | Notes |
|---|---|
BIGINT | Id of a project |
Examples
Comparison of name and converted id
SELECT NAME, AUX.ASPROJECTNAME(ID) FROM PROJECTS LIMIT 4