Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 616 through 630 (of 1,092 total)

← 1 2 3 … 41 42 43 … 71 72 73 →

Author

Replies

November 22, 2016 at 10:10 am in reply to: Is it possible to run a custom SQL command to set variables? #125692

guriddo.support

Participant

Hello,

I’m not sure that I understand exactly the problem.

You can of course do:

SELECT f1, f2, …. FROM ( SELECT .. LONG SELECT HERE )

i.e subselect and use it as select command.

Another possible solution is to use a custom function in PHP after obtaining the data.

See the example here

Kind Regards,

Will

Guriddo Support Team

November 21, 2016 at 4:22 pm in reply to: Is it possible to run a custom SQL command to set variables? #125681

guriddo.support

Participant

Hello,

In selectCommand you can not put more than one command. Also the way youi demonstrate is not correct.

I think that the 1. is a good solution.

Kind Regards,

Will

Kind Regards

Guriddo Support Team

November 21, 2016 at 4:19 pm in reply to: Ajax Success return data #125680

guriddo.support

Participant

Hello,

Thank you for the feedback.

Kind Regards,

Will

Guriddo Support Team

November 21, 2016 at 4:15 pm in reply to: Treegrid load expanded problem #125679

guriddo.support

Participant

Hello,

Could you please post a demo data in order to see where the problem is?
Also we have a good example here.

Kind Regards,
Will

Guriddo Support Team

November 18, 2016 at 1:45 pm in reply to: jqgrid/jquery ui, dragging column to scroll table? #125673

guriddo.support

Participant

Hello,

Which version of Guriddo jqGrid JS is used?

Regards,
Will

Guriddo Support Team

November 18, 2016 at 11:19 am in reply to: Combining multiple JSON feeds #125672

guriddo.support

Participant

Hello,

When local data array is used the jsonmap does not have effect.
In order to solve the problem in this case you will need to set the name like
json map.

If your data is like this:

var myjson = [
	{
		&quot;LGICUS01OperationResponse&quot;: {
			&quot;ca&quot;: {
				&quot;ca_phone_mobile&quot;: &quot;123&quot;,
				&quot;ca_request_id&quot;: &quot;01ICUS&quot;,
				&quot;ca_return_code&quot;: 0,
				&quot;ca_dob&quot;: &quot;30.09.1965&quot;,
				&quot;ca_last_name&quot;: &quot;Tracey&quot;,
				&quot;ca_num_policies&quot;: 0,
				&quot;ca_phone_home&quot;: &quot;&quot;,
				&quot;ca_email_address&quot;: &quot;REFROOM@TBHOLDINGS.COM&quot;,
				&quot;ca_house_name&quot;: &quot;Tracey Island&quot;,
				&quot;ca_policy_data&quot;: &quot;&quot;,
				&quot;ca_customer_num&quot;: 3,
				&quot;ca_first_name&quot;: &quot;Scott1&quot;,
				&quot;ca_house_num&quot;: &quot;&quot;,
				&quot;ca_postcode&quot;: &quot;TB14TV&quot;
			}
		}
	},
...
];

var myjson = [

{

"LGICUS01OperationResponse": {

"ca": {

"ca_phone_mobile": "123",

"ca_request_id": "01ICUS",

"ca_return_code": 0,

"ca_dob": "30.09.1965",

"ca_last_name": "Tracey",

"ca_num_policies": 0,

"ca_phone_home": "",

"ca_email_address": "REFROOM@TBHOLDINGS.COM",

"ca_house_name": "Tracey Island",

"ca_policy_data": "",

"ca_customer_num": 3,

"ca_first_name": "Scott1",

"ca_house_num": "",

"ca_postcode": "TB14TV"

}

...

];

Then in order this to work your jqGrid setup should be like this:

  
$(&quot;#jqGrid&quot;).jqGrid({
                datatype: &quot;local&quot;,
                data: myjson,
				// we set the changes to be made at client side using predefined word clientArray
                editurl: &#039;clientArray&#039;,
                colModel: [
                    {
			label: &#039;Customer Num.&#039;,
			name: &#039;LGICUS01OperationResponse.ca.ca_customer_num&#039;,
                        width: 75,
			key: true,
			editable: true,
			editrules : { required: true}
                    },
...
],
...
sortname: &#039;LGICUS01OperationResponse.ca.ca_customer_num&#039;
...
});

$("#jqGrid").jqGrid({

datatype: "local",

data: myjson,

// we set the changes to be made at client side using predefined word clientArray

editurl: 'clientArray',

colModel: [

{

label: 'Customer Num.',

name: 'LGICUS01OperationResponse.ca.ca_customer_num',

width: 75,

key: true,

editable: true,

editrules : { required: true}

...

sortname: 'LGICUS01OperationResponse.ca.ca_customer_num'

...

});

If you need demo we can prepare such one.

Kind Regards,
Will

Guriddo Support Team

November 17, 2016 at 10:08 am in reply to: Combining multiple JSON feeds #125669

guriddo.support

Participant

Hello,

It is a little bit confused, since you have two functions named initGrid, which I think is not correct.

Anyway – since you use form editing module in order to make updates on the server too one possible solution would be to use afterSubmit event in editRow and delRow methods.

In these events you have all the data and you can make your own ajax to post the data. Do not forget to return array at end of this vent. The syntax is:

    function editRow() {
        var grid = $(&quot;#jqGrid&quot;);
        var rowKey = grid.getGridParam(&quot;selrow&quot;);
        if (rowKey) {
            grid.editGridRow(rowKey, {closeAfterEdit: true, afterSubmit : function(data, postdata, oper) {
console.log(data);
console.log(postdata);
console.log(oper); // add or edit
return [true,&#039;&#039;]; // or return [false,&#039;error&#039;]; and do not forget that when using ajax you may need to use these with care
} });
        }
        else {
            alert(&quot;No rows are selected&quot;);
        }
    }

function editRow() {

var grid = $("#jqGrid");

var rowKey = grid.getGridParam("selrow");

if (rowKey) {

grid.editGridRow(rowKey, {closeAfterEdit: true, afterSubmit : function(data, postdata, oper) {

console.log(data);

console.log(postdata);

console.log(oper); // add or edit

return [true,'']; // or return [false,'error']; and do not forget that when using ajax you may need to use these with care

} });

}

else {

alert("No rows are selected");

}

Use similar code for add and del methods.

Kind Regards,
Will

Guriddo Support Team

November 16, 2016 at 1:08 pm in reply to: jqgrid/jquery ui, dragging column to scroll table? #125667

guriddo.support

Participant

Hello,

This is by design. The problem is that the grid header is explicitly set with overflow:hdden .

One possible solution is to use start and stop function of sortable method in order to set overflow auto oh header div when start dragging and hidden when stop – but in this case we need to have additional code to scroll the body data too. We will try to prepare a example, but I do not promise for the success.

Kind Regards,

Will

Guriddo Support Team

November 16, 2016 at 10:30 am in reply to: subgrid in treegrid #125666

guriddo.support

Participant

Hello,

Yes. When treeGrid is enabled the subGrid is disabled if both are set.

Kind Regards

Will

Guriddo Support Team

November 15, 2016 at 11:37 am in reply to: Combining multiple JSON feeds #125662

guriddo.support

Participant

Hello,

In your case I think it is good to use jsonmap option in colmodel. The option is described in the link.

We have prepared a example.

Kind Regards,

Will

Guriddo Support Team

November 15, 2016 at 10:57 am in reply to: Password data #125661

guriddo.support

Participant

Hello,

Thank you for the feedback. I think this is a good solution, since there is no common css style command which can mimic a text field as a password input field.

Kind Regards,

Will

Guriddo Support Team

November 11, 2016 at 10:25 am in reply to: Password data #125655

guriddo.support

Participant

Hello,

Thank you very much for the description and the test case provided.

Now I understand what you mean.

One possible solution is to use formatter and unformat function.

We have prepared a example which can be seen here , but I should say that this way the data can be seen without any problems with any people with little knowledge.

Please use this carefully.

Kind Regards,
Will

Guriddo Support Team

November 10, 2016 at 5:08 pm in reply to: Password data #125654

guriddo.support

Participant

Hello,

Should I understand that in grid instead table data test a input type = password is used.

Please send a pictures and any grid setup and response to support at guriddo dot net.

Kind Regards,

Will

Guriddo Support Team

November 10, 2016 at 3:33 pm in reply to: Password data #125652

guriddo.support

Participant

Hello,

I’m not sure that I understand exactly the problem.
Somme common suggestion – I’m not sure that passing passwords over the web is good idea, since the password can be seen very easy in the response (JSON or XML), but anyway …

It will be very useful if a example with a grid is used in order to understand correct the problem

The grid represent a data in tabular way. In order to hide some information you can use custom formatter and unformatter. The formatter can display **** in the grid, while when editing a unformat will be used to read the data.
You may want to look here:

Another possible solution is to hide the column in grid, but to edit it in editform – look at edithidden property in documentation.

In all cases, please provide a example in order to understand correct the problem.

Kind Regards,
Will

Guriddo Support Team

November 9, 2016 at 10:28 am in reply to: Combining multiple JSON feeds #125650

guriddo.support

Participant

Hello,

If I understand right I suggest you first to collect the data to array and then send it to the grid. You can do this using different format and settings.
Some information about how to configure the JSON data (little old ) you can find here

Please let us know if you have difficulties with this.

Kind Regards,
Will

Guriddo Support Team

Author

Replies

Viewing 15 replies - 616 through 630 (of 1,092 total)

← 1 2 3 … 41 42 43 … 71 72 73 →