How to supply Parameter's in PostgreSQL

[ManjunathReddy (P Manjunatha)]

How to changes values dynamically in sql query, Nee supply values through parameters.

"SELECT WIID, Description,Type,Status
FROM work_Items
WHERE Type = 'WI2';
"

sql sql-database

[supriya117 (Supriya Allada)]

Hi @ManjunathReddy

You can check this:

How To Pass Dynamic Data To SQL Query From UiPath?

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 Passing parameter to SQL query Approach #1: Passing Variable To SQL Query In order to pass variables to SQL query, variables must be declared first. In the below screenshot, three variables are declared and assigned values using assign activity before doing any SQL operation. [1.png] The SQL query(INSERT/UPDATE/SELECT) needs to be modified t…

Hope it helps.

[jack.chan]

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

[J0ska]

Like this - adapt to your specific case indeed.

// Using variables in SQL command
“SELECT * FROM @tableName WHERE ID = @id”

[ManjunathReddy (P Manjunatha)]

The queries I am Reading from Excel. so do I change dynamically .

@Yoichi @Anil_G @supermanPunch @Gokul001

Thank in advance

[Anil_G (Anil Gorthi)]

@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

[ManjunathReddy (P Manjunatha)]

Getting error like below.

[Anil_G (Anil Gorthi)]

@ManjunathReddy

Please print the value using log message and check if the statement looks proper

Is actualDate value correct

cheers

[ManjunathReddy (P Manjunatha)]

Value is there

[J0ska]

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

[Anil_G (Anil Gorthi)]

@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

[ManjunathReddy (P Manjunatha)]

[J0ska]

Make sure the query in excel is a single continues line, i.e. wrap text is not applied.

What database system you work with?

[ManjunathReddy (P Manjunatha)]

The database type I am using “Postgresql”

[J0ska]

I am not familiar with postgres but seems it is using $ instead of @

Parameterized queries and bind parameters in PostgreSQL - DBA

So the query should look like

Select * from Acme_data Where Date = $Date

If it doesn’t work you should use the Approach #1 from

How To Pass Dynamic Data To SQL Query From UiPath?

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 Passing parameter to SQL query Approach #1: Passing Variable To SQL Query In order to pass variables to SQL query, variables must be declared first. In the below screenshot, three variables are declared and assigned values using assign activity before doing any SQL operation. [1.png] The SQL query(INSERT/UPDATE/SELECT) needs to be modified t…

Cheers

[ManjunathReddy (P Manjunatha)]

$ symbol is also not working

Approach #1 Is only for INSERT/UPDATE/SELECT not for Where condition.

@uipath

[J0ska]

Not realy. Approach #1 means that you build your SQL command in a string variable and pass this string variable to “Run Query” activity. It is what @Anil_G wrote before.

For debug purposses I recommend print the mySQL before executing.

e.g.

myQueryString = "Select * from Acme_data Where Date = '<myDate>'"
myDateString = "2023-07-11"
mySQL = myQueryString.replace("<myDate>", myDateString)

“Run Query”

[J0ska]

Alternatively have look at this

PostgreSQL get data from table

Get / Retrieve the data from the PostgreSQL database using the “select” statement inside UiPath. It has a provision for parameters. It gives the output as a data table. [PostgreSql UiPath | uipath postgresql | select the data] Thank you Balamurugan.S