The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hi,
I am using Table Transformer macro with the SQL
Select * from T1 where T1.'Status' IN ("To Do", "Done", "Won't Do")
How do I include the apostrophe in "Won't Do" in the where clause? Thanks.
Hi @Leona ,
Please try the following SQL query:
SELECT * FROM T1
WHERE T1.'Status' IN ("To Do", "Won"+ CHAR(39) + "t Do")
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Leona ,
try to use double '
Example :
Select * from T1 where T1.'Status' IN ('To Do', 'Done', 'Won''t Do')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI @Leona ,
If this is like SQL, you should be able to escape it. In this case, you maybe about to run single routes around the apostrophe.
-Ben
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋♀️ ...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.