tony

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 7,976 total)
  • Author
    Replies
  • in reply to: Date range search in toolbar search #127668
    tony
    Keymaster

    Hello Kris,

     

    I can see two possible solutions for mow. Both of these are not tested.

     

    Use the between operator in toolbar searching.  The code for this is bt (set is as default if you want only this possibility). This will be possible only if your date-range picker widget support custom separator between the dates. In jqGrid the separator is and can’t be configured – it is hard coded for now. Demo with description is here

     

    The second option is to use a custom  search field where you should add your own code to separate the dates and build the search string, but I think that this is a little complex.

     

    Please let me know if you have a problem with the first option – we can make this better.

     

    Best Regards,

    Tony Tomov

    tony
    Keymaster

    Hello

    Your example works well and I think that you use addRowData to add a node instead of addChildNode method. See the docs here

     

    The demo of your code is located here

     

    To add a node – select the first row and add the needed data. You will see that the record is added in the appropriate place

     

    Best Regards

    • This reply was modified 5 months, 3 weeks ago by tony.

    Tony Tomov

    in reply to: Where are the examples for jqDatePicker? #127144
    tony
    Keymaster

    Hello,

    Thank you for the recommendation. We will try to fix this.

    Incorporating date Picker in jqGrid is done via setDatepicker method which is described into the docs. Below is the description:

     

    Construct a pop up calender used in the grid. The datepicker can be used in the editing modules or/and in search module.

    Parameters:

    • string $colname: (requiered) valid colname in colModel
    • array $options: – array with options for the datepicker. Can be all available options from jQuery UI datepicker in pair name=>value. In case of events a “js:” tag should be added before the value.
    • boolean $editing: determines if the datepicker should be used in editing modules. Deafult is true
    • boolean $seraching: determines if the datepicker should be present in the search module. Deafult is true.

    Example of using this command is in our demo site where a date picker is used. We have changed allmost all example containing data picker.

     

    In common rules the date picker should be used the same way as the jQuery UI autocomplete. If you are in this case , please let me know, I will prepare personally some example without grid, so that it is know how to use it.

     

    Best Regards,

    Tony

    • This reply was modified 2 years, 9 months ago by tony.

    Tony Tomov

    in reply to: jqGrid Demo – Bad link #127099
    tony
    Keymaster

    Hello,

     

    Thank you very much for finding this problem. We have fixed it.

     

    Please let us know if there is problem with this or any other.

     

    Best Regards,

    Tony

    Tony Tomov

    in reply to: Reduce the height of BS4 grid rows #127001
    tony
    Keymaster

    Hello,

     

    What you mean global setting – what you do is a global setting.

     

    As far as I remember the big height of  the table row of Bottstrap 4 is caused by the padding (defined in class table) which (I remember) is about 0.75rem. You can make the height of the row smaller if you reduce the top and bottom padding.

     

    By example to do this only for all jqGrid you can:

     

     

    Tony Tomov

    in reply to: Grouping Data questions #127000
    tony
    Keymaster

    Hello Kris,

     

    Thank you for posting your solution and let us know where the problem was.

     

    Kind Regards,
    Tony

    Tony Tomov

    in reply to: linked select dropdown inline edit #126748
    tony
    Keymaster

    Hello Pawel,

     

    We found your problem interesting and practical, so I have prepared a article in our Knowledge base. You can take a look at it here.

     

    The demo is here

     

    Please let us know if something is not clear.

     

    Kind Regards,
    Tony

    Tony Tomov

    in reply to: Capture sql string used to create filtered grid #126573
    tony
    Keymaster

    Hello,
     
    Currently there is no build in such method, but there is a method where
    you can obtain the WHERE clause when a search is in action.
     
    This is done with the method builSearch
     
    This can be something like this:
     

    Code:

     
    So after you are in search mode and the user activate the search the $where look like:
    “(OrderID = ‘10248’ AND ShipName = ‘Vins’ )”
    Youi can pass your own filters to it. A second parameter determines return mode
     
    Regards

    Tony Tomov

    in reply to: sortableRows after Drag and Drop #126572
    tony
    Keymaster

    Yes. This is correct.

    Kind Regards,

    Tony Tomov

    in reply to: Filter/Search Issues #126569
    tony
    Keymaster

    Hello Thomas,

     

    We have do the first step for resolving the problem

     

    To make this happen set in grid options

     

    useNameForSearch : true

     

    The option work only when the data is local. We plan to make this option true by default and do some more fixes in all search modules.

     

    You can get the fix from here

     

    Please let us know if the problem is fixed for you.

     

    Kind Regards,

    Tony Tomov

    in reply to: sortableRows after Drag and Drop #126568
    tony
    Keymaster

    Hello Murray,

     

    I just checked – in the current implementation in the jqGrid of the methods provided from jQuery UI it is not possible to have at the same time drag and drop and sortable in the same grid.

     

    Reason for this is that for drag and drop we use drag-able and droppable, while for sortable we use sortable

     

    To have booth we need to have to use only sortable like in the example

    More on this problem can be found here

     

    Kind Regards,

    Tony Tomov

    in reply to: Filter/Search Issues #126566
    tony
    Keymaster

    Hello Thomas,

    Unfortunately we do not have fixed this issue. The problem is that when we fix this the sorting will be destroyed.

     

    Currently we search solution which will meet these two requirements.

     

    Thank you for your patience. Personally I will let you know when we fix the problem.

     

    Kind Regards,

    Tony Tomov

    in reply to: Subgrid data does not display #126564
    tony
    Keymaster

    Hello,

     

    The subgrid will never execute since you have a error in the subgrid.

     

    You put a wrong direction to config file in sbgrid.php. Make it the same as in grid.php – i.e

    replace

     

     
    with
     

     
    Kind Regards,

    Tony Tomov

    in reply to: sortableRows after Drag and Drop #126563
    tony
    Keymaster

    Hello,

     

    Currently I do not check this , but why do you use sortable and not the build in method sortableRows

     

    Kind Regards,

    Tony Tomov

    in reply to: Downloading doesn't work today ! #126562
    tony
    Keymaster

    Hello,

     

    Thank you for let us know about these problems.

    Permanently we have problems with the trirand.com site. We work on the problem and will fix it ASAP.

    I have fixed the captcha. Please let us know if you have any problems with it.

     

    Thank you again for this notes.

     

    Kind Regards

     

    Tony Tomov

Viewing 15 replies - 1 through 15 (of 7,976 total)

Stay connected with us in your favorite flavor!