Text Box with Action to Change SQL Query

[latimo1]

I can't figure out what I am doing wrong:

Dynamic Input Query:

select "Mitsubishi Electric Trane HVAC US LLC"."Mitsubishi Electric Trane HVAC US LLC".Kumo_Coin_Transaction__c.Id,
"Mitsubishi Electric Trane HVAC US LLC"."Mitsubishi Electric Trane HVAC US LLC".Kumo_Coin_Transaction__c.Name,
"Mitsubishi Electric Trane HVAC US LLC"."Mitsubishi Electric Trane HVAC US LLC".Kumo_Coin_Transaction__c.Contractor__c,
"Mitsubishi Electric Trane HVAC US LLC"."Mitsubishi Electric Trane HVAC US LLC".Kumo_Coin_Transaction__c.Amount__c,
"Mitsubishi Electric Trane HVAC US LLC"."Mitsubishi Electric Trane HVAC US LLC".Kumo_Coin_Transaction__c.Description__c,
"Mitsubishi Electric Trane HVAC US LLC"."Mitsubishi Electric Trane HVAC US LLC".Kumo_Coin_Transaction__c.Type__c
from "Mitsubishi Electric Trane HVAC US LLC"."Mitsubishi Electric Trane HVAC US LLC".Kumo_Coin_Transaction__c
where
"Mitsubishi Electric Trane HVAC US LLC"."Mitsubishi Electric Trane HVAC US LLC".Kumo_Coin_Transaction__c.Contractor__c in ('0015300000LeCKOAA3','0015300000LeCKmAAN')

Replace String:

    Error at char(0): Empty expression

[JORGE4900 · Accepted solution]

Hi there @latimo1 

Looks like you need to select the part that you want to dynamically change like this tool shows. This assumes that you are replacing the whole in statement. This means that you should be building many options for your users to select an IN statement with two or multiple values.

Also; make sure you select the Preview button on your dynamic input tool to make sure the query is working properly.

If you only have single value codes on a list, you may have to build a chained app to process the possible multiple-value-code selected and concatenate it with the summary tool to create the IN  statement.

Spoiler

Spoiler