can we use table aliases in scripts files
My application uses lots of jquery script files and the TABLE ID is hard coded everywhere. The problem is that these IDs changes when the application is either copied or a new sandbox environment...
Forum Discussion
You can't use table aliases in scripts.
However you can determine the mapping between table aliases and dbids using the API.
Call dbid?act=API_GetSchema on the application dbid and the names and dbid's of each table will be listed within the <chdbids> tag.
See also:
How is the name of a table alias determined ?
https://community.quickbase.com/quickbase/topics/how-is-the-name-of-a-table-alias-determined
However you can determine the mapping between table aliases and dbids using the API.
Call dbid?act=API_GetSchema on the application dbid and the names and dbid's of each table will be listed within the <chdbids> tag.
See also:
How is the name of a table alias determined ?
https://community.quickbase.com/quickbase/topics/how-is-the-name-of-a-table-alias-determined