Difference: QuerySearch (3 vs. 4)

Revision 42009-06-04 - TWikiContributor

Line: 1 to 1

META TOPICPARENT	name="TWikiVariables"

Query Search

Line: 97 to 97

`~`	wildcard match ('' will match any number of characters, '?' will match any single character e.g. "PersonForm.Surname ~ 'Smit?'") Note: Surname ~ 'Smith' is the same as Surname = 'Smith'
`<`	LHS is less that RHS. If both sides are numbers, the order is numeric. Otherwise it is alphabetic (applies to all comparison operators)
`>`	>

Changed:

<
<

`>=`	>e;
`<=`	<e;

>
>

`>=`	≥
`<=`	≤

`lc(x)`	Converts x to lower case, Use for caseless comparisons.
`uc(x)`	Converts x to UPPER CASE. Use for caseless comparisons.
`d2n(x)`	Converts a date (expressed in one of the formats that TWiki can parse) to a number of seconds since 1st Jan 1970. This is the format dates are stored in inside TWiki, and you have to convert a string date using `d2n` before you can compare it with - for example - the date an attachment was uploaded. Times without a timezone are assumed to be in server local time. If you have date fields in your forms, note that they are not stored in TWiki's internal format, but are stored as text strings. You should still use `d2n` to convert them to numbers for comparisons, though.

Line: 143 to 143

Find all topics that have PNG attachments that have been added since 26th March 2007

Changed:

<
<

Searched: attachments[name ~ '*.png' AND date >= d2n('2007-03-26')

Results from TWiki web retrieved at 11:29 (GMT)

QuerySearch

r8 - 2013-09-25 - 19:36 TWikiContributor

<--/twikiTopRow-->

Query Search Query searches help you search the contents of forms attached to your topics, as well as the values of other meta data attached to the topic. Using query...

<--/twikiSummary-->

<--/twikiBottomRow-->

<--/patternSearchResult-->

Number of topics: 1

<--/patternSearchResultCount-->

>
>

Searched: attachments[name ~ '*.png' AND date >= d2n('2007-03-26')]

Results from TWiki web retrieved at 11:29 (GMT)

QuerySearch

r8 - 2013-09-25 - 19:36 TWikiContributor

<--/twikiTopRow-->

Query Search Query searches help you search the contents of forms attached to your topics, as well as the values of other meta data attached to the topic. Using query...

<--/twikiSummary-->

<--/twikiBottomRow-->

<--/patternSearchResult-->

Number of topics: 1

<--/patternSearchResultCount-->

Find all topics that have a field 'Threat' set to 'Amber' and 'cold virus' somewhere in the topic text.

View topic | History: r8 < r7 < r6 < r5 | More topic actions...

Copyright © 1999-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
Note: Please contribute updates to this topic on TWiki.org at TWiki:TWiki.QuerySearch.