The Virtuoso blogging system allows to insert into a post a
result from SQL, XPATH or XQuery expressions. The way this can be
done is to have a SQL access enabled for the Web user making the
post, so such blogger can insert into a post body (note that this
is not available for title) a XMLTemplate. (see "XML Templates" for
reference) Then at the render time the template will be executed on
behalf of the blogger who is made the post and result will be
shown. There is no limitation how many XML Templates can be
included in a single post. Please note that bloggers without SQL
access cannot do such posts. Also the SQL granting rules will be
applied when XML Template is executed.
The following will render a simple table containing list of
Demo.demo.Shippers table from Demo database.
<sql:query xmlns:sql="urn:schemas-openlink-com:xml-sql" >
select 1 as tag , null as parent, CompanyName as [tr!1!td!element]
for xml explicit
The following post will render a table containing a names of
people which is organized in simple OPML file (located in the
tutorial system) using XQuery.