I am trying to maintain a pre-existing piece of software that uses Telerik Data Access for data access and also Telerik Kendo on the frontend. Several Kendo grids in the software represent tables in the database, except in order to be more user-friendly, instead of displaying foreign keys, they display the Display Names of the objects those foreign keys represent.

In order to fill the grid, then, the data call made by the UI might look something like this:

[root]/DataServices/[tenant]/odata/HouseModels?%24format=json&%24top=100&%24count=true&%24expand=DoorStyle(%24select%3DID%2CDisplayName)%2CWindowStyle(%24select%3DID%2CDisplayName)%2CDeckStyle(%24select%3DID%2CDisplayName)%2CFinishStyle(%24select%3DID%2CDisplayName)

This works fine in all ways except one: if a foreign key column is nullable and the user sorts or filters on that column, all rows that have a null value in that column will disappear. (Ironically, this even happens if the user filters specifically to show only null values! They will always see no results!)

I personally don't care whether null values are sorted before or after non-null values, but entire rows should never disappear entirely just from sorting (or in a way that makes zero sense for a particular filter).

[Note: The 'HouseModels' thing above is just an example. My data has nothing to do with houses, so yes, it does make sense to have nullable FKs.]

Using SQL Profiler, I believe I have determined the Data Access behaviour that is causing this problem. When the user tries to apply a sort or filter, the first call received by the database will look something like this if the user sorts the 'Door Style' column:

SELECT  TOP(100)
a.[ID] AS COL1,a.[FinishStyleID] AS COL2,a.[DoorStyleID] AS COL3,
a.[WindowStyleID] AS COL4,a.[DeckStyleID] AS COL5,
(CASE WHEN a.[DoorStyleID] IS NULL THEN NULL
    ELSE b.[DisplayName] END)
AS xj1
FROM [HouseModels] a
JOIN [User DoorStyles] AS b
ON (a.[DoorStyleID] = b.[ID])
/*permissions-related SQL omitted*/
ORDER BY xj1 DESC

From what I can tell, the results of this first call determine what rows will be visible in the grid, because the subsequent data calls are to fulfill all of the 'expand' requirements for all the IDs in the result of that first call.

As you can see, this means the problem is in the "JOIN" in the first call. Whether the user is filtering or sorting, that JOIN will always be on the column being sorted or filtered. Due to that being a "JOIN" instead of a "LEFT JOIN", all rows with a null value in that column are completely omitted from the results.

Is there any way that I can change this to be a LEFT JOIN? I don't know how to configure or override that part of what Data Access is doing.

[Note: At this time, we have to keep using Data Access. Completely replacing that is way beyond the scope of this small bug I am trying to fix.]

Yes, you can add watermarks to your PDF Files. Use the PDF Watermark application to recognize your PDFs as a logo, image, or text. The tool can watermark your PDF File at one time on every Page of the PDF file. The tool's Best feature is customized watermarks of your choice and some multiple-time increases of the opacity level from lighter to darker and darker to lighter. The tool permits enough flexibility in setting position to the top, left, right, center, and middle. The software is a user-friendly application that a non-technician can understand and operate without technical help. Download the tool today.

Hi everyone!.

Im trying to put a "NumericTextBox" inside s "ForItem", cause i need extract some validation that i have in another file. and call some method that returns me a math result But when i try it, my proyect fails.

someone have  worked with something similar?

Hi Team,

Does Telerik have an option to export/download the report file in PowerPoint presentation format and allow our end users to edit before sending across the ppt?

Thanks

Dear Kendo Experts,

I hope this message finds you well.

I am currently facing an issue with custom validation error messages in a Kendo Grid. I have created a sample Dojo link to demonstrate the problem:

https://dojo.telerik.com/IgOLaREr

I have a kendo grid with a custom editor (dropdownlist) for a column (Category). 

In the provided Kendo Grid, I have two columns: "ProductName" and "Category". While "ProductName" has a default editor, "Category" has a custom editor (dropdown list).

I have defined custom validation error messages for both columns in the schema. However, the custom validation error message for the "Category" column does not appear when validation fails, unlike the "ProductName" column. Please refer the below screenshot.

Could you please assist me in resolving this issue? I would like the custom validation error message for the "Category" column to be displayed when validation fails, similar to the "ProductName" column.

Thank you very much for your time and assistance. I look forward to hearing from you soon.

Best regards,

Varun Shridhar.

In radscheduleview, added multiple resources and grouping based on custom resourceview, Also, added custom datatemplate for GroupHeaderContentTemplateselector. 

In the below yellow hightlighted place , (group header ) need to add Resource related information for the day in weekview. But couldnot  get exact datacontext of the group header while switching between dates,  Only able to get IResource from Groupheaderdescriptions. In IResource having only few properties for cusomization. 

So, could not able to bind any property to Group header template. Please suggest on this?

Request to Delete my Telerik Account, Telerik Forums account and all data associated with it