Not able to find desired function in the dropdown for calculated field
説明
Trying to create a calculated field in the Query Builder. When selecting the Functions dropdown to create the Field Definition, the function being looked for is not there.
原因
All functions are not available for all database platforms. Some platforms may have more functions to offer than others.
対策
To use a function, the function does not need to be selected from the list. Type the desired function in the field at the top of the window, where the code would go when you double click on a function. Manually typing the function will do the same thing as if it was selected from the list, even if it is not listed.
