NOTE: This is a SupplementalDocument topic which is not included with the official TWiki distribution. Please help maintain high quality documentation by fixing any errors or incomplete content. Put questions and suggestions concerning the documentation of this topic in the comments section below! Use the Support web for problems you are having using TWiki.

QuerySearch Pattern Cookbook

We have the very useful SearchPatternCookbook for regular expression searches. This topic provides tips on the usage of QuerySearch, a major leap in creating searches and available from TWiki 4.2.

Pattern 1: Show recent changes without user pages

We have everything in the Main web. But the updates to the personal pages are not that interesting to others, so we want to remove these.

We are looking for any page that does not have a form field "FirstName":

<dl>
%SEARCH{
"name~'*' AND NOT FirstName"
web="Main"
excludetopic="Web*,PersonalInfo,TWikiUsers"
type="query"
reverse="on"
limit="15"
order="modified"
nonoise="on"
format="<dt>[[$web.$topic][$topic(25,...)]]<br /><span class='twikiGrayText twikiSmall'>$date - <nop>$wikiname</span></dt>"
}%
</dl>

Pattern 2: List the 5 most recent blog post comments

The simple BlogAddOn has 1 comment topic that gathers all comments on the blog post. It has no TWiki Form (the blog post has one: BlogPostForm); the topic title is the name of the blog post + "Comments". How can we show the latest 5 comments?

We are looking for a topic with the title "xxxxComments". It has a parent and the parent has a form named "BlogPostForm":

<dl>
%SEARCH{
"name~'*Comments' AND (parent.name/(form.name='BlogPostForm')).value"
web="Main"
type="query"
limit="15"
reverse="on"
order="modified"
nonoise="on"
format="<dt>[[$web.$parent#BlogPostPrompt][$parent(30,...)]] ($rev)<br /><span class='twikiGrayText twikiSmall'>$date - <nop>$wikiname</span></dt>"
}%
</dl>

-- Contributors: ArthurClemens - 06 Feb 2008

Comments & Questions about this Supplemental Document Topic

I would like to see a "most popular" list built with query search...

-- ArthurClemens - 06 Feb 2008

I am also very curious how to set up a web search that find topics that have web form F - and have one or multiple words in the topic text.

-- ArthurClemens - 15 Feb 2008

Thanks Arthur for initiating this cookbook page!

-- PeterThoeny - 02 Mar 2008

%SEARCH{type="query" "RequirementsForm[name='CompanySystem'].value='Intranet'"

what' the test for value is blank?

It is not %SEARCH{type="query" "RequirementsForm[name='CompanySystem'].value=''"

-- MartinCleaver - 29 Aug 2008