grid configuration

OnRead="@Service.ReadComponents"
             TItem="@ComponentModel"
             Resizable="true"
             SelectionMode="GridSelectionMode.Single"
             FilterMode="@GridFilterMode.FilterMenu"
             EditMode="@GridEditMode.Inline"
             Height="100%"
             Pageable="true"
             Sortable="true"
             Groupable="false"
             SortMode="@SortMode.Single"
             @bind-Page="@Service.GridPageIndex"
             PageSize="@Service.GridPageSize"
             PageSizeChanged="@Service.PagerPageSizeChanged"
             OnUpdate="@Service.UpdateComponentAsync"
             OnCreate="@Service.CreateComponentAsync"
             @ref="@Grid" >

if use grid filter, the server-side query is completed successfully:

"skip": 0,
	"page": 1,
	"pageSize": 20000,
	"sorts": [],
	"filters": [
		{
			"logicalOperator": 0,
			"filterDescriptors": [
				{
					"member": "VersionName",
					"operator": 8,
					"value": "test"
				}
			]
		}
	],
	"groups": [],
	"aggregates": [],
	"groupPaging": false

if try to use the search:

"skip": 0,
	"page": 1,
	"pageSize": 20000,
	"sorts": [],
	"filters": [
		{
			"logicalOperator": 1,
			"filterDescriptors": [
				{
					"member": "ProductName",
					"operator": 8,
					"value": "test"
				},...
					"member": "LabHourlyRateCurrency.Value",
					"operator": 8,
					"value": "test"
				}
			]
		}
	],
	"groups": [],
	"aggregates": [],
	"groupPaging": false

it leads to 

The LINQ expression 'DbSet() .Join( inner: DbSet(), outerKeySelector: s => EF.Property(s, "VersionId"), innerKeySelector: p => EF.Property(p, "Id"), resultSelector: (o, i) => new TransparentIdentifier( Outer = o, Inner = i )) .Join( inner: DbSet(), outerKeySelector: s => EF.Property(s.Inner, "ProductId"), innerKeySelector: p0 => EF.Property(p0, "Id"), resultSelector: (o, i) => new TransparentIdentifier, Product>( Outer = o, Inner = i )) .Join( inner: DbSet(), outerKeySelector: s => EF.Property(s.Outer.Outer, "JurisdictionId"), innerKeySelector: a => EF.Property(a, "Id"), resultSelector: (o, i) => new TransparentIdentifier, Product>, ApprovalJurisdiction>( Outer = o, Inner = i )) .OrderBy(s => s.Outer.Inner.Name) .ThenBy(s => s.Outer.Outer.Inner.Version) .ThenBy(s => s.Inner.Name) .Where(s => s.Outer.Inner.Name.ToLower().Contains("2 card") && s.Outer.Outer.Inner.Version.ToLower().Contains("2 card") && s.Outer.Inner.Name.ToLower().Contains("test1") || s.Outer.Outer.Inner.Version.ToLower().Contains("test1") || s.Inner.Name.ToLower().Contains("test1") || s.Outer.Outer.Outer.FileApprovalNumber.ToLower().Contains("test1") || new ProductSubmissionCostModel{ SubmissionId = s.Outer.Outer.Outer.Id, ProductId = s.Outer.Outer.Inner.ProductId, ProductName = s.Outer.Inner.Name, VersionName = s.Outer.Outer.Inner.Version, Jurisdiction = s.Inner.Name, SubmissionDate = s.Outer.Outer.Outer.DateSubmission, FileApprovalNumber = s.Outer.Outer.Outer.FileApprovalNumber } .InvoiceNumber.ToLower().Contains("test1") || new ProductSubmissionCostModel{ SubmissionId = s.Outer.Outer.Outer.Id, ProductId = s.Outer.Outer.Inner.ProductId, ProductName = s.Outer.Inner.Name, VersionName = s.Outer.Outer.Inner.Version, Jurisdiction = s.Inner.Name, SubmissionDate = s.Outer.Outer.Outer.DateSubmission, FileApprovalNumber = s.Outer.Outer.Outer.FileApprovalNumber } .ChargeType.ToLower().Contains("test1") || new ProductSubmissionCostModel{ SubmissionId = s.Outer.Outer.Outer.Id, ProductId = s.Outer.Outer.Inner.ProductId, ProductName = s.Outer.Inner.Name, VersionName = s.Outer.Outer.Inner.Version, Jurisdiction = s.Inner.Name, SubmissionDate = s.Outer.Outer.Outer.DateSubmission, FileApprovalNumber = s.Outer.Outer.Outer.FileApprovalNumber } .LabHourlyRateCurrency.Value.ToLower().Contains("test1"))' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See

server code:

var result = await _mapper.ProjectTo<ComponentModel>(
                _corpDbContext.Component
                    .Include(_ => _.Function))
                .OrderBy(_=>_.ComponentIdentifier)
                .ToDataSourceResultAsync(request.DataSourceRequest);
            return new DataEnvelope<ComponentModel>()
            {
                Data = result.Data.Cast<ComponentModel>().ToList(), 
                Total = result.Total
            };

server Telerik.DataSource version 2.1.1

Hello,

We need to have string labels in our y-axis

Actually we have an int that matches to an Enum and instead of int number we want to print the Enum string representation

Based on the docs we can either use the Format expression or a Template but none of them allow us for example to use the expression

((MyEnum)value).ToString()

Hi,

is there a way to achive appointment precision like in the asp.net scheduler?

Let's say I add 2 appointments.

Starting at 8:30 and finishing at 9:15, and another one starting at 9:20.

The blazor scheduler result is going to be like this:

The asp.net scheduler result is going to be like this:

Thanks.

I have found that when the telerik grid creates a copy of my data for the editor, it doesn't correctly copy every field from the original object. I'm able to work around this by hooking into the state changed event and then using our own methods to copy properties from the original, but I'd like to know why it's not working by default.

I found a related post about a similar problem: https://www.telerik.com/forums/blazor-telerikgrid-editor-template-copy. However when I tried using the code posted there, it worked correctly and all my properties were copied into the cloned new instance. 

Has the logic for creating a clone changed since that forum post?

Is there any way to suppress the selection items appearing in the textbox portion of the control?

Example of my issue:

As the more items are selected the text box grows and pushes down. We have some pretty big selections we use sometimes and this makes the UI ugly. Would like it not to do that but still have the items the user selected in the control in the backend.

Code

Hello,

from your Web UI TabStrip doc:

RadTabStrip supports two layouts - Horizontal (default) and Vertical.

In Horizontal layout, the Align property allows you to specify the way tabs position themselves:

• Left - tabs will be left aligned;
• Right - tabs will be right aligned;
• Center - tabs will be centered;
• Justify - tabs will be proportionally resized to full-up the width of the tabstrip.

In Vertical layout, the values of the Align property are as follows:

• Left - tabs will be aligned to the top;
• Right - tabs will be aligned to the bottom;
• Center - tabs will be positioned in the middle;
• Justify - tabs will be proportionally resized to full-up the height of the tabstrip.

I am not able to find the same properties for the Blazor version of the control.

Thanks

Is there any way to solve this problem if the data type is text in my DB?

// Code 

What is the best way to implement a Clear-Button in a TextBox like in the ComboBox ?

I need it especially for a custom Filterrow in the GridControl.

Hi

I want to change the look and feel of some components, I think i need to override some k-xxx styles

How do i know which component uses which styles.

So for example the TelerikTextBox , if i want to change the border, which style does it use now?

Paul

Hi there,

I was hoping someone could help me with the problem I am having with the Excel Export feature. I have carefully reviewed the support docs to ensure that everything is set up correctly, however, the export is producing empty .xlsx files (no data in the export, despite there being nearly 1000 records displayed in the grid).

I've spent many hours troubleshooting and found that if I set the AutoGenerateColumns parameter to true, it fixes the issue. That said, I do not wish to have this option turned on.

Any and all help with this would very much be appreciated. Thank you!

Code Context:

Code-behind for my Razor page - here's how I declared the properties to initialize the data for the grid:

    [Inject]
    public IManageChemicalService ManageChemicalService { get; set; }

    public Telerik.Blazor.Components.TelerikGrid<Chemical> ManageChemicalGrid;

    public List<Chemical> Chemicals { get; set; }

    protected override async Task OnInitializedAsync()
    {
        Chemicals = (await ManageChemicalService.GetAllChemicals()).ToList();
    }

Razor page -here's how I set up the grid:

   <TelerikGrid Data="@Chemicals" @ref="ManageChemicalGrid"
             Pageable="true"
             PageSize="100"
             Sortable="true"
             Resizable="true"
             Reorderable="true"
             FilterMode="@GridFilterMode.FilterRow"
             Groupable="true"
             EditMode="@GridEditMode.Popup"
             OnCreate="@CreateHandler"
             OnUpdate="@UpdateHandler"
             OnDelete="@DeleteHandler">
    <GridToolBar>
        <GridCommandButton Command="Add" Icon="add">Add Chemical</GridCommandButton>
        <GridCommandButton OnClick="@ShowLoadingSign" Command="ExcelExport" Icon="@IconName.FileExcel">Export to Excel</GridCommandButton>
        <label><TelerikCheckBox @bind-Value="@ExportAllPages" />&nbsp; Export All Pages</label>
    </GridToolBar>
    <GridExport>
        <GridExcelExport FileName="ChemicalsExport" AllPages="@ExportAllPages" />
    </GridExport>

    <GridColumns>

        <GridColumn Field="@(nameof(Chemical.Id))" Editable="false" Filterable="false" Width="4%">
        </GridColumn>

          ...and many more defined columns, editor templates and commands