Service Now Input Tool Custom Query

[SR]

HI All,

i am using the service now input tool to connect directly to SN tables to fetch data in alteryx workflows. However, one of the tables contains over 20M records and i need to figure out a way to filter the records before the input tool fetches all the records.

In the input tool there is an option for customer query but i am struggling with understanding the correct syntax.

Select * from task_sla where task = "e7962b741b6b89d4d68a0d0cf94bcb20";

i tried using this query where i want to pull records for the particular task id. however it is not working.

if anyone can help in figuring out the right query to filter the data i would be very helpful.

Thank You

SR