[ivanpeevskiParticipant]

Hi Abdul,

Thank you for the additional information. Disabling selection(including when using methods) is the expected behavior of the grid, but there are still some ways to achieve your functionality:
If possible, you can use a local version of jqxgrid.selection.js and modify the if clause you shared above.
If this is not possible, please have a look at the example here: https://jsfiddle.net/zu20dkny/
In the demo grid, selection is only possible through methods by modifying the allowSelect variable.

I hope this was of help!
If you have any other questions, please do not hesitate to contact us again.
Best regards,
Ivan Peevski
jQWidgets Team
https://www.jqwidgets.com/

[ivanpeevskiParticipant]

Hi Serdar,

Please have a look at the example here for a sample code: https://jsfiddle.net/tu057d4f/
You will see that all operations begin with a beginupdate method and end with endupdate method, which improves performance when making multiple changes at once.

Best regards,
Ivan Peevski
jQWidgets Team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hi abd_wasey,

When selectionmode is set to ‘none’, selection with mouse click will be disabled. If you wish to disable the hover effect when the mouse is over a row, you can use the enablehover: false property.

Have a look at the example here: https://jsfiddle.net/3eo5juf4/

If you have any other questions, please do not hesitate to contact us again!
Best regards,
Ivan Peevski
jQWidgets Team
https://www.jqwidgets.com/

[ivanpeevskiParticipant]

Hi AppBuilder,

default.php seems correct to me and the problem comes from data.php
The issue comes from echo $user_id. JavaScript expects to receive a valid JSON object($employees in this case), but $user_id disrupts the object and makes it invalid. By removing the line, the app should work.

Using the Network tab (F12 -> Network) you can check if the page can find data.php and what is the response from it.
If the two pages are in different directories, then yes, you need to change it to the correct one.
If it still doesn’t work, try to open the file and see what is the content of $employees, since it is difficult to say without seeing the DB.

I hope this helps!
If you have any other questions, please do not hesitate to contact us again
Best regards,
Ivan Peevski
jQWidgets Team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hi jilarue,

Thank you for reporting the issue!
I have created a work item regarding this and we will work on finding the problem.
Until a fix becomes available, it is possible to manually fix the issue inside the Excel file:
The displayed numbers still represent the actual dates, so by setting the cells format to Date, the values will be formatted correctly

If you face any other problems, please do not hesitate to contact us again.
Best regards,
Ivan Peevski
jQWidgets Team

https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hi msoriano,

Please have a look at the updated fiddle, based on the one shared above: https://jsfiddle.net/qy1mw0ck/2/

You will see that after filtering, the first entry can be checked.

If you have any other questions, please do not hesitate to contact us again.
Best Regards,
Ivan Peevski
jQWidgets team
http://www.jqwidgets.com

[ivanpeevskiParticipant]

Hi olegr,

Thanks for letting us know!

Until the issue gets fixed, there is an easy workaround solution by modifying the php file to ignore the list column if it has the default value.
Using the Grid Server Filtering demo here as an example: https://www.jqwidgets.com/jquery-widgets-demo/demos/php/serverfiltering.htm?light

The serverfiltering_data.php file should be modified in the following way:

<?php
include ('connect.php');
// Connect to the database
// connection String
$mysqli = new mysqli($hostname, $username, $password, $database);
/* check connection */
if (mysqli_connect_errno())
	{
	printf("Connect failed: %s\n", mysqli_connect_error());
	exit();
	}
$query = "SELECT ShipName, ShipAddress, ShipCity, ShipCountry FROM orders";
$result = $mysqli->prepare($query);
// filter data.
if (isset($_GET['filterscount']))
	{
	$filterscount = $_GET['filterscount'];
	if ($filterscount > 0)
		{
		$where = " WHERE (";
		$tmpdatafield = "";
		$tmpfilteroperator = "";
		$valuesPrep = "";
		$values = [];
		for ($i = 0; $i < $filterscount; $i++)
			{
			// get the filter's value.
			$filtervalue;
      if($_GET["filtervalue" . $i] == "Please Choose:"){
        $filtervalue = "";
      }
      else{
        $filtervalue = $_GET["filtervalue" . $i];
      }
			// get the filter's condition.
			$filtercondition;
      if($_GET["filtervalue" . $i] == "Please Choose:"){
        $filtercondition = "CONTAINS";
      }
      else{
        $filtercondition = $_GET["filtercondition" . $i];
      }
			// get the filter's column.
			$filterdatafield = $_GET["filterdatafield" . $i];
			// get the filter's operator.
			$filteroperator = $_GET["filteroperator" . $i];
			if ($tmpdatafield == "")
      {
        $tmpdatafield = $filterdatafield;
      }
      else if ($tmpdatafield <> $filterdatafield)
      {
        $where.= ")AND(";
      }
      else if ($tmpdatafield == $filterdatafield)
      {
        if ($tmpfilteroperator == 0)
        {
          $where.= " AND ";
        }
        else $where.= " OR ";
      }
			// build the "WHERE" clause depending on the filter's condition, value and datafield.
			switch ($filtercondition)
				{
			case "CONTAINS":
				$condition = " LIKE ";
				$value = "%{$filtervalue}%";
				break;
			case "DOES_NOT_CONTAIN":
				$condition = " NOT LIKE ";
				$value = "%{$filtervalue}%";
				break;
			case "EQUAL":
				$condition = " = ";
				$value = $filtervalue;
				break;
			case "NOT_EQUAL":
				$condition = " <> ";
				$value = $filtervalue;
				break;
			case "GREATER_THAN":
				$condition = " > ";
				$value = $filtervalue;
				break;
			case "LESS_THAN":
				$condition = " < ";
				$value = $filtervalue;
				break;
			case "GREATER_THAN_OR_EQUAL":
				$condition = " >= ";
				$value = $filtervalue;
				break;
			case "LESS_THAN_OR_EQUAL":
				$condition = " <= ";
				$value = $filtervalue;
				break;
			case "STARTS_WITH":
				$condition = " LIKE ";
				$value = "{$filtervalue}%";
				break;
			case "ENDS_WITH":
				$condition = " LIKE ";
				$value = "%{$filtervalue}";
				break;
			case "NULL":
				$condition = " IS NULL ";
				$value = "%{$filtervalue}%";
				break;
			case "NOT_NULL":
				$condition = " IS NOT NULL ";
				$value = "%{$filtervalue}%";
				break;
				}
			$where.= " " . $filterdatafield . $condition . "? ";
			$valuesPrep = $valuesPrep . "s";
      array_push($values, $value);
			if ($i == $filterscount - 1)
				{
				$where.= ")";
				}
			$tmpfilteroperator = $filteroperator;
			$tmpdatafield = $filterdatafield;
			}
		// build the query.
		$query = "SELECT ShipName, ShipAddress, ShipCity, ShipCountry FROM orders" . $where;
		$result = $mysqli->prepare($query);
		$result->bind_param($valuesPrep, ...$values);
		}
	}
$result->execute();
/* bind result variables */
$result->bind_result($ShipName, $ShipAddress, $ShipCity, $ShipCountry);
/* fetch values */
while ($result->fetch())
	{
	$orders[] = array(
		'ShipName' => $ShipName,
		'ShipAddress' => $ShipAddress,
		'ShipCity' => $ShipCity,
		'ShipCountry' => $ShipCountry
	);
	}
echo json_encode($orders);
/* close statement */
$result->close();
/* close connection */
$mysqli->close();

If you have any other questions, please do not hesitate to contact us again.
Best Regards,
Ivan Peevski
jQWidgets team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hello fabriceb,

Thank you for letting us know!
I have created a work item regarding this issue and we will add it as soon as possible.

If you have any other questions, please do not hesitate to contact us again.
Best regards,
Ivan Peevski
jQWidgets Team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hello ajcs

Unfortunately, this functionality is not currently supported by the jqxTabs component.
As a workaround solution, you can have a look at the js fiddle here: https://jsfiddle.net/qm239m7k/

If the solution above does not work for you, please send us more details so that we can help you find a better workaround fix.
Best regards,
Ivan Peevski
jQWidgets Team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hello Serdar,

Yes, you can. Have a look at our Nested Grids example here: https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/nestedgrids.htm?light

If you have any other questions, please do not hesitate to contact us again.
Best Regards,
Ivan Peevski
jQWidgets team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hi naveen145903,

The tabindex="-1" attribute prevents all elements outside the modal from being focused.
You will see that when you remove it, the filtering field will be enabled.

If you have any other questions, please do not hesitate to contact us again!
Best regards,
Ivan Peevski
jQWidgets Team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hi Vincenzo

There is no specific limit on the amount of data you can pass.
Depending on the computer, as the data gets larger(for example 10,000+ records), the webpage may start loading slower.

You can have a look at the demo here: https://jsfiddle.net/sb3nkjph/1/
By changing the number of loops, you will see that the chart works perfectly even with thousands of records.

If you have any other questions, please do not hesitate to contact us again.
Best regards,
Ivan Peevski
jQWidgets Team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hi pauld,

The columntype: rating doesn’t implement jqxrating, it is simply stars filled according to the values.
But there is multiple ways to have partial stars:
When using columntype: rating, it is possible to change the CSS of the stars and make them partial: https://jsfiddle.net/4prtqax8/2/
But if you’d like to use additional jqxrating methods, you need to use the cellsrenderercolumn property: https://jsfiddle.net/neLsv2pt/3/

If you have any other questions, please do not hesitate to contact us again.
Best Regards,
Ivan Peevski
jQWidgets team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hello Serdar,

Regarding the jseditor example you send us, have a look at this demo on how to get the position of the clicked row and set it as the position of the window:
https://jseditor.io/?key=grid-with-pop-up-window-demo

You can also have a look at our built-in row details functionality. It allows you to expand rows and reveal any content inside the details:
https://jsfiddle.net/jqwidgets/jKPLJ/

If you have any other questions, please do not hesitate to contact us again.
Best Regards,
Ivan Peevski
jQWidgets team
https://www.jqwidgets.com

[ivanpeevskiParticipant]

Hello Serdar,

Please have a look at this example to see how to get the group column name list.
When you click the button below the grid, there will be two alerts:
The first alert is a list of the Group Column Labels. The second alert is a list of the Group Column Names

If you have any other questions, please do not hesitate to contact us again.
Best Regards,
Ivan Peevski
jQWidgets team
https://www.jqwidgets.com

[Author]

Posts