When Datatble.Select is suspected to be error, which packages should be updated?

Help Activities
, ,
1

Hi.

Datable.Select in my process doesn’t seem to work.
Datatable.Select result was strange, so I ran some tests.

dt.Select(“[A] = '”+ values +“’ AND [B] = ‘C’ “) → Length is 0
dt.Select(”[A] = '”+ values +“’ “) → Length is 1
dt.Select(”[A] LIKE '%”+ values +"%’ AND [B] = ‘C’ ") → Length is 1

I didn’t understand this result, so I created a new process and tested it.
I confirmed that the new process works fine.
dt.Select(“[A] = '”+ values +"’ AND [B] = ‘A’ ) → Length is 1

This issue doesn’t happen all the time, it only seems to happen with specific variables.
I updated the version of both Uipath.UiAutomaiton and Uipath.System.Activities packages to 22.4.X using version 20.4.X, but the same issue is occurring.

Could you tell me what packages I need to update?.

2

Hi,

Can you share specific sample project as file?

Regards,

3

Hi.

The problem seems to be the data type of the data column.
I imported the datatable from Excel and used it, so the data type of a specific column was an object.
I created a new data table with all columns as strings, and copied all the data through a loop.
After that, this problem did not occur.

What I’m curious about is, ‘Window-legacy’ has a problem, but ‘Windows’ doesn’t.

I also found that this problem does not occur in ‘WIndows-legacy’ even when the number of rows in the data table is small.

This problem appears when I search for a specific strings, and the string is important information, so please understand that the file cannot be uploaded.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.