How to get the KB Category Page widget to sort the Knowledge Articles based on the Short Description

[jlaue]

Hello - 

When I use the KB - Categories - KBv3 Widget in Service Portal and click on a specific Knowledge Base category, it appears to be sorting the articles on the articles category, on the KB Category Page widget.  I was wondering if there was a way that I could get these articles to sort/order on the Short Description of the Knowledge Article instead of the current way it is sorting. 

I am not sure if this sort is controlled in the KB Categories - KBv3 widget or if it is happening in the KB Category Page widget, and how I can update this.  The SC Categories widget and SC Category Page widget are properly sorting on the name of the Catalog Item, I was hoping to achieve a similar result with the KB widgets.  

Thanks!

[atlsdrew]

Thank you for providing the scrip and solution.  This also helped me.  What modifications to the script would I need to make if I wanted to filter by created by date? 

[Carl Fransen1]

The field you refer to is 'sys_created_on' so just replace 'title' with 'sys_created_on'....  Haven't tested it but no reason why it shouldn't work.

[atlsdrew]

Carl - Thank for the reply and assistance, but can you clarify if I update the Client Controller' script you provided or the HTML code?  I've tried both and still struggling.  The HTML script solved the issue I have with sorting by short description, but I have a widget instance to where I need to sort by created by date. 

Oh, and I'm no scripting or coding expert, so please forgive my ignorance.  

[Carl Fransen1]

I'd love to help but I'm also not the best coder and had assistance from a web team in-house with my solution.  I think the issue is because the fields types are different (String vs date) and Jack has indicated in his solution that this could be an issue.

@Jack - would you be able to assist with this query - to sort by 'sys_created_on' date...?

Thanks

Carl.

[Jack]

Hi @Cart and @atlsdrew,

I think we cannot sort by "sys_created_on", because the item object hasn't contained this field.

So, I assume we will sort list by "published" field (Date type). And this is my way (follow my post above):

1. Update sortArticles() method (server-script):
   

   function sortArticles(arr, field, desc) {
       try {
           //sort for date type (published)
           if (field == "published") {
               arr.sort(function (a, b) {
   				
   		var dateA = new GlideDate(); 
   		dateA.setDisplayValue(a[field]); 
   		var dateB = new GlideDate(); 
   		dateB.setDisplayValue(b[field]);
   
                   if (desc) {
                       return GlideDate.subtract(dateA, dateB).getDayPart();
                   }else{
                       return GlideDate.subtract(dateB, dateA).getDayPart();
                   }
               });
   
           } else { //sort for normal type            
               arr.sort(function (a, b) {
                   var compare = a[field].localeCompare(b[field]);
                   if (desc) {
                       if (compare == 1) {
                           compare = -1;
                       } else {
                           compare = 1;
                       }
                   }
                   return compare;
               });
   
           }
   
       } catch (err) {
           console.log("***ERROR: " + err);
       }
       return arr;
   }
   ​

2. Update instance options
   

   {
     "sortBy":"published",
     "sortDesc":"false"
   }​

   
   
   
3. This is the result
   

Hope this will help.