{ "intReportID" : "1245", "sysReportNum" : "12-336", "sysAddress" : "9TH Ave SE & Hill St SE", "sysReportDate" : "1/5/2012 8:57:00 PM", "intUnitType" : "1", "vchLastName" : "PROUSE", "vchFirstName" : "CRYSTAL", "chrGender" : "F", "datDOB" : "3/3/1979 12:00:00 AM", "bolVehOwnerSame" : "False", "Gender" : "Female" }{ field: "datDOB", title: "DOB", format: "{0:M/d/yyyy}" }{fields: { "datDOB" : { type: "date"}}}47: 11/11/195848: 1/11/196949-62: blank63: 3/25/1959Hi,
I have a screen with 3 vertical panes, but one of the panes is not required for all the interactions and I would like to hide it. I know I can remove the pane, but then means I have to reload content every time.
Is there a way to hide the pane (and the bar) and then, when needed make it reappear?
matt

Hi everyone,
When I load a page that contains a Kendo grid, I check if there is a state saved in the localStorage of the user. If so I set these options to the grid.
Here is my code :
var grid = $("#" + gridName).data("kendoGrid");
var options = localStorage["kendo-" + gridName];
if (options) {
var toolBar = $("#" + gridName + " .k-grid-toolbar").html();
grid.setOptions(JSON.parse(options));
$("#" + gridName + " .k-grid-toolbar").html(toolBar);
$("#" + gridName + " .k-grid-toolbar").addClass("k-grid-top");
}
My issue is : when the grid contains a template that format a date, the format is not applied.
Here is the code of my grid :
@(Html.Kendo().Grid<RepairCheckViewModel>()
.Name("GridOpenCalls")
.Columns(columns =>
{
columns.Bound(c => c.IntId).Title(Resources.TicketId);
columns.Bound(c => c.RepairCheck.Engineer).Title(Resources.Engineer);
columns.Bound(c => c.RepairCheck.EpId).Title(Resources.EPId);
columns.Bound(c => c.RepairCheck.ProductDescription).Title(Resources.ProductDescription);
columns.Bound(c => c.ReceptionDate).Title(Resources.ReceptionDate);
columns.Bound(c => c.RepairCheck.MaterialStatus).Title(Resources.HardwareStatus);
columns.Bound(c => c.RepairCheck.MaterialSite).Title(Resources.HardwareSite);
columns.Bound(c => c.RepairCheck.MaterialLocalisation).Title(Resources.HardwareLocation);
})
.ToolBar(tools =>
{
tools.Excel();
} )
.Excel(excel => excel
.FileName("OpenCalls.xlsx")
.Filterable(true)
.ProxyURL(Url.Action("Export_Save", "Base"))
.AllPages(true)
)
.Events(e => e.DataBound("resolveGrouping").DataBound("saveState"))
.Resizable(resize => resize.Columns(true))
.Sortable()
.Groupable(group => group.Enabled(true))
.Filterable(filtr => filtr.Enabled(true))
.Pageable(pageable => pageable
.Refresh(true)
.PageSizes(true)
.ButtonCount(5)
.PageSizes(new[] {30, 60, 100})
)
.DataSource(dataSource => dataSource
.Ajax()
.PageSize(30)
.ServerOperation(true)
.Read(read => read.Action("GetOpenEpsdTickets", "Dashboard"))
)
.ClientRowTemplate(
"# if (RepairCheck.MaterialStatus == \"USE\") {# <tr class=\"highlight\"> #}else{# <tr> #}#" +
"#var groups = $(GridOpenCalls).data('kendoGrid').dataSource.group().length;#" +
"#if(groups > 0) {#" +
"#= new Array(groups + 1).join('<td class=\"k-group-cell\"></td>') #" +
"#}#" +
"<td>#= (IntId == null) ? ' ' : IntId #</td>" +
"<td>#= (RepairCheck.Engineer == null) ? ' ' : RepairCheck.Engineer #</td>" +
"<td> #=RepairCheck.EpId# </td>" +
"<td> #=RepairCheck.ProductDescription# </td>" +
"<td> #=kendo.toString(kendo.parseDate(RepairCheck.ReceptionDate), 'dd/MM/yyyy HH:mm')# </td>" +
"<td> #=RepairCheck.MaterialStatus# </td>" +
"<td> #=RepairCheck.MaterialSite# </td>" +
"<td> #=RepairCheck.MaterialLocalisation# </td>" +
"</tr>"
)
)
Here is how the date is displayed : https://s10.postimg.org/4pqal9i61/date_Format.png
I tried to comment the js code that load the settings. If I do so, the format if the date is correct.
Can you help me ?
Thank you in advance.

I think that declaration file (kendo.all.d.ts) is missing declaration, where second parameter for append method is not required (based on this example).
append(item: any): kendo.ui.Menu; //currently missingappend(item: any, referenceItem: string): kendo.ui.Menu;append(item: any, referenceItem: JQuery): kendo.ui.Menu;I think that this is the way, how can I add menu item if there are no items yet in the menu?
I would like to limit the text inside my kendo scheduler month view as it is affecting other text elements inside the date box.
Please refer the screen shot.
I tried to use the below code of my event-template that identifies if the text length is greater that 10 then print "NA" which I'm not suppoed to do.Instead I would like to trim the word and display in the date box..
<span class="bold"> #: kendo.toString(title.length>10 && title.slice(0,10) || title) # </span> //not working
<script id="event-template" type="text/x-kendo-template"> <div style="background-color: #: kendo.toString(colorId, "hh:mm") #;height: 100%"> <p class="bold"> <span class="bold"> #: kendo.toString(title.length>10 && "NA" || title) # </span> <span> <small>(#: kendo.toString(start, "hh:mm") #)</span>-<span class="">(#: kendo.toString(end, "hh:mm") #) </<small></span> <span class="bold pull-right"> #: kendo.toString(trip.length) # Trips </<span> </p> <h3 style="background-color: #: kendo.toString(colorId, "hh:mm") #"> </h3> </div> </script>
This demo doesn't work as expected. Window is jumping around (when dragging) and there are no restrictions.

Hi guys,
I'm trying to set a validation rule on my "email" column so that all rows inserted by user contain unique emails.
Normally i would do something like this with a counif formula.
My problem is that i want this to be dynamic and apply to each new row.
validation: {from:"AND(COUNTIF(A:A,A3)=1)",dataType: "custom",messageTemplate: "Email must be unique",type: "reject"}Hi,
I am having a problem figuring out how to fit an assignment table into the selected values of my DropDownList. Normally when I am using lookup tables I can set the selected value(single select) easily. Here we have a one to one as shown below and it works fine as the corresponding model for the header table has one value in a column that is used to select the value from the list(from a lookup table "changeTypeList"). See below
Model:
public SelectList changeTypeList = new SelectList((from a in entity.luChange_Type select a.Change_Type_Desc).ToList());
EditorTemplate:
@model DatabaseRepositoryTool.Models.DB_Changes_Header
........
@Html.DropDownListFor(m => m.Change_Type_Desc, Model.changeTypeList)
Now I have to add a release MutliSelect DropDownList in the editor template for adding and modifying records. I need to populate it much in the same way I did above, using a lookup table of all possible values. Once I have populated it I need to use an assignment table to figure out which ones need to be selected as well as saved.
Schema:
The assignment table holds rows for each release assignment, given to a header record, and has a foreign key "Release_Name" as a key to the lookup tables primary key. It also stores the header table record's ID to link it to the header table.
Problem:
How do I go about populating the editor template with a MultiSelect DropDownList that is populated by a lookup table while setting the selected values based on the assignment table? I am using the pop-up editor in a Kendo grid and made a custom editor template for it.
I have no code to show as I cannot find any examples of how to do this.
