Find articles by published status

Build 1501 on 14/Nov/2017  This topic last edited on: 18/Mar/2016, at 12:13

Since build 2280 in version 2.1, we introduced the search by the published status. On the Advanced search pane of Editorial, Wires and Articles, you can find the Published check-box.

When ticked, the listing displays only the published content; when empty, the listing displays only the not published content; when containing a black rectangle, the listing displays published and not published content.

In Type you can select Article, Editorial image, Image or Video. It doesn't work for any other type.

publish_find

Click to toggle expandHow to integrate it in your older versions?

Here the instruction on how to add the Linked check box on the search panes. On the previous screenshot, the Published check box was added on the Advanced pane of the Editorial navigator. You can add it to other panes too.

The changes include

1.the schema changes

2.the database upgrade

3.the recomputing for existing published items,

4.the configuration changes.

1.SCHEMA CHANGES

There are changes in gn4.xsd and in Tark4Include.xsd.

In GN4.xsd add the "nav" namespace in the schema definition  if not already there.

<xs:schema

targetNamespace="urn:schemas-teradp-com:gn4tera"

elementFormDefault="qualified"

xmlns="urn:schemas-teradp-com:gn4tera"

xmlns:nav="http://www.teradp.com/schemas/GN4/1/ObjNav.xsd"

xmlns:gn4="urn:schemas-teradp-com:gn4tera"

xmlns:xs="http://www.w3.org/2001/XMLSchema"

xmlns:gs="http://www.teradp.com/schemas/GN4/1/XmlSchemaExt.xsd"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

gs:modules="Editorial">

Modify the following two objects adding the part in red:

<xs:group name="imgExtra">
    <xs:annotation>
      <xs:documentation>Additional attributes of the 'img' object type that are rendered as XML element</xs:documentation>
      <xs:appinfo>
        <gs:compute inherit="true">
          <img xmlns:msxsl="urn:schemas-microsoft-com:xslt">
            <xsl:variable name="isPub" select="nav:referencing/nav:referencingBy[@attrName='pubDest.objs']/nav:refs"/>
            <!-- 'Fake' test of the handle attribute to generate a dependency -->
            <xsl:if test="string($isPub/@handle)">
              <xsl:choose>
                <xsl:when test="$isPub/nav:refObject/gn4:pubDest">
                  <isPublished>true</isPublished>
                </xsl:when>
                <xsl:otherwise>
                  <isPublished>false</isPublished>
                </xsl:otherwise>
              </xsl:choose>
            </xsl:if>
          </img>
        </gs:compute>
      </xs:appinfo>
    </xs:annotation>
    <xs:sequence>
      <xs:group ref="archiveObjectExtra"/>
      <xs:element name="authorRef" type="reference" minOccurs="0" nillable="true" gs:refer="user">
        <xs:annotation>
          <xs:documentation>Author of the image</xs:documentation>
        </xs:annotation>
      </xs:element>
      <xs:element name="notes" type="tDescription" minOccurs="0">
        <xs:annotation>
          <xs:documentation>Copy-flow notes</xs:documentation>
        </xs:annotation>
      </xs:element>
    </xs:sequence>
  </xs:group>
 
<xs:group name="articleExtra">
    <xs:annotation>
      <xs:documentation>Additional attributes of the 'article' object type thatare rendered as XML element</xs:documentation>
      <xs:appinfo>
        <gs:compute inherit="true">
          <article xmlns:msxsl="urn:schemas-microsoft-com:xslt">
            <xsl:variable name="isPub" select="nav:referencing/nav:referencingBy[@attrName='pubDest.objs']/nav:refs"/>
            <!-- 'Fake' test of the handle attribute to generate a dependency -->
            <xsl:if test="string($isPub/@handle)">
              <xsl:choose>
                <xsl:when test="$isPub/nav:refObject/gn4:pubDest">
                  <isPublished>true</isPublished>
                </xsl:when>
                <xsl:otherwise>
                  <isPublished>false</isPublished>
                </xsl:otherwise>
              </xsl:choose>
            </xsl:if>
          </article>
        </gs:compute>
      </xs:appinfo>
    </xs:annotation>
    <xs:sequence>
      <xs:group ref="archiveObjectExtra"/>
      <xs:element name="authorRef" type="reference" minOccurs="0" nillable="true" gs:refer="user">
        <xs:annotation>
          <xs:documentation>Author of the article - it can be different than the creator if the article is being entered on behalf of someone else</xs:documentation>
        </xs:annotation>
      </xs:element>
      <xs:element name="notes" type="tDescription" minOccurs="0">
        <xs:annotation>
          <xs:documentation>Copy-flow notes</xs:documentation>
        </xs:annotation>
      </xs:element>
    </xs:sequence>
  </xs:group>

In Tark4Include.xsd add the "nav" namespace in the schema definition:

<xs:schema 

  elementFormDefault="qualified"

  xmlns:nav='http://www.teradp.com/schemas/GN4/1/ObjNav.xsd'

  xmlns:gs="http://www.teradp.com/schemas/GN4/1/XmlSchemaExt.xsd"

  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

  xmlns:xs="http://www.w3.org/2001/XMLSchema"

  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 
Modify the object:

<xs:group name="folderObjectExtra">

by adding the element:
      <xs:element name="isPublished" type="xs:boolean" minOccurs="0" default="false" gs:compute="true">
        <xs:annotation>
          <xs:documentation>Computed boolean: false: not published - true: published</xs:documentation>
          <xs:appinfo>
            <gs:ui mode="ReadOnly"/>
          </xs:appinfo>
        </xs:annotation>
      </xs:element>

Pay attention to define the element inside the <xs:sequence> node where other elements are already present.

Modify the image object:
  <xs:element name="image">

by adding the part in red. We left part of the element to understand where to place it:

        <gs:compute inherit="true">
            <!-- 
              Semplified XSL transformation to compute size
            -->
            <image>
              <!-- Compute size -->
             ...

            <!-- Compute the isPublished -->
              <xsl:variable name="isPub" select="nav:referencing/nav:referencingBy[@attrName='pubDest.objs']/nav:refs"/>
              <!-- 'Fake' test of the handle attribute to generate a dependency -->
              <xsl:if test="string($isPub/@handle)">
                <xsl:choose>
                  <xsl:when test="$isPub/nav:refObject/gn4:pubDest">
                    <isPublished>true</isPublished>
                  </xsl:when>
                  <xsl:otherwise>
                    <isPublished>false</isPublished>
                  </xsl:otherwise>
                </xsl:choose>
              </xsl:if>

Do the same thing on the video object:

  <xs:element name="video">

again we pasted a part of the element to understand where to place it

          <gs:compute inherit="true">

            <!--

              Simplified XSL transformation to compute size

            -->

            <video>

              <!-- Compute size -->

              ...

              <!-- Compute the isPublished -->

              <xsl:variable name="isPub" select="nav:referencing/nav:referencingBy[@attrName='pubDest.objs']/nav:refs"/>

              <!-- 'Fake' test of the handle attribute to generate a dependency -->

              <xsl:if test="string($isPub/@handle)">

                <xsl:choose>

                  <xsl:when test="$isPub/nav:refObject/gn4:pubDest">

                    <isPublished>true</isPublished>

                  </xsl:when>

                  <xsl:otherwise>

                    <isPublished>false</isPublished>

                  </xsl:otherwise>

                </xsl:choose>

              </xsl:if>

 

2.UPGRADE THE DATABASE WITH THE NEW SCHEMA

We suggest to run the schema update with the -nocompute option otherwise all folderObject will be recomputed taking a very long time.

Here is a sample of the command

    srv4 dbupdate -s ..\config\schemas\GN4.xsd -d "" -nocompute

Remember to verify the path for your schema. Remember to perform the iisreset before proceeding.

3.RECOMPUTE FOR THE EXISTING OBJECTS

Recompute only the necessary objects with the command:

srv4 recompute -conditions gn4:article
srv4 recompute -conditions gn4:img
srv4 recompute -conditions gn4:image
srv4 recompute -conditions gn4:video

4.MODIFY THE SEARCH PANES

In the SHELL4_CONFIG.XML, locate the EditorialPages base query, expand it and then expand SearchList, and then expand searchObjectUI name="Advanced".

Add the following code on the position you want:

        <attribute path="[folderObject.isPublished]">

          <ui label="Published">

            <template kind="CheckBox" opMode="Hidden"/>

          </ui>

        </attribute>

 

ispublished2

 

In the TED4_CONFIG.XML, locate the ArticlePicker base query, expand it and then expand SearchList, and then expand searchObjectUI name="Advanced".

Add the following code on the position you want:

        <attribute path="[folderObject.isPublished]">

          <ui label="Published">

            <template kind="CheckBox" opMode="Hidden"/>

          </ui>

        </attribute>

 
Load the both configuration files in the database and then try to find published and not published items.