Support Article
Filter Condition on Report Definition Rule Does Match Unicode
SA-32265
Summary
A query is generated by PRPC report definition rule with parameters passed for FirstName and LastName. Even though records exist in database, they do not match.
Error Messages
Not Applicable
Steps to Reproduce
- Create database table with two columns, first name and last name, in MS-SQL Server Database with column type nvarchar.
- Create a record in this table with first name and last name in unicode Char.
- Create a data class instance, Data Admin database Table Instance and map the table to class.
- Create a report definition rule on that class with two filter conditions for first name, last name and matching names in unicode Char.
- Observe that the records do not match.
Root Cause
A defect in Pegasystems' code or rules:
Nvarchar column type is not set correctly in the column. Thus, N is not prefixed to the prepared value for NVarchar column in SQL Server database.
Resolution
Apply HFix-31396.
Published January 30, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.