External BAQ varchar vs nvarchar

Epicor ERP 10
1

I’m matching the beginning of a string via an Epicor parameter. In MySQL the datatype is varchar but Epicor only has nvarchar so I get a warning although it seem to work as expected.

Any suggestions on how to handle type mismatches like this in an external BAQ?

Error: Data type mismatch in subquery ‘SubQuery1’ criteria between ‘time.session’ field of type ‘varchar’ and ‘year’ parameter of type ‘nvarchar’. This may cause query execution errors.

The condition that is causing this:
image

The results indicate it seems to be working:
image

2

You can type in those fields, so you can probably put a cast in from of the field.

2 Likes