How to input variable from input dialog into run query

Help Community
,
1

Hi guys, can you help me. i use (input dialog) to input number week of year then this input number will be pass into Run Query

image
image560×622 13.2 KB

image

2

HI,

I recommend to use String.Format as the following.

image
image720×511 23.5 KB 

strSQL ="SELECT TOP 1 Date
FROM Dim_Date
Where WeekOfYear ='{0}'
AND Year =2022
"

Then

String.Format(strSQL,MingguBerapa)

Regards,

3

hi, thanks for your reply but i want to dynamic input then pass into query
like this…
image

4

HI,

Can you try to replace the first assign with input dialog?

FYI, the following is a sample with validation for input text.

image
image1013×850 20.5 KB

Sample20221122-2.zip (2.5 KB)

Regards,

5

Hi @Yoichi i’m sorry i cant open your workflows because my uipath version is lower than the template, mate.
Can you screenshot the condition code?

6

HI,

It’s as the following.

not Int32.TryParse(MingguBerapa,New Int32)  OrElse CInt(MingguBerapa)<0 OrElse CInt(MingguBerapa)>54

Regards,

7

I following th code and still get the erorr like this…
image

Regards.

8

HI,

Can you check the following downgraded sample?

Sample20221122-2v2.zip (2.4 KB)

And also can you check your query string as the following?

strSQL ="SELECT TOP 1 Date
FROM Dim_Date
Where WeekOfYear ='{0}'
AND Year =2022
"

strSQL =String.Format(strSQL,MingguBerapa)

Then check content of strSQL using WriteLine or MessageBox?

Regards,

9

I Mean i want to replace the 46 below with number from input dialog

image
image1067×447 24.1 KB

10

Hi,

Did you check the above sample? If we input 46, the query string is as the following.

image
image927×599 26.2 KB

Regards,

11

yeah i try it but the string WeekOfYear output is like this…

image
image478×551 12.9 KB

and i mean want to ouput like this… because the date want to continue the program using parse exact
image

12

Hi,

Your 1st image seems no problem. (2nd image cannot be seen due to forum system trouble) Please set this variable to query property?
Or is there any issue to set this variable?

Regards,

13

here the 2nd image (output that i want)

image
image410×543 4.61 KB

my project is i want input the WeekOfYear with the (input dialog box), then this number will dynamically fill in the (run query) when calling the date in SQL server table.

for example: in the dialog box I input WeekOfYear = 46. then the output will be 11/06/2022 00:00:00

14

HI,

Alright, we can get query string which contains week number from InputDialog. Is this no problem, isn’t it?

image

Or, do you need to calculate date from week number before sending the query?

Regards,

15

can this output make to datatable and printout date format? (11/06/2022 00:00:00)
because the output is format date from datatable. and i will converti it using parse exact

16

or can i copy this result to Run Query sql syntax?

17

Hi,

Do you need to convert from week number to start date of the week? If so, the following will help you. Please note that we need to determine which year to calculate.

image
image627×797 20 KB

Sequence2.xaml (6.8 KB)

Regards,

1 Like
18

This is work @Yoichi thank you mate. You the best. :wink:

1 Like
19

Hi @Yoichi . how to make this code to parse exact?
i want to use the output to pick/select date dynamic

image
image928×600 14.8 KB

image
image1645×387 14.6 KB

20

HI,

As the following expression returns DateTime type, we need to use ParseExact if your input is this.

dateJan1.AddDays(7*(weekNumber-1)-CInt(dateJan1.DayOfWeek))

We can create datetime string from this datetime variable.

varDateTime = dateJan1.AddDays(7*(weekNumber-1)-CInt(dateJan1.DayOfWeek))

Then

varDateTime.toString("yyyyMMdd")

Or do you paarse from any other string?

Regards,