Hello,
I have to create a foreign key field, but the field can be null. so in the example below I cant change the row with the null value with the drop down.
How can I fix that ?
Please help me!
br,
Kevin A1Telekom Austria AG
I have to create a foreign key field, but the field can be null. so in the example below I cant change the row with the null value with the drop down.
How can I fix that ?
Please help me!
br,
Kevin A1Telekom Austria AG
01.<!DOCTYPE html>02.<html>03.<head>04. <base href="http://demos.telerik.com/kendo-ui/grid/foreignkeycolumn">05. <style>html { font-size: 12px; font-family: Arial, Helvetica, sans-serif; }</style>06. <title></title>07. <link href="http://cdn.kendostatic.com/2014.2.716/styles/kendo.common.min.css" rel="stylesheet" />08. <link href="http://cdn.kendostatic.com/2014.2.716/styles/kendo.metro.min.css" rel="stylesheet" />09. <link href="http://cdn.kendostatic.com/2014.2.716/styles/kendo.dataviz.min.css" rel="stylesheet" />10. <link href="http://cdn.kendostatic.com/2014.2.716/styles/kendo.dataviz.default.min.css" rel="stylesheet" />11. <script src="http://cdn.kendostatic.com/2014.2.716/js/jquery.min.js"></script>12. 13. <script src="http://cdn.kendostatic.com/2014.2.716/js/kendo.all.min.js"></script>14.</head>15.<body>16. <script src="../content/shared/js/products.js" type="text/javascript"></script>17. <div id="example">18. <div id="grid"></div>19. 20. <script>21. 22. var categories = [{23. 'value': null,24. 'text': 'null'25. },{26. 'value': 1,27. 'text': 'Cat1'28. },{29. 'value': 2,30. 'text': 'Cat2'31. },{32. 'value': 3,33. 'text': 'Cat3'34. }];35. 36. 37. 38.$(document).ready(function () {39. 40. 41. var date = [{id: 1, name: "Jane Doe", category: 1}, 42. {id: 2, name: "XXX", category: 1},43. {id: 3, name: "XX2", category: null},44. {id: 4, name: "XXX3", category: 1},45. {id: 5, name: "XXX4", category: 3}]; 46. 47. var dataSource = new kendo.data.DataSource({48. pageSize: 20,49. data: date,50. schema: {51. model: {52. id: "id",53. fields: {54. name: { type:'string' },55. category: { field: "category", type: "number" },56. 57. }58. }59. }60. });61. 62. 63. 64.$('#grid').kendoGrid({65. dataSource: dataSource,66. height: 570,67. filterable: true,68. sortable: true,69. pageable: true,70. editable: true,71. toolbar: ['save', 'cancel'],72. columns: [73.{ field: "name", title: "Name" },74. { field: 'category', title: 'Category', width: '200px', values: categories , }75. ]76. });77.});78. 79. 80. 81. 82. 83. </script>84. </div>85. 86. 87.</body>88.</html>3 Answers, 1 is accepted
0
Hi Kevin,
Basically you should define custom editor for the column in order to set the "valuePrimitive" option of the dropDownList to true. For convenience I updated the provided example to work as expected:
Regards,
Vladimir Iliev
Telerik
Basically you should define custom editor for the column in order to set the "valuePrimitive" option of the dropDownList to true. For convenience I updated the provided example to work as expected:
Regards,
Vladimir Iliev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Hannah
Top achievements
Rank 2
Rank 2
answered on 16 Jan 2019, 09:20 PM
Vladimir,
I realize this is an old post, but I was wondering if you could make the 'ForeignKeyColumn: allow null values' example available again.
Regards,
Hannah
0
Hello Hannah,
I have tested the provided by my colleague sample and it seems to be working as expected on my end.
Nevertheless I have created a new dojo with the same content, you will find it in the link below:
Please test it and let me know if it works for you.
Regards,
Georgi
Progress Telerik
I have tested the provided by my colleague sample and it seems to be working as expected on my end.
Nevertheless I have created a new dojo with the same content, you will find it in the link below:
Please test it and let me know if it works for you.
Regards,
Georgi
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.