AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.7K members online now
2.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply
Highlighted

Cannot perform text filtering over a resource obtained through a join SQL query

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

1- I have a resource obtained using a compound Joined SQL request :

SELECT sale_order_line.id, sale_order_line.create_date, sale_order_line.order_partner_id, sale_order_line.name as product_name, 
       sale_order_line.invoice_status, 
       CASE WHEN res_partner.parent_id IS NULL 
           THEN 
               res_partner.name 
           ELSE 
               (
                   SELECT name FROM res_partner as newparent WHERE newparent.id = res_partner.parent_id
               ) 
       END
FROM sale_order_line
JOIN res_partner ON sale_order_line.order_partner_id=res_partner.id
WHERE res_partner.parent_id IS NOT NULL OR res_partner.company_type = 'company';

 

2- In data studio, I set up a filter acting upon the field product_name :

exclude product_name contains "UPS"

3- I get the following error, suggesting that the wrong comparison operator has been used in one of your internal SQL queries :

 

The query returned an error.

Error with SQL statement: ERROR: operator does not exist: integer == integer
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 754
Error ID: 6bca3452

I would be super happy if you guys could make the filters work because I really do not want to perform the filtering in the initial SQL connector Query: data studio filters are way more flexible to use.