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:
<
<		 Could not perform search. Error was: /bin/grep -F -i -l -H -- %TOKEN|U% %FILES|F% Grep for 'attachments[name ~ '*.png' AND date >= d2n('2007-03-26')' returned error
>
>		 Could not perform search. Error was: /bin/grep -F -i -l -H -- %TOKEN|U% %FILES|F% Grep for 'attachments[name ~ '*.png' AND date >= d2n('2007-03-26')]' returned error
  Find all topics that have a field 'Threat' set to 'Amber' and 'cold virus' somewhere in the topic text.
View topic | History: r9 < r8 < r7 < r6 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright &© 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.