Hello guys,

Today I was going through some blogs from @jacebenson and I found a really interesting thing called “GlideQuery”. not GlideRecord

**YAA!!!**

I decided to explore this. There were no docs no session nothing. Literally nothing. I messaged Jace at discord to know more. I had a quick chat and started exploring. I found it really helpful as in it gives me the control which I always wanted to have while using GlideRecord. I mean it is just wrapper around GlideRecord but still.

I have recorded one video. Code that I showed in the video is below:

**For Plugin Activation:**

var plugins = [];
plugins.push('com.sn_glidequery');
var main = new GlideMultiPluginManagerWorker();
main.setPluginIds(plugins);
main.setProgressName("Plugin Installer");
main.setBackground(true);
main.start();

**Sample 1:**

var gd=new GlideQuery('sys_user')
.whereNull('last_name')
.select('first_name','email')
.forEach(function(user){
gs.print(user);
});

**Sample 2:**

var gd=new GlideQuery('sys_user')
.where('user_name',"STARTSWITH",'a')
.select('first_name','email')
.forEach(function(user){
gs.print(JSON.stringify(user));
});

**Sample 3:**

var gd = new GlideQuery('sys_user')
.getBy({
first_name: 'Fred',
last_name: 'Luddy'
}, ['first_name', 'last_name', 'city', 'active'])
.orElse({
first_name: 'Nobody',
last_name: 'Found',
city: 'Nowhere',
active: false
});
gs.print(JSON.stringify(gd));

**Sample 4:**

var gd = new GlideQuery('incident')
.limit(20)
.select('number')
.forEach(function(user){
gs.print(JSON.stringify(user));
});

**Sample 5:**

var user = new GlideQuery('sys_user')
.insertOrUpdate({
first_name: 'Debasis',
last_name: 'Majhi'
})
.orElse(null);

**Links:**

**[Jace Benson Article](https://jace.pro/post/2020-05-29-how-to-install-glidequery/)**

In case you need any help, please do connect with me. It will be my pleasure to help you.

Happy Learning Guys!!!

—–>**[Dhruv Gupta](https://www.linkedin.com/in/dhruvceh/?originalSubdomain=in)**