Telerik Forums
Kendo UI for jQuery Forum
11 answers
826 views
I am using Kendo UI Web v2012.3.1315.

On my grid there is a DOB field for Date of Birth.  I have attached the DOB values that show in the grid.

I build my data as a string in JSON format here is an example:
{ "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" }
The columns are also defined in JSON:
{ field: "datDOB", title: "DOB", format: "{0:M/d/yyyy}" }
Same with the Schema Model:
{fields: { "datDOB" : { type: "date"}}}
The DOB column sorts mostly fine.  In decending order the blanks are all at the end of the grid which is okay.  But in Ascending order the blanks start at position 49 and position 48 is incorrect:
47: 11/11/1958
48: 1/11/1969
49-62: blank
63: 3/25/1959
You would think Ascending would put the blanks at the start and not mess up the sort order of one item.

Any ideas?
Sahir
Top achievements
Rank 1
 answered on 13 Aug 2016
3 answers
299 views
Hey, does anyone know how to solve this problem I am having (See image below). The issues are:
1. In the red-highlighted section, when I click export to pdf everything shows correctly. However if I export to excel I get blank fields (again see image below). Why is this?!?!?!

2. In the orange-highlighted section, the field is suppose to be empty, so the excel is actually displaying the grid correctly. But the PDF is displaying the value "null". Why is that?!?!
Alex Hajigeorgieva
Telerik team
 answered on 12 Aug 2016
5 answers
1.1K+ views
Hi,

I'm trying to make a backoffice order editor using catalog with referenced products.

Basically i've a Grid with severals columns
- Product Picture
- Product Code
- Description
- Quantity
- Unit Amount
- VAT Rate
- Total Amount

Product Code editor is a DropDownList on which we can select the desired product.
After selecting product i need to set all others cells values on this row but i've no idea how to do that.

VAT Rate is a ForeingKey Column (DropDownList Editor)

Any help on this ?

Thanks in advance,
Best Regards.
Boyan Dimitrov
Telerik team
 answered on 12 Aug 2016
1 answer
784 views

Hi,

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

Vessy
Telerik team
 answered on 12 Aug 2016
1 answer
158 views

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.

Dimo
Telerik team
 answered on 12 Aug 2016
1 answer
95 views

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 missing
append(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?

T. Tsonev
Telerik team
 answered on 12 Aug 2016
1 answer
224 views

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>

Dimiter Topalov
Telerik team
 answered on 12 Aug 2016
3 answers
130 views

This demo doesn't work as expected. Window is jumping around (when dragging) and there are no restrictions.

Ianko
Telerik team
 answered on 12 Aug 2016
2 answers
480 views

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"
}

Erik
Top achievements
Rank 1
 answered on 11 Aug 2016
1 answer
246 views

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.

Eyup
Telerik team
 answered on 11 Aug 2016
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
DatePicker
Spreadsheet
Upload
ListView (Mobile)
ComboBox
TabStrip
MultiSelect
AutoComplete
ListView
Menu
Templates
Gantt
Validation
TreeList
Diagram
NumericTextBox
Splitter
PanelBar
Application
Map
Drag and Drop
ToolTip
Calendar
PivotGrid
ScrollView (Mobile)
Toolbar
TabStrip (Mobile)
Slider
Button (Mobile)
Filter
SPA
Drawing API
Drawer (Mobile)
Globalization
LinearGauge
Sortable
ModalView
Hierarchical Data Source
Button
FileManager
MaskedTextBox
View
Form
NavBar
Notification
Switch (Mobile)
SplitView
ListBox
DropDownTree
PDFViewer
Sparkline
ActionSheet
TileLayout
PopOver (Mobile)
TreeMap
ButtonGroup
ColorPicker
Pager
Styling
Chat
MultiColumnComboBox
Dialog
DateRangePicker
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
TextBox
OrgChart
Accessibility
Effects
PivotGridV2
ScrollView
Switch
TextArea
BulletChart
Licensing
QRCode
ResponsivePanel
Wizard
CheckBoxGroup
Localization
Barcode
Breadcrumb
Collapsible
MultiViewCalendar
Touch
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
TaskBoard
Popover
DockManager
FloatingActionButton
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
TimePicker
BottomNavigation
Ripple
SkeletonContainer
Avatar
Circular ProgressBar
FlatColorPicker
SplitButton
Signature
Chip
ChipList
VS Code Extension
AIPrompt
PropertyGrid
Sankey
Chart Wizard
OTP Input
SpeechToTextButton
InlineAIPrompt
StockChart
ContextMenu
DateTimePicker
RadialGauge
ArcGauge
AICodingAssistant
SmartPasteButton
PromptBox
SegmentedControl
+? more
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?