I have a list of knowledge articles are are displayed on my Force.com site. Is there a way to display these articles in the order of created date? Display the latest on top?

I am very new to this and any help will be appreciated.

Here is my code of visualforce Page:

 <apex:outputText rendered="{!searchExecuted}">
 <meta name="apple-mobile-web-app-capable" content="yes"></meta>
  <meta name="google-site-verification" content="5RGxzbeLEuzShgu4D8M-FOJp-Od16pOtEhd7dDkJdKI" />
  <meta name="google-site-verification" content="UlsZy8bKchrjHlXGMjkMMmK0dpF6Nh7cX8I92tANbEs" />
 <meta http-equiv="content-type" content="text/html;charset=utf-8" />
 <meta name="viewport" content="width=device-width, initial-scale=1" />
 <meta name="apple-mobile-web-app-capable" content="yes" />
 <meta name="apple-mobile-web-app-status-bar-style" content="black-translucent" />
   <link rel="icon" type="image/vnd.microsoft.ico" href="http://www.webcentral.com.au/favicon.ico" />
  <script src="{!$Resource.pkb_jquery_1_6_2}" type="text/javascript" />
   <script src="{!$Resource.pkb_jquery_simplemodal_1_4_1}" type="text/javascript" />
   <apex:outputText rendered="{!viewingArticle}">
    <apex:variable var="typeName" value="{!SUBSTITUTE(pkbCon.theKad.articleTypeName, pkbCon.kavExtension, '')}" />
    <apex:variable var="articleURL" value="{!pkbCon.currentSiteUrl}articles{!pkbCon.selectedLanguageURL}{!typeName}/{!pkbCon.theKad.urlName}" />
   <meta property="og:title" content="{!pkbCon.theKad.title}"/>
    <meta property="og:type" content="article"/>
    <meta property="og:url" content="{!articleURL}"/>
    <meta property="og:site_name" content="{!SUBSTITUTE(pkbCon.siteName,'_',' ')}" />
    <meta property="og:description" content="{!pkbCon.theKad.summary}"/>
    <meta property="description" content="{!pkbCon.theKad.summary}"/>
    <link rel="canonical" href="{!articleURL}"/>
  <apex:outputText rendered="{!NOT(viewingArticle)}">
   <meta property="description" content="Expert help and support articles for WebCentral products and services."/>
  <c:wc_pkb_css />
  <c:wc_css_bootstrap />
  <c:wc_css />
  <c:wc_pkb_js pkbCon="{!pkbCon}" />

Assuming you are using PKB version 3, this is an unmanaged package. You can change the query in "PKB_Controller" and "PKB_Mobile_Controller" to add order by to the queries you are after.

You might find something like below

  String q = '';
q += 'select ' +join(kavFields, ',')+ ' from KnowledgeArticleVersion';
q += ' where PublishStatus = \'' +pkb_Controller.DEFAULT_PUBLISH_STATUS+ '\' and Language = \'' +lang+ '\' and KnowledgeArticleId in :aids order by LastPublishedDate desc';

That you can change to

 String q = '';
q += 'select ' +join(kavFields, ',')+ ' from KnowledgeArticleVersion';
q += ' where PublishStatus = \'' +pkb_Controller.DEFAULT_PUBLISH_STATUS+ '\' and Language = \'' +lang+ '\' and KnowledgeArticleId in :aids order by createddate desc';
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.