Escape sequence for column names containing characters "(" and ")'

.NET SDK
1

I am using .Net C# along with Couchbase for our project.
One of my Table column name contains characters “(” and ")’ in it. So I am unable to do summation operation on that , its always returning null, where as for other columns its working fine.
C# Code :
string query = “SELECT SUM(Amber rake(wo rollover)) As Amber rake (wo rollover),
Sum(Configs Settled) As Configs Settled
FROM _default”

var queryResult = await inventoryScope.QueryAsync(query);

Output :
Amber rake(wo rollover) = null
Configs Settled = 10

3

You can escape bucket and attribute names with special characters using the backtick “`” character.

SELECT SUM(`Amber rake(wo rollover)`) As `Amber rake (wo rollover)`,
Sum(`Configs Settled`) As `Configs Settled`
FROM _default
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.