Telerik Forums
Kendo UI for jQuery Forum
1 answer
220 views

Hi,

I want to hide the date row in the scheduler when grouping is used. How can I achieve this?

Martin
Telerik team
 answered on 02 May 2023
1 answer
160 views
I once noticed the error code "ORA-00933: SQL command not properly ended" while working on a project that required creating SQL queries in an Oracle database.

The problem occurred when I attempted to utilise the WITH clause in my SQL query to construct a Common Table Expression (CTE). The inquiry was written as follows:
WITH my_cte AS (
  SELECT *
  FROM my_table
)
SELECT *
FROM my_cte
WHERE id = 1;
When I attempted to run the query, however, I received the following error message:
ORA-00933: SQL command not properly ended
This error notice perplexed me because the syntax of my query appeared correct to me. So, I read this, which suggested changing the query in order to avoid utilizing the column alias in that subquery. Is that correct? I don't think this could work. Can someone help me out?

Neli
Telerik team
 answered on 01 May 2023
1 answer
2.0K+ views

Extension of below question  

For reference link bellow: https://www.telerik.com/forums/how-to-set-data-attribute-for-multiselect-dropdown-li-element#5647546

Neli
Telerik team
 answered on 28 Apr 2023
0 answers
325 views

Hello everyone,

I am trying my hands at the Heatmap chart. I like what it does and have mostly managed to customize it the way I want.

However, I was wondering if there is a way to assign colors to the cells similar to how you can do 3 color scale conditional formatting in Excel.

For example, for the given set of values, the max value is shown with green marker color, the min in red, the median value in yellow.

And then all other values follow a gradient between these 3 primary colors based on what the value is.

The heatmap already does a gradient of color, and changes the shade from dark to light as the value goes down, but it does this in just one color, depending on which theme you chose. 

If it helps, I have attached a sample from excel.

 

Thank you.

Alok.

Alok
Top achievements
Rank 1
 asked on 27 Apr 2023
0 answers
90 views

I'm using template binding to display a list of users.   For each user, we have a yes/no radio button and a drop down.  The options available in the drop down are dependent on the radio button.  If the user picks "yes" in the radio, we give them 4 options in the drop down, if they select no, we give them 2 options.

I created a view model that contains an array of users and for each user I have an array of the available options for the drop down. 

ex. viewModel= [{UserId: 1, RBValue: true, DropDownId: 3, DropDownOpts: [1,2,3,4]}, {UserId: 2, RBValue: false, DropDownId:1, DropDownOpts: [1,2]};

And then in my template I have a select  as such:

<select source: DropDownOpts, value: DropDownId"></select

When the radio is updated, I modify the DropDOwnOpts for that item.   

When the page loads, it works fine.   The appropriate options appear in the dropdown list, but when I modify the DropDownOpts in the viewmodel, I can see the update in the console, but the options do not change.

Am I missing something obvious here?  Or is this not possible (I'm sure I can do it via js, but would rather not).

Thanks for any help.

Scott
Top achievements
Rank 1
 asked on 27 Apr 2023
1 answer
412 views
If I have a grid with a primary key (ID) defined, how can I scroll to a specific row using a key value?  I have Googled this and tried various approaches, but none has worked.    This is on navigating in from another page, with a key value passed in.
Georgi Denchev
Telerik team
 answered on 27 Apr 2023
0 answers
155 views

I have a page with a grid containing data for different countries.  The grid has a country column with a custom filter having countries as the data source for a treeview.   The country column has a filterable ui that calls a function CreateCountrySelect. The page also has country tiles and it gives users the ability to toggle between countries and have the grid filtered by countries.  When I select a country tile it toggles to the grid view and filters the data by the selected country with the treeview filter having the selected country checked by default.  The data is filtering by country fine. The issue I am having is setting the checkboxes in the treeview filter to the selected country.  The first time I click on the country filter the treeview has the selected country checked by default because it calls the function CreateCountrySelect.  Since that function is only fired once the treeview filter always has the same selected country checked.  How do I remove the previous checked country in the treeview and check the selected country when I change countries?  I tried calling the CreateCountrySelect method in the country tile click event (goToEntityListView ) but that did not work.

function createCountrySelect(element) {
            var grid = $scope.grid;
            var filterMenu = grid.thead.find("th[data-field='country']").data("kendoFilterMenu");
            var divElement = filterMenu.form.find("div.k-filter-help-text");

            $("form").removeAttr("title");
            vm.unflattedGeographicUnits = utilityLibrary.unflatten(vm.geographicUnits);

            vm.geographicUnitList = [];
            var selectGU;
            for (var i = 0; i < vm.unflattedGeographicUnits.length; i++) {
                selectGU = isGUSelected(vm.unflattedGeographicUnits[i].recordID);
                if (sessionStorage["checkedFilterCountriesId"] != undefined && sessionStorage["checkedFilterCountriesId"].length > 0) {
                    var checkedfilters = JSON.parse(sessionStorage.getItem("checkedFilterCountriesId"));
                    if (checkedfilters != undefined && checkedfilters != null) {
                        for (var j = 0; j < checkedfilters.length; j++) {
                            if (checkedfilters[j] == vm.unflattedGeographicUnits[i].recordID)
                                selectGU = true;
                        }
                    }
                }

                var guItem = {
                    recordID: vm.unflattedGeographicUnits[i].recordID,
                    expanded: true,
                    text: vm.unflattedGeographicUnits[i].name,
                    name: vm.unflattedGeographicUnits[i].name,
                    checked: selectGU,
                    items: addChildItems(vm.unflattedGeographicUnits[i].items, selectGU)
                };

                vm.geographicUnitList.push(guItem);
            }

            vm.countryDS = new kendo.data.HierarchicalDataSource({
                data: vm.geographicUnitList
            });


            vm.countryDS.sort({
                field: "text", dir: "asc"
            });

            divElement.kendoTreeView({
                name: 'countryFilter',
                checkboxes: {
                    checkChildren: true,
                    template: '<input type="checkbox" name="#=item.name#" id="#=item.recordID#"  #= item.checked ? "checked" : "" # />'
                },
                dataSource: vm.countryDS,
                template: '<span title="#=item.text#">#=item.text#</span>',
                dataTextField: "name",
                check: function (e) {
                    vm.GUCountryIsDirty = true;
                    function serialize(data) {
                        for (var i = 0; i < data.length; i++) {
                            if (data[i].checked) {
                                $scope.checkedFilterCountries.push(data[i].text.trim());
                                if (data[i].RecordID != undefined)
                                    $scope.checkedFilterCountriesId.push(data[i].RecordID);
                                else
                                    $scope.checkedFilterCountriesId.push(data[i].recordID);
                            }

                            if (data[i].hasChildren) {
                                serialize(data[i].children.view());
                            }
                        }
                    }
                 
                    $scope.checkedFilterCountries = [];                   

                    serialize(vm.countryDS.view());
                    var filter = {
                        logic: "or", filters: []
                    };
                    $.each($scope.checkedFilterCountries, function (i, v) {
                        filter.filters.push({
                            field: "countryGUList", operator: "contains", value: '[' + v.trim() + ']'
                        });
                    });
                    vm.dataSource.filter(filter);

                    var thFilter = grid.thead.find("th[data-field='country']")[0].children[0];
                    if ($scope.checkedFilterCountries.length > 0) {
                        thFilter.classList.add("k-state-active");
                    }
                    else {
                        thFilter.classList.removeClass("k-state-active");
                    }
                }
            });

            $timeout(function () {
                filterMenu.form.find("span[role='listbox']").css("display", "none");
                filterMenu.form.find("input[title='Value']").css("display", "none");
                filterMenu.form.find(".k-button").css("display", "none");
            }, 0);
        }

------------------------ 

    $scope.goToEntityListView = function (country) {
            selectedCountry = country;
            vm.selectedCountryID = selectedCountry.geographicUnitRecordID;
            vm.planSearch = "";
            vm.isTileView = false;
            vm.fromTileView = true;
            sessionStorage.removeItem("selectedCountryName");
            vm.selectedCountryName = selectedCountry.name;

            var filter = { logic: "or", filters: [] };
            $scope.checkedFilterCountries = [];
            $scope.checkedFilterCountries.push(selectedCountry.countryName);
            filter.filters.push({ field: "countryGUList", operator: "contains", value: '[' + selectedCountry.countryName.trim() + ']' });

            var grid = $scope.grid;
            grid.dataSource.filter(filter);
            kendoUtilitiesService.refreshGridData(grid, vm.planData);
            var thFilter = grid.thead.find("th[data-field='country']")[0].children[0];
            if ($scope.checkedFilterCountries.length > 0) {
                thFilter.classList.add("k-state-active");
            }
            else {
                thFilter.classList.removeClass("k-state-active");
            }
        }

            
Yen
Top achievements
Rank 1
 updated question on 26 Apr 2023
1 answer
108 views

I have a number that I need to display on the screen in the user's number format. The number can be of any length and have any number of decimals. I need the commas or periods to be displayed between the thousands and decimals as appropriate. For example:
123456789.12345 should display as 123,456,789.12345 in en-US

123456789.12345 should display as 123.456.789,12345 in de-DE

1234 should be 1,234 and 1.234 respectively. 

123.16 should be 123.16 and 123,16 respectively.

When I use kendo.toString(1234.165, "n") I get 1,234.17 which is not what I want. I want it to be 1,234.165

Neli
Telerik team
 answered on 26 Apr 2023
1 answer
108 views
For instance, if you type in 12/03/1910 11:00 AM and then place your cursor to the left of the "2" hit delete and attempt to type 1, the whole date string gets messed.  Same with any other place in the string.  Is there any setting I can apply to the control which would prevent this behavior?
Martin
Telerik team
 answered on 25 Apr 2023
1 answer
348 views

Is there a way to make the Editor toolbar buttons smaller? I'd like them to be small Bootstrap buttons.

Hetali
Telerik team
 answered on 24 Apr 2023
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
Date/Time Pickers
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)
SPA
Filter
Drawing API
Drawer (Mobile)
Globalization
Gauges
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
MultiColumnComboBox
Chat
DateRangePicker
Dialog
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
OrgChart
TextBox
Effects
Accessibility
ScrollView
PivotGridV2
BulletChart
Licensing
QRCode
ResponsivePanel
Switch
Wizard
CheckBoxGroup
TextArea
Barcode
Collapsible
Localization
MultiViewCalendar
Touch
Breadcrumb
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
Popover
DockManager
FloatingActionButton
TaskBoard
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
+? more
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?