Datatable select not equal issues

studio

#1

Hi I have a datatable select issue. My syntax is like this:

logdt =logdt.select("[Robot Start Date] = ‘"+thisbatchtime.tostring+"’ and [Completion Date] not like ‘Exception’").copytodatatable

I keep getting source contains no datarow, but there should be.
And this only happens after i added the part after “and…”


#2

Hi,

Please find this post as reference.


#3

Hi, the part which is equal works fine for me. But I dont know how to get the “not like” part to work.


#4

I checked with following example.
DT.Select("([name]='ak' or [name]='aksh') and [name] not like '%sh%'").CopyToDataTable