How to changes values dynamically in sql query, Nee supply values through parameters. "SELECT WIID, Description,Type,Status FROM work_Items WHERE Type = 'WI2'; " [image] sql sql-database

@ManjunathReddy As you are reading from excel it would be good to inlcude places holders and use replace functions eg: in excel have query as Select * from Table Where Date = '<DATE>' In code you can use Row("ColumnName").ToString.Replace("<DATE>",actualDate) cheers

Hi @ManjunathReddy You can check this: [image] How To Pass Dynamic Data To SQL Query From UiPath? Knowledge Base How to pass dynamic data to SQL query from UiPath ? Pass dynamic data to SQL query, by following any of the below methods Passing variable to SQL query Passi…

Replace "SELECT WIID, Description,Type,Status FROM work_Items WHERE Type = 'WI2'; " with "SELECT WIID, Description,Type,Status FROM work_Items WHERE Type = '"+in_type+"'; " @ManjunathReddy

Like this - adapt to your specific case indeed. // Using variables in SQL command “SELECT * FROM @tableName WHERE ID = @id” [image]

The queries I am Reading from Excel. so do I change dynamically . [image] [image] @Yoichi @Anil_G @supermanPunch @Gokul001 Thank in advance

Getting error like below. [image] [image]

@ManjunathReddy Please print the value using log message and check if the statement looks proper Is actualDate value correct cheers

There is no problem with that. You can get the query from wherever you want. Only the query parameter should not be quoted. And indeed the value in actualDate string variable must be propperly formated - which as I can see you have. Select * from Acme_data Where Date = @Date Cheers

@ManjunathReddy I want you to print whole query string …like whatever is there in run query to check where the issue lies…as per error there might be one more extra equals or so Cheers

How to supply Parameter's in PostgreSQL

Help Activities

supriya117 (Supriya Allada) July 13, 2023, 1:59pm 2

Hi @ManjunathReddy

You can check this:

Hope it helps.

Topic		Replies	Views
How To Pass Dynamic Data To SQL Query From UiPath? Knowledge Base activities	6	9176	December 21, 2022
How to pass the dynamic value in SQL from uipath StudioX	10	1627	March 15, 2023
Create SQL query parameters dynamically Help	17	17083	August 25, 2023
I want to know how to pass excel output into the SQL queries for find matched values Task Mining question , task_mining	9	1837	October 12, 2021
Change static data from to Variable in SQL Query Insights question	4	51	December 14, 2025

How to supply Parameter's in PostgreSQL

Related topics