You can translate the question and the replies:

using order by clause in denodo vql

Hi , I want to use this query in my vql in denodo. SELECT * FROM finance."ProjectStatusCs" order by WBSInternalNbr limit 10 but it gives this error : Error in ORDER BY clause: Invalid field name: wbsinternalnbr can someone please help
user
13-02-2023 04:01:00 -0500
code

1 Answer

Hi, The invalid field name error that you received was because the Denodo Platform could not find a field name ‘WBSInternalNbr’ in the ‘ProjectStatusCs’ view in the ‘finance’ virtual database. I was able to reproduce the error by misspelling the name of the field in my ORDER BY clause. You should check for the existence of the field ‘WBSInternalNbr’ in your view and ensure that the spelling is correct in your VQL query. If the field name is spelled correctly then you will need to put it into double quotation marks as you did for the name of the view as it looks like the column name is case-sensitive. `SELECT * FROM finance."ProjectStatusCs" order by "WBSInternalNbr" limit 10` For more details, you can refer to the [Identifiers Charset](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/identifiers_charset/identifiers_charset) section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
13-02-2023 15:41:49 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here