Hi Mates,
i want to execute SQL command to get based on filter so using Execute a SQL Query, there i need to filter with a field value
ex: filter in ID field where Id=HPMDB 0000119
SELECT ID,FROM
Table
WHERE
(ID ='HPMdb 0000119')
-----------------------
SELECT ID,FROM
Table
WHERE
(ID ='@{outputs('Compose')}')
i can get expected values from the first query, but not from the last/next query because its combination of string, number
what is the data type can we use for combination of string/number
yes i also tried taking variable, with string datatype but it throws error since it contains numbers as well.
your help will be highly appreciated
Hi @Anonymous ,
If you are doing looping and using the fields , try using compose action and specify your inputs with expression.
Thanks
WarrenBelz
146,601
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,942
Most Valuable Professional