How to get the #select values in csv file

[kal-purush]

How is to possible to get the query result shown in vs code query result in CLI? If I run the same query in CLI and save the result in csv file, I got different result.

this is the result from vs code, but the same query produces this result in csv file

how can I get the vs code result in CSV file?

[MathiasVP]

Hi @kal-purush,

Can you show me:

• the query you're trying to get the output from.
• The CLI command you're running to get the csv output.

The reason I'm asking for these things is that CodeQL queries have some meta-data at the top of the file that tells the CLI how to interpret the results. The VSCode extension does this automagically for you when this meta-data is present, but if you're calling the CLI directly you might need to do that manually (depending on how you invoke the CLI).