Telerik Forums
Kendo UI for jQuery Forum
1 answer
606 views
Hello,

I'm experimenting with the Kendo Grid's filtering API function. I'm wondering if the API has any functionality for taking in an SQL string for filtering, at least a WHERE clause. Something like the following:

        $('#kendoGrid').data('kendoGrid').dataSource.filter('WHERE status = N');

Thank you.
Stefan
Telerik team
 answered on 10 Mar 2017
10 answers
2.1K+ views
I have a MVC Grid which is loading fine on the initial load. It uses the following code:

.DataSource(dataSource => dataSource 
        .Ajax()
        .PageSize(100)
    .Read(read => read.Action("AccountByType", "Organization", new { AccountType = 1 }))
)

I can successfully refresh the grid by calling the following:

$("#AccountGrid").data("kendoGrid").dataSource.read();

However, I need to change the query value that is passed in based on different selections the user makes on the page. So for example, I need to change the AccountType from 1 to 2 and refresh the grid. I tried the following:

$("#AccountGrid").data("kendoGrid").dataSource.options.transport.read.url = "/Organization/AccountByType?AccountType=2";
$("#AccountGrid").data("kendoGrid").dataSource.read()

But it doesn't work. Any suggestions on how to make this work?



Stefan
Telerik team
 answered on 10 Mar 2017
8 answers
688 views

Hi,

I want something like progress bar in each cell. Please see attachment. so let say in my cell, i show something like 100/1000 (i.e 10%) then a small progress bar should be shown under the value of cell. please see attachment's "Total" column. also it should be dynamically changing. so lets say user changes some value in other cell and due to this, at client side, the total becomes (200/1000) then progress bar should be changed accordingly.

if its not provided by telerik, can you please guide how to achieve the same.

Alex Hajigeorgieva
Telerik team
 answered on 10 Mar 2017
10 answers
322 views

I have a spreadsheet, with a datasource which retches remote data. When I sort the spreadsheet and edit row 2 (which was originally row 100), the datsource thinks that I have edited row 100. Is there a solution to this?

Marc

Marc
Top achievements
Rank 1
 answered on 10 Mar 2017
1 answer
182 views

As the titles says, you can try it for your self in your own demo, http://demos.telerik.com/kendo-ui/grid/editing-popup with an IPad.

Open the popup for editing and you can still scroll the grid in the background. You can also try to move the popup, but instead you scroll the grid.

This is a big problem if the modal window is so big that you have to move/scroll the window. If you try to do that you only scroll the grid behind the modal window and everything seems stuck...

Stefan
Telerik team
 answered on 10 Mar 2017
2 answers
526 views

Hello!

 

We are currently using the Kendo UI Grid component to display data about people. Right now, for each column we can have one or two filters by setting the option extra to 'true'.

 

But now we need more filters. We need to be able to add dynamically more than two filters. Is there an out-of-the-box way to achieve that? Our idea is to add an extra button next to the 'Apply' and 'Clear filter' buttons that allows us to add another filter.

We noticed that the filter are using binding, is there a way to use it to add more filters?

 

Best Regards

Jyothsna
Top achievements
Rank 1
 answered on 10 Mar 2017
3 answers
71 views

Hello, please see the attached image. The filter by value on my spreadsheet has the checkbox overlapping the values.How can I fix this...any help would be appreciated.

 

Thanks!

Phani

Ivan Danchev
Telerik team
 answered on 10 Mar 2017
2 answers
2.6K+ views

Hi,

 

Is there a way to instantiate a blank NumericTextBox when editting a "Number" field who's value is 0?

In other words, if I have numeric fields in my grid and their value is 0, I want to show the 0 on the grid. And when the user edits the field, I'd like to a NumericTextBox to show with no value. If the user does not give a new value, and 'blurs' the text box, the underlying value in the text box does not change.

Currently, when I edit a number who's value is 0 or null, the 0 shows in the text box. I just think it would be a better user experience if the 0 disappeared when editing the value.

Here is my attempt at such an editor. This is not working since this code will change the datasource value to null if textbox is left blank, which triggers the grid save event, and a whole host of other things.

 

$('<input  class="text-right" name="' + options.field + '"/>')
.appendTo(container)
.kendoNumericTextBox({
decimals: 0,
format: 'n0',
step: 1,
spinners: false
}).off("keydown").on({
'focus': function () {
if (!$(this).val() == 0) {
$(this).val('');
console.log('huh?', this.value, $(this).val(), arguments);
}
},
'blur': function () {
if ($(this).val() == "") {
console.log('wha?', this.value);
$(this).val("0");
}
}
});

Jeff
Top achievements
Rank 1
 answered on 09 Mar 2017
2 answers
95 views

I'm working on a project that is using the kendoGrid and odata service with virtual scrolling enabled.

 

The data we are pulling into the the grid doesn't use a traditional id number for it's primary key, so to have something that looks like an id number in the table we created an id column and append the number via a column template, which looks like this.

 

let _columns = [{

   field: 'rowNumberer',
   title: '#',
   template: '#= ++rowNumber #',
   width: 30
}

 

So the issue we are having is that as you scroll down the page the number increments fine, but it's also increments when you scroll up which throws the count off.

Is there another way to handle this?

Philip
Top achievements
Rank 1
 answered on 09 Mar 2017
1 answer
189 views

We have a simple grid having a the filters in a row. When the grid has a horizontal scrollbar, and the user is navigating using tab across the filters, only the header scrolls and not the body. Check the attached gif and below is its source code (which is a straightforward demo on Telerik):

http://dojo.telerik.com/

Dimiter Topalov
Telerik team
 answered on 09 Mar 2017
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
Licensing
ScrollView
Switch
TextArea
BulletChart
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
TimePicker
FloatingActionButton
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
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
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?