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…”
Please find this post as reference.
Hi, the part which is equal works fine for me. But I dont know how to get the “not like” part to work.
I checked with following example.
DT.Select("([name]='ak' or [name]='aksh') and [name] not like '%sh%'").CopyToDataTable