Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 91 through 105 (of 1,092 total)

← 1 2 3 … 6 7 8 … 71 72 73 →

Author

Replies

January 10, 2022 at 1:35 pm in reply to: jgGrid JS trying to show custom alert #127817

guriddo.support

Participant

Hello Luigino,

Thank you for be back to us.

The problem you posted is different from the Stack-overflow thread of late 2014. The difference is that the Oleg’s example uses inline edit, while your code uses form edit, which is not the same.

If in your code you use inline edit instead of form edit – this code will work.

Moreover in the latest version of Guriddo is possible to define your own validation error dialog, which can replace info_dialog function. The grid parameter that do this is validationCell event. See the parameters in the docs. This event replaces the info_dialog in cell and inline editing.

The reason not to use info_dialog in form editing is that we have here a lot of pop up windows and we found this very inconvenient. We just set the error text on top of the form in red color (as can be seen). If you really want to display your dialog in formedit, you can call your own function before return [false,”message”] . It will run again with the displaying the text.

Kind Regards,

Will

Guriddo Support Team

January 10, 2022 at 11:47 am in reply to: setAutocomplete with parameter #127812

guriddo.support

Participant

Hello,

This query should work. Maybe the problem is in the query and your settings for strict comparing the names when you write the SQL.

I suggest you first to try to use only like:



...

where ( upper(ct.bank ) LIKE upper( ? ) )

...

...

where ( upper(ct.bank ) LIKE upper( ? ) )

...

if you want to use LIKE %word% operator, maybe you can try with concat function that is used your database.

you can try to use ct.BANK instead of ~~ct.bank~~ in your query

The Autocomplete docs are here

Kind Regards,

Will

This reply was modified 4 years, 3 months ago by guriddo.support.

Guriddo Support Team

December 3, 2021 at 12:22 pm in reply to: Problem with grouping (espacilly ungroup) #127758

guriddo.support

Participant

Hello,

Thank you very much for found this problem.

We have found and fixed the problem.

Since you have active Subscription, please send a e-mail to the support team and we will send you the fix.

Thank you.

Kind Regards,

Will

Guriddo Support Team

December 3, 2021 at 11:16 am in reply to: Inline add row #127756

guriddo.support

Participant

Hello,

There is no build in way to get newly added rows when use addRowData.

To solve the problem you may create your own addRowData where after adding a row yo will add a class for it. This way you can easy then get all newly added rows.

You code can look like this (this is just idea)

function myAddRow (id) {
    $(&#039;#grid&#039;).addRowData(id, { id: &#039;0&#039; }, &#039;first&#039;);
    $(&#039;#&#039;+id, &#039;#grid&#039;).addClass(&#039;new-added-row&#039;);
}

function myAddRow (id) {

$('#grid').addRowData(id, { id: '0' }, 'first');

$('#'+id, '#grid').addClass('new-added-row');

}

Then to get the new added rows

var newrows = $(&quot;#grid tr.new-added-row&quot;)
...

1 2	var newrows = $("#grid tr.new-added-row") ...

Kind Regards
Will

Guriddo Support Team

November 25, 2021 at 9:59 pm in reply to: problem with custom_value on edit #127752

guriddo.support

Participant

Hello,

Yes it is normal. We pass the jQuery object. So to access the element you will need to use elem[0] for js element. Also you can directly use:

...

elem.value()

...

...

elem.value()

...

for quick get the value

Kind Regards,
Will

Guriddo Support Team

November 23, 2021 at 8:53 pm in reply to: problem with custom_value on edit #127747

guriddo.support

Participant

Hello,

Thank you very much for the test case. It help us to quickly find and fix the problem.

The problem is fixed in GitHub and you can get the latest build and test it.

Thank you.

Kind Regards,

WIll

Guriddo Support Team

November 18, 2021 at 8:43 pm in reply to: Check if grid column is hidden #127743

guriddo.support

Participant

Hello,

One possible solution is to use getColProp method for a given column, to check if it is hidden.

var column =  $(&quot;#jqGrid&quot;).jqGrid(&quot;getColProp&quot;, &quot;column_name&quot;);
if(column.hidden) {
    // do something
}

var column = $("#jqGrid").jqGrid("getColProp", "column_name");

if(column.hidden) {

// do something

}

To get all the hidden columns use getGridParam to get the colModel and loop to check the hidden columns

var colModel = $(&#039;#grid&#039;).jqGrid(&#039;getGridParam&#039;, &#039;colModel&#039;);
var hidden_cols = [];
for( var j = 0; j &lt; colModel.length; j++){ 
    if ( colModel[j].hidden === true) {
          hidden_cols.push(colModel[j].name);
    }
}

var colModel = $('#grid').jqGrid('getGridParam', 'colModel');

var hidden_cols = [];

for( var j = 0; j < colModel.length; j++){

if ( colModel[j].hidden === true) {

hidden_cols.push(colModel[j].name);

}

Kind Regards,
Will

Guriddo Support Team

September 20, 2021 at 10:53 am in reply to: Export to Excel – html encoded #127717

guriddo.support

Participant

Hello,

To resolve the problem you will need to define your own replaceStr function in exportToExcel method. The function should return just the original string

$(&quot;#jqGrid&quot;).jqGrid(&quot;exportToExcel&quot;,{
...
   replaceStr : function( str ) {
      return str;
   },
...
});

$("#jqGrid").jqGrid("exportToExcel",{

...

replaceStr : function( str ) {

return str;

...

});

Kind Regards,
Will

Guriddo Support Team

September 15, 2021 at 3:51 pm in reply to: selected a row, keep previous background on some cells #127715

guriddo.support

Participant

Hello,

We need to make some tests and I will replay to you soon.

Kind Regards
Will

Guriddo Support Team

September 14, 2021 at 11:32 am in reply to: selected a row, keep previous background on some cells #127712

guriddo.support

Participant

Hello,

Both classes (your one and the table-success ) have property !important.

In order to do what you want only one should be available in this case your one. With other words – comment the line in jqgrid bootstrap4 and do the following in your in-line style definition

&lt;style&gt;
...
.ui-jqgrid-btable tbody tr.table-success &gt; td
{
  background-color: #c3e6cb;
}

.rowGray {
  background-color: gray !important;
  color:white;
}
...
&lt;/style&gt;

<style>

...

.ui-jqgrid-btable tbody tr.table-success > td

{

background-color: #c3e6cb;

}

.rowGray {

background-color: gray !important;

color:white;

}

...

</style>

Regards
Will

Guriddo Support Team

September 9, 2021 at 4:27 pm in reply to: selected a row, keep previous background on some cells #127710

guriddo.support

Participant

Hello,

Please post your full CSS definition for the class rowGray.

(Sorry to ask this, but we need to be sure that we are close to your problem at our end)

Kind Regards,

WIll

Guriddo Support Team

September 9, 2021 at 8:58 am in reply to: selected a row, keep previous background on some cells #127708

guriddo.support

Participant

Hello,

How you define your custom background for the cells in css?
In which way you do this – do you use custom formatter or cellattr or rowattr?

Regards,
Will

Guriddo Support Team

September 2, 2021 at 12:52 pm in reply to: filterToolbar autoSelect function #127705

guriddo.support

Participant

Hello,

Thanks for this. You are absolutely right. We will change the example.

Thnks again.

Kind Regards
Will

Guriddo Support Team

September 1, 2021 at 7:12 am in reply to: filterToolbar autoSelect function #127703

guriddo.support

Participant

Hello,

Thanks for reporting.

IMHO I think that calling this method in loadComplete is not the right place. loadComplete event is a event that is executed every time you use: paging, sorting, filtering and etc. – in other words every time when new data is requested. This give different results.

I recommend you to call this method after the grid initializes and using setTimeout to give the chance the grid to load the initial data.

$(&quot;#grid252&quot;).jqGrid({...})
...
setTimeout(function(){
    $(&#039;#grid252&#039;).jqGrid(&#039;autoSelect&#039;,{...});
    ...
}, 100);

$("#grid252").jqGrid({...})

...

setTimeout(function(){

$('#grid252').jqGrid('autoSelect',{...});

...

}, 100);

Kind Regards
Will

Guriddo Support Team

August 10, 2021 at 6:20 pm in reply to: colMenuColumnDone event #127700

guriddo.support

Participant

Hello,

Try this:

colMenu: true,
colMenuColumnDone: function(cols,column,checked) {
    console.log(&quot;colMenuColumnDone &quot;+column+&quot; checked: &quot;+checked);
    if (column!=&quot;&quot;) {
        if (checked) {
            $(this).jqGrid(&quot;showCol&quot;,column);
        } else {
            $(this).jqGrid(&quot;hideCol&quot;,column);
        }
        setTimeout(function() {
            $(&quot;#YOUR_GRID_ID&quot;).jqGrid(&quot;resizeGrid&quot;,500,true,false);
        }, 50);
    }
},

colMenu: true,

colMenuColumnDone: function(cols,column,checked) {

console.log("colMenuColumnDone "+column+" checked: "+checked);

if (column!="") {

if (checked) {

$(this).jqGrid("showCol",column);

} else {

$(this).jqGrid("hideCol",column);

}

setTimeout(function() {

$("#YOUR_GRID_ID").jqGrid("resizeGrid",500,true,false);

}, 50);

}

Kind Regards,
Will

Guriddo Support Team

Author

Replies

Viewing 15 replies - 91 through 105 (of 1,092 total)

← 1 2 3 … 6 7 8 … 71 72 73 →