• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use View topic Item7848 for generic doc work for TWiki-6.1.1. Use View topic Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
Does this site look broken?. Use the LitterTray web for test cases.

Item4112: Support [where as an alternative to [?, and restrict ~ to being LIKE-like

Item Form Data

AppliesTo: Component: Priority: CurrentState: WaitingFor: TargetRelease ReleasedIn
Engine   Urgent Closed   n/a  

Edit Form Data

Summary:
Reported By:
Codebase:
Applies To:
Component:
Priority:
Current State:
Waiting For:
Target Release:
Released In:
 

Detail

The [?...] syntax in queries has (rightly) been slated as user-unfriendly. So, add an alternate operator, [where ...] so you can write

attachments[where author='SalvadorDali' AND size>9000]

Also criticised is support for general REs. Simplify this support down to the subset supported by LIKE. This will ease mapping to DBI, too.

Note that because of the existing usage of the % character for TWikiVariables, we will have to use * for the % wildcard in SQL LIKE. I also propose to use ? rather than _ for the single character wildcard.

-- TWiki:Main/CrawfordCurrie - 22 May 2007

Done

CC

ItemTemplate
Summary Support [where as an alternative to [?, and restrict ~ to being LIKE-like
ReportedBy TWiki:Main.CrawfordCurrie
Codebase

SVN Range TWiki-4.1.2, Fri, 18 May 2007, build 13796
AppliesTo Engine
Component

Priority Urgent
CurrentState Closed
WaitingFor

Checkins TWikirev:13835 TWikirev:13836 TWikirev:13846
TargetRelease n/a
ReleasedIn

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 2007-05-22 - TWikiUserMapping_CrawfordCurrie
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback