Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

BUG: In-databse tools - Different query depending on "Basic filter" or "Custom filter"

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

A client of ours have the following problem regarding the in-database tools. When doing a filter with special chars in it, I get two different queries depending on whether I choose "Basic filter" or "Custom filter".

 

Skærmbillede 2015-12-11 kl. 12.50.16.png

 

Generates the following query:

 

WITH "Tool1_1517" AS (Select * From SalesData) SELECT * FROM "Tool1_1517" WHERE "product name" LIKE '&'

 

Skærmbillede 2015-12-11 kl. 12.51.35.png

 

Generates the following query:

 

WITH "Tool1_1517" AS (Select * From SalesData) SELECT * FROM "Tool1_1517" WHERE "product name" LIKE '&'

 

Please correct me if I am doing anything wrong.

 

Best regards,

Daniel

 

Highlighted
Alteryx Alumni (Retired)

Hello Daniel,

 

Can you specif what database this is? We'll look into it.

 

JC

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hey JC,

 

I will talk to the client and get back ASAP. 

 

Best regards,

Daniel

Labels