Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
450
Special characters in primary key column is giving exception in hierarchical grid
posted

Hi Team,

 

We have Business Services REP as parent. Once we expand Business Services REP, we will get all child columns.

 responseDataKey : "EMPLOYEE_NAME",

dataSourceType: "json",

autoGenerateColumns : false,

primaryKey: "EMPLOYEE_NAME"

 

And columns –

 columns: [

{key: "EMPLOYEE_NAME", headerText: "Business Service Rep" ,dataType:"string"}]

 

Here, the issue is – if you see the first name “Ablett, William J. (Jim)”, it has comma, dot and round brackets and if we use this column as Primary Key column we get an exception.

What we understood is that primary key column value doesn’t work with dot or round brackets.

Our requirement is we want exact same name to be displayed and also we don’t want to add any more column as Primary Key column.

 

How can we achieve “Ablett, William J. (Jim)” as Primary Key value or is there any other alternative we can handle this situation?