topic ThingWorx SQL Query in ThingWorx Developers

ThingWorx SQL Query

PSB — Mon, 20 May 2024 13:12:05 GMT

Hi all,

I have to run a query on MS SQL Database table, which has columns with spaces in their names (ex: 'SA03 LH CS BRG DEPTH (mm)').

How do I query this successfully?

Here is an example query:

SELECT *

FROM <<tableName>>

WHERE <<tagName>> != 0;

Here <<tagName>> is a column with space in its name.

Arun_C — Mon, 20 May 2024 14:54:27 GMT

Hi @PSB ,

I have tried with PostgreSQL Query. It is working for me.

SELECT * FROM public.accounts where "SA03 LH CS BRG DEPTH (mm)" = 1

Thanks & Regards,

Arun C

PSB — Tue, 21 May 2024 04:51:55 GMT

PFA screenshot, I have tried it on MS SQL it doesn't seem to be working.

Can you try it on MS SQL & let me know.

Arun_C — Tue, 21 May 2024 07:00:29 GMT

Hi @PSB ,

I have tried in MS SQL DB. Kindly find the below atttached snapshot for your references.

Thanks & Regards,

Arun C