“Many hands make light work.”
— John Heywood
Last time, we built a little companion widget to share the page with our storefront widget to provide the ability to filter the list of applications displayed. Clicking on the search button on that widget reloads the page with the search criteria present in the query string of the URL. Now we need to modify the primary widget to pull that search criteria in from the URL and then use it when querying the database for applications to display. To begin, we can use basically the same code that we used in the search widget to bring in the values.
var search = $sp.getParameter('search');
var local = $sp.getParameter('local') == 'true';
var current = $sp.getParameter('current') == 'true';
var upgrade = $sp.getParameter('upgrade') == 'true';
var notins = $sp.getParameter('notins') == 'true';
Now that we have the information, we need to use it to filter the query results. For the search string, we want to look for that string in either the name or the description of the app. That one is relatively straightforward and can be handled with a single encoded query.
var appGR = new GlideRecord('x_11556_col_store_member_application');
if (search) {
appGR.addEncodedQuery('nameLIKE' + search + '^ORdescriptionLIKE' + search);
}
The remaining parameters are all boolean values that relate to one another in some way, so we have to handle them as a group. First of all, if none of the boxes are checked or all of the boxes are checked, then there is no need for any filtering, so we can eliminate those cases right at the top.
if (local && current && upgrade && notins) {
// everything checked -- no filter needed
} else if (!local && !current && !upgrade && !notins) {
// nothing checked -- no filter needed
} else {
...
}
After that, things get a little more complicated. Local apps are those where the provider instance is the local instance, and we don’t apply any other filter to that pool. You either want the local apps included or you do not. They are included by default, but if you start checking boxes then they are only included if you check the Local checkbox.
var query = '';
var separator = '';
if (local) {
query += 'provider.instance=' + gs.getProperty('instance_name');
separator = '^OR';
} else {
query += separator + 'provider.instance!=' + gs.getProperty('instance_name');
separator = '^';
}
The remaining three values relate to the apps pulled down from the store, which are classified based on whether they have been installed on the local instance (current and upgrade) or not (notins). Installed apps have a value in the application field and those that have not been installed do not. Additionally, installed apps are considered current if the installed version is the same as the current version; otherwise they are classified as having an upgrade available. We only need to check the version if you want one, but not the other. If you want both current and upgrade or neither current nor upgrade, then there is no point in making that distinction. So we first check both cases where the values are different.
if (current && !upgrade) {
if (notins) {
query += separator + 'applicationISEMPTY^ORversionSAMEASapplication.version';
} else {
query += separator + 'versionSAMEASapplication.version';
}
} else if (!current && upgrade) {
if (notins) {
query += separator + 'applicationISEMPTY^ORversionNSAMEASapplication.version';
} else {
query += separator + 'versionNSAMEASapplication.version';
}
...
And finally, we check the last two cases where current and upgrade are the same value.
} else if (current && upgrade && !notins) {
query += separator + 'applicationISNOTEMPTY';
} else if (!current && !upgrade && notins) {
query += separator + 'applicationISEMPTY';
}
That should do it. Putting that all together with the original fetchItemDetails function gives us this new version of that function.
function fetchItemDetails(items) {
var search = $sp.getParameter('search');
var local = $sp.getParameter('local') == 'true';
var current = $sp.getParameter('current') == 'true';
var upgrade = $sp.getParameter('upgrade') == 'true';
var notins = $sp.getParameter('notins') == 'true';
var appGR = new GlideRecord('x_11556_col_store_member_application');
if (search) {
appGR.addEncodedQuery('nameLIKE' + search + '^ORdescriptionLIKE' + search);
}
if (local && current && upgrade && notins) {
// everything checked -- no filter needed
} else if (!local && !current && !upgrade && !notins) {
// nothing checked -- no filter needed
} else {
var query = '';
var separator = '';
if (local) {
query += 'provider.instance=' + gs.getProperty('instance_name');
separator = '^OR';
} else {
query += separator + 'provider.instance!=' + gs.getProperty('instance_name');
separator = '^';
}
if (current && !upgrade) {
if (notins) {
query += separator + 'applicationISEMPTY^ORversionSAMEASapplication.version';
} else {
query += separator + 'versionSAMEASapplication.version';
}
} else if (!current && upgrade) {
if (notins) {
query += separator + 'applicationISEMPTY^ORversionNSAMEASapplication.version';
} else {
query += separator + 'versionNSAMEASapplication.version';
}
} else if (current && upgrade && !notins) {
query += separator + 'applicationISNOTEMPTY';
} else if (!current && !upgrade && notins) {
query += separator + 'applicationISEMPTY';
}
appGR.addEncodedQuery(query);
}
appGR.orderBy('name');
appGR.query();
while (appGR.next()) {
var item = {};
item.name = appGR.getDisplayValue('name');
item.description = appGR.getDisplayValue('description');
item.logo = appGR.getValue('logo');
item.version = appGR.getDisplayValue('current_version');
item.provider = appGR.getDisplayValue('provider.name');
item.providerLogo = appGR.provider.getRefRecord().getValue('logo');
item.local = appGR.getDisplayValue('provider.instance') == gs.getProperty('instance_name');
item.sys_id = appGR.getUniqueValue();
item.state = 0;
if (appGR.getValue('application')) {
item.state = 1;
item.installedVersion = appGR.getDisplayValue('application.version');
if (item.version == item.installedVersion) {
item.state = 2;
}
}
if (!item.local && item.state != 2) {
item.attachmentId = getAttachmentId(item.sys_id, item.version);
}
items.push(item);
}
}
Now we can fire up the storefront page and start clicking around and see what we have. Or better yet, we can push out yet another Update Set and let all of you following along at home click around and see if everything works as it should. I always like it when folks with a little different perspective take the time to pull stuff down and give it a whirl, so here you go:
If this is your first time, you will want to take a peek here and here and here. For the rest of you, this is just another 0.7.x drop-in replacement, and you should know what to do by now. Please let us all know what you find in the comments below. Feedback is always welcome and always very much appreciated. Hopefully, we will get some interesting results and we can take a look at those next time out.
