Skip to main content

How to make a Table with search and filter functionality dynamically using jQuery?

<html lang="en">

<head>
<title>Table for Learning</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<style>
th,td,tr{border: 1px solid #0000ff; text-align: center; border-collapse: collapse;}
table{
border: 1px solid orange; border-collapse: collapse; text-align: left;
}
tr:hover{
color: green;
}
</style>

</head>

<body>
<h1>Data From Server</h1>
<input type="text" id="search" placeholder="search here..">
<select name="" id="onSelect"></select>

<table id='mn'>
<thead>
<tr>
<th>Id</th>
<th>Name</th>
<th>User Name</th>
<th>Email</th>
<th>City</th>
</tr>
</thead>
<tbody>

</tbody>
</table>

<script>
$(function () {
$('#onSelect').append('<option value="">select user</option>');

function getDataFromURL() {
$.ajax({
url: "https://jsonplaceholder.typicode.com/users",
type: "GET",
success: function (response) {
console.log(response);

response.forEach(function (d) {
optObj={}
// console.log(td);
var html = '<tr><td>' + d.id + '</td><td>' + d.name +
'</td><td>' + d.username + '</td><td>' + d.email +
'</td><td>'+d.address.city+'</td></tr>';
$('table tbody').append(html);
$('#onSelect').append('<option value=' +d.username+ '>' + d.username +
'</option>');
});
},
error: function (err) {
console.log(err);
}
});

}
getDataFromURL();
$('#search').on('keyup', function () {
var searchkey = $('#search').val().toLowerCase();
$('#mn tbody tr').filter(function () {
$(this).toggle($(this).text().toLowerCase().indexOf(searchkey) > -1);
});
});

$('#onSelect').on('click', function () {
var selVal = $('#onSelect').val().toLowerCase();
console.log(selVal);
$('#mn tbody tr').filter(function () {
$(this).toggle($(this).text().toLowerCase().indexOf(selVal) > -1);
});
})
})
</script>

</body>

</html>


output is:

Comments

Post a Comment

Popular posts from this blog

How to update values in a custom multi lookup field Field (table) of MS Project using JavaScript/jQuery?

  Updating values in the custom multi lookup field Field of MS Project using JavaScript/jQuery: First of all we need to know the steps to update/add details in a Project of Project Server  Step 1: CheckOut a Project Step 2: Update detals in same as in Step 1 Project Step 3: Publish a Project Step 4: CheckIn a Project We always in need to follow the above steps to update any Project to MS Project/Project Server. Same we need to follow in code too.    //Step 1: First, we need to define all the required functions, the below Functions are callback functions             window.checkOutPWAProject = function (projectId, callBack) {                 var checkOutURL = _spPageContextInfo.webAbsoluteUrl + "/_api/ProjectServer/Projects('" + projectId + "')/checkOut()";                 $.ajax({                     url: chec...

How to get all site users of SharePoint using REST API?

Get all users of SharePoint site using REST API: These users and its data are required to update people field of a SharePoint list. By using below snippet code we can able to get details of a user of SharePoint site.     var webURL = _spPageContextInfo.webAbsoluteUrl+"/_api/Web/SiteUsers";         $.ajax({           url: customFieldURL,           method: "GET",           headers: {             "Accept": "application/json; odata=verbose"           },           success: function (data) {            console.log(data);             data.d.results.forEach(function(cm){                     console.log(cm.Title+" - "+cm.Email+" - "+cm.Id);             });      ...

How to trigger a MS Flow Using Jquery/JavaScript?

Trigger a  MS Flow Using jQueryuery/JavaScript: To trigger an MS Flow first we need to create an workflow. Next we need to obtain its URL for triggering it. In below example, we are starting a workflow which is taking email address, email subject and email body as parameter and sending mail to email of related user. //This function triggers the microsoft flow  function beginMSFlow() {          var httpPostUrl = "obtain URL from MS flow";          var postData = {              emailadress:'raju@testdev.com', // Object keys must be similar as you used in the MS flow             emailSubject:'Testing Raju',              emailBody:'Hello User\n Welcome, You just trigger a MS Flow'             };           $.ajax({           url: httpPostUrl,    ...