Hello Team,
I have an app that at one point is filtering a widget with app vars. I noticed it was not working correctly so I went to the logs and found the SQL statement for my widget. In the statement, the where clause does not look right. There is an extra 'N' character for some reason. This is what it looks like.
"SQLSTMT": " SELECT F1.tocid AS F1_tocid, F1.Division AS F1_Division, F1.MSG1 AS F1_MSG1, F1.MSG2 AS F1_MSG2, F1.MSG3 AS F1_MSG3, F1.TRATSCode AS F1_TRATSCode, F1.TRATSDESC AS F1_TRATSDESC FROM Operations_Repo.dbo.TRATSDocLookup AS F1 WHERE (F1.TRATSCode=N'STRETCH WRAPPER ' AND F1.Division=N'68') ORDER BY F1.tocid DESC "
My app vars are STRETCH WRAPPER and 68. I have no idea where that N is coming from. When I check the app vars in my helper programs, there is no N character. Any idea where that might be coming from?
I have an app that at one point is filtering a widget with app vars. I noticed it was not working correctly so I went to the logs and found the SQL statement for my widget. In the statement, the where clause does not look right. There is an extra 'N' character for some reason. This is what it looks like.
"SQLSTMT": " SELECT F1.tocid AS F1_tocid, F1.Division AS F1_Division, F1.MSG1 AS F1_MSG1, F1.MSG2 AS F1_MSG2, F1.MSG3 AS F1_MSG3, F1.TRATSCode AS F1_TRATSCode, F1.TRATSDESC AS F1_TRATSDESC FROM Operations_Repo.dbo.TRATSDocLookup AS F1 WHERE (F1.TRATSCode=N'STRETCH WRAPPER ' AND F1.Division=N'68') ORDER BY F1.tocid DESC "
My app vars are STRETCH WRAPPER and 68. I have no idea where that N is coming from. When I check the app vars in my helper programs, there is no N character. Any idea where that might be coming from?
Comment