Questions on Kendo UI for jQuery Forum

3 answers

149 views

Kendo filter field dropdown not loading.

I have a filter on a datasource which in return updates a grid. The following are the code to filter and its' template handler.

The problem with this is that, I can load the categories at first when I'm creating the filters. But when I save and reload the filter from local storage, the category dropdown does not load. Please help me with this. It loads up only on a fresh filter.

Thanks in advance.

@(Html.Kendo().Filter<Lovely>()
                                .Name("OrgFilter")
                                .ApplyButton(true)
                                .ExpressionPreview(true)
                                .DataSource("DataSource")
                                .Fields(f =>
                                {
                                    f.Add(p=>p.OrgName).Label("Organization");
                                    f.Add(p=>p.CategoryId).Label("Category").EditorTemplateHandler("CategoryDropdown");
                                    f.Add(p=>p.AsAtDate).Label("As At Date");
                                }))

<script>
function CategoryDropdown(container, options) {
        $('<input data-bind="value: value" name="' + options.field + '"/>')
            .appendTo(container)
            .kendoDropDownList({
                dataTextField: "CategoryId",
                dataValueField: "CategoryId",
                dataSource: @Json.Serialize(ViewData["Catogories"])
            });
    }
</script>

DropDownList

Filter

Grid

Templates

answered on 30 Jun 2022

1 answer

656 views

Export to pdf grid body font size

we can set diff font sizes for page, header, footer, but is it possible to set for exported grid body (table)?

Grid

answered on 29 Jun 2022

7 answers

167 views

Sort on Command column

Problem I'm having is first column with commands does not sort. Is this not supported?

$("#statusGrid").kendoGrid({
dataSource: {
transport: {
read: async function (options) {
KendoData_Read(
options,
BaseAbs3ApiUrl + "api/CustomerDetail/GetCustomerStatusDetail",
{ customerId: customerId }
);
}
},
sort: [{ field: "CreatedDate", dir: "desc" }]
},
dataBound: function (e) {
$(".k-grid-addDischarge").attr("title", "Add");
$(".k-grid-editDischarge").attr("title", "Edit");
$(".k-grid-viewDischarge").attr("title", "View");
},
toolbar: kendo.template($("#statusGridToolbarTemplate").html()),
scrollable: false,
excel: {
allPages: true,
fileName: "CustomerStatus.xlsx",
proxyURL: "/save",
filterable: true
},
excelExport: absKendoAutoWidthExcelExport,
sortable: true,
pageable: absKendoGridPageableDefault,
noRecords: { template: "No records to display." },
columns: [
{
command: [
{
name: "addDischarge",
text: "",
title: "Add",
visible: function (item) { return item.CanCreateDischargeDocument },
iconClass: "fas fa-plus fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = "/Customer/Discharge/Create/" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
},
{
name: "editDischarge",
text: "",
title: "Edit",
visible: function (item) { return item.CanEditDischargeDocument },
iconClass: "fa fa-pencil-alt fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = "/Customer/Discharge/EditByStatusChangeId/" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
},
{
name: "viewDischarge",
text: "",
title: "View",
visible: function (item) { return item.CanViewDischargeDocument },
iconClass: "fas fa-eye fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = BaseAbs2Url + "SSRSReports/Report.aspx?report=DischargeandTransferSummary&cuCustomerStatusChangeId=" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
}
]
, headerTemplate: "Document Actions", title: "Document Actions", width: "10em", sortable: true, field: "DocumentActions"
},
{ field: "Id", hidden: true },
{ title: "Status", field: "CurrentStatusTypeName", width: "20em", sortable: true },
{ headerTemplate: "Status Change Reason", title: "Status Change Reason", field: "CustomerStatusChangeReasonName", width: "20em", sortable: true },
{ headerTemplate: "Admit/Start of Care Date", title: "Admit/Start of Care Date", field: "AdmitStartCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.AdmitStartCareDate); } },
{ title: "Service Hold/End of Care Date", field: "ServiceHoldEndCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.ServiceHoldEndCareDate); } },
{ headerTemplate: "Resumption of Care Date", title: "Resumption of Care Date", field: "ResumptionCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.ResumptionCareDate); } },
{ headerTemplate: "Discharged Closed Date", title: "Discharged Closed Date", field: "DischaredClosedDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.DischaredClosedDate); } },
{ headerTemplate: "Status Comments", title: "Status Comments", field: "StatusChangeComment", width: "20em", sortable: true },
{ headerTemplate: "Status Change Date", title: "Status Change Date", field: "CreatedDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.CreatedDate); } },
{ headerTemplate: "Status Changed By", title: "Status Changed By", field: "CreatedByName", width: "15em", sortable: true },
{ title: "Discharge/Transfer Document Status", field: "DischargeDocumentStatus", width: "12em", sortable: true }
]
});

Grid

answered on 29 Jun 2022

0 answers

128 views

Spreadsheet data import/export in Angular

hello,

I want to access the spreadshet object in Angular, export and import data.

Example

(A completely imaginary example. I don't know how.)

 dataExport() {
    kendo.jQuery(this.spreadsheetEl.nativeElement).kendoSpreadsheet({
        function() {
            var sheet = $("#spreadsheet").data('kendoSpreadsheet').activeSheet();
            var range = sheet.selection();
            console.log(sheet.toJSON());
        }
    });
  }

how can I do it ?

thanks in advance

SPA

Spreadsheet

updated question on 29 Jun 2022

1 answer

197 views

Pagination in ImageBrowser of Kendo Editor

Hello,

I am working with application where I have thousands of images to load on ImageBrowser of Kendo Editor.

ImageBrowser is getting stuck as having too many images to load, Can we have any option to add pagination or lazy loading in ImageBrowser?

So, I can load only 20 images at a time and other based on request.

Please note that I am fetching images from controller method which returns list of FileBrowserEntry as below.

Thanks,

Trusha

answered on 29 Jun 2022

1 answer

114 views

filemanager: Drag and drop validation

Hi Team,

I would like to fire a validation post drag but pre-drop, this should allow me to cancel the drop and show a message to enduser explaining the cause.

the drop event only allows to modify the rendered alert dialog but it doesnt allow me to cancel the event altogether.

any help is appriciated.

Regards,

Ashutosh

FileManager

answered on 29 Jun 2022

0 answers

175 views

Scheduler/ParseDate - Developer timezone specific?

Hi,

I'm not sure if the issue I have is related to kendo ui, but seeing an issue where code I run on my local computer on central time works fine, but when I deploy to the server (eastern time), some of my dates are shifting in the Scheduler control when I iterate through it.

I'm using the kendo.parseDate function on start/end dates

return kendo.parseDate(kendo.toString(input, 'd')).toLocaleDateString("en-US");

That works fine locally, but deployed to the server shifts an hour, which then saves the wrong date in my database.

Is there a timezone saved anywhere in the configs for developer machine that might be getting pushed to server? Switching my computer timezone to eastern and then deploying seems to work fine.

Thanks

Scheduler

asked on 28 Jun 2022

1 answer

415 views

Using MultiSelect column to achieve Mutli Column design

Hi,

I was researching available control in Kendo to achieve my requirements it seems that multi-select control is what I need. but I am unsure how i do the templating for the control. my markup for the dropdown is

<select id="users">
<option value="1" data-email="abc@email.com">User 1</option>
<option value="2" data-email="12@email.com">User 2</option>
<option value="3" data-email="adc@email.com">User 3</option>
<option value="4" data-email="anmf@email.com">User 4</option>
</select>

what I wanted to achieve is when the user is selecting the option to show User 1 - abc@email.com. then upon selected, the tag to show User 1.

I understand that multi-column combo box is able to achieve this but i need to be able to select multiple options. I also prefer to render the control via HTML way instead of using json data source

MultiColumnComboBox

MultiSelect

answered on 28 Jun 2022

1 answer

123 views

Use gantt within Kendo Drawer - position right

Hi,

I am trying to use Gantt widget with Drawer located at the right side.

For some reason, when I position drawer to the right, even with mini mode it is always outside of the screen (horizontal scroll appears) - if i expand drawer, it basically expands it to the right, and remains outside screen, horizontal scroll just expands area.

When drawer is positioned on the left it works normally (pushes gantt for width of drawer).

Behavior can be observed in following Dojo:

https://dojo.telerik.com/EdIQaXeY

Thank you very much

Regards

Vedad

Drawer

Gantt

answered on 28 Jun 2022

1 answer

686 views

Load default value to server filtering combobox

I'm using the Kendo combobox on a edit form. I'm loading initial values into the comboboxes on page load by using the "value" and "text" properties. I have autobind set to false. If I click the "clear" button it doesn't actually clear out the text value until the second time I click it. It looks like the first time I click clear it loads the actual data items and then selects the value I have it set to. The second time I click clear it actually works. What is the proper way to configure this to load values from the server and preload a specific item when the control initializes?

 @(Html.Kendo().ComboBox()
                            .Name("combo" + item.DataField.ID)
                            .Filter("contains")
                            .DataTextField("DataTextField")
                            .DataValueField("DataTextValue")
                            .Placeholder("Select an item...")
                            .AutoBind(false)
                            .ClearButton(true)
                            .DataSource(source =>
                            {
                                
                                source.Custom()
                                    .ServerFiltering(true)
                                    .ServerPaging(true)
                                    .PageSize(40)
                                    
                                    .Type("aspnetmvc-ajax") //Set this type if you want to use DataSourceRequest and ToDataSourceResult instances
                                    .Transport(transport =>
                                    {

                                        transport.Read(r =>
                                        {

                                            
                                            r.Action("Virtualization_ReadComboEdit3", "Search", new { dataFieldId = item.DataField.ID }).Type(HttpVerbs.Post).Data("getFormData");



                                        });
                                        

                                    })
                                    
                                    .Schema(schema =>
                                    {
                                        schema.Data("Data") //define the [data](https://docs.telerik.com/kendo-ui/api/javascript/data/datasource#configuration-schema.data) option
                                              .Total("Total"); //define the [total](https://docs.telerik.com/kendo-ui/api/javascript/data/datasource#configuration-schema.total) option
                                    });
                            })
                        .HtmlAttributes(new { style = "width:100%;", data_parent_id = (item.DataField.ParentDataFieldID!=null ? item.DataField.ParentDataFieldID.ToString() : ""), data_conditional = item.DataField.IsConditionListener })
                        .FooterTemplate("<b>#: instance.dataSource.total() # items found<b/>")
                        .Events(e =>
                        {
                            e.Select("onSelectCombo");
                            e.Open("onOpenCombo");
                            e.Change("onChangeCombo");



                        })
                        .Virtual(v =>
                        {
                            v.MapValueTo("dataItem");
                            v.ItemHeight(26);
                            v.ValueMapper(e => "function(options) { dropdownMapper(options," + item.DataField.ID + "); }");
                        })
                        .Value(item.DataField.CurrentFieldValueSingle.ToString())
                        .Text(item.DataField.CurrentFieldText)
                            )

ComboBox

answered on 28 Jun 2022