Smartsite Documentatie > Smartsite Manager > Concepts > DataEditor > Library Configuration > Librarydetails

Librarydetails

Smartsite 7.9 - ...

The librarydetails element defines the query to be used to render the details (as shown on the right of the screen) when a single record has been selected.
The query itself must be specified within the sql child element.

The result from the query is rendered as html table. The column names will be localized if there's a corresponding localization string available.

Optionally, you can add a columns element, specifying additional options for rendering the html table from the query result.

XML CopyCode image Copy Code 
<librarydetails>
 <columns>
  <column name="status" localizevalue="true" />
  <column name="aimstate" caption="AIM_STATUS" localizevalue="true" />
  <column name="title" decodescheme="entityrecode" />
 </columns>
 <sql>
  SELECT '&lt;span class="content-infolink" data-key="' + cast(c.Nr as varchar) + '"&gt;' + cast(c.Nr as varchar) + '&lt;span&gt;' as Nr,
  c.Title, c.Code, ct.Name as 'ContentType', c.Author, c.moddate, au.Fullname as 'LAST_EDITED_BY',
  'CONTENTSTATUS_' + s.Code as Status,
  'AIMSTATE_' + case when c.AIMState in (4,5) then 'DIRTY' else upper(ast.Name) end as aimstate
  FROM vwContent c
  JOIN ContentTypes ct on c.ContentType = ct.Nr
  join AimStates ast on c.AIMState = ast.Nr
  join Status s on c.Status = s.Nr
  left join AllUsers au on au.Nr = c.UserId
  WHERE c.Nr in (?)
 </sql>
</librarydetails>

 

Smartsite Manager