Recent Changes - Search:

(:shoutbox:)
(:shoutboxend:)

(:toggle show box1 button=1 show="More>>" hide="Hide Options" :)

Name:
Lines to Show:

(:feralsimplecalendar:)

PmWiki

pmwiki.org

edit SideBar

Dev /

PageListPlus

TERMS

Any search term not specified otherwise will be searched for as a simple occurring term in the page source

 (:pagelist ... abc*,def* ghi:)

 SELECT DISTINCT grp||'.'||name AS pn
   FROM pagestatus, terms
  WHERE pagestatus.pageid = terms.pageid
    AND (   (terms.term >= 'abc' AND terms.term < 'abd' AND terms.term GLOB 'abc*')
         OR (terms.term >= 'def' AND terms.term < 'deg' AND terms.term GLOB 'def*'))
 INTERSECT
 SELECT DISTINCT grp||'.'||name AS pn
   FROM pagestatus, terms
  WHERE pagestatus.pageid = terms.pageid
    AND (terms.term = 'ghi')

LINKTO

linkto=x will list all pages which contain a link FROM page x

 (:pagelist ... linkto=GroupA.PageB linkto=Mygroup.Mypage,Mygroup2.*,Mgroup3.Xyz*:)

 SELECT DISTINCT grp||'.'||name AS pn
   FROM pagestatus, links
  WHERE pagestatus.pageid = links.pageid
    AND (links.togrp = 'GroupA' AND links.toname = 'PageB')
 INTERSECT
 SELECT DISTINCT grp||'.'||name AS pn
   FROM pagestatus, links
  WHERE pagestatus.pageid = links.pageid
    AND (   (links.togrp = 'Mygroup' AND links.toname = 'Mypage')
         OR (links.togrp = 'Mygroup2' AND links.toname GLOB '*')
         OR (links.togrp = 'Mygroup3' AND links.toname GLOB 'Xyz*'))

LINKFROM

linkfrom=x will list all pages which contain a link FROM page x

 (:pagelist ... linkfrom=GroupA.PageB linkfrom=Mygroup.Mypage,Mygroup2.*,Mygroup3.Xyz*:)

 SELECT DISTINCT links.togrp||'.'||links.toname AS pn
   FROM pagestatus, links
  WHERE pagestatus.pageid = links.pageid
    AND (pagestatus.grp = 'GroupA' AND pagestatus.name = 'PageB')
 INTERSECT
 SELECT DISTINCT links.togrp||'.'||links.toname AS pn
   FROM pagestatus, links
  WHERE pagestatus.pageid = links.pageid
    AND (   (pagestatus.grp = 'Mygroup' AND pagestatus.name = 'Mypage')
         OR (pagestatus.grp = 'Mygroup2' AND pagestatus.name GLOB '*')
         OR (pagestatus.grp = 'Mygroup3' AND pagestatus.name GLOB 'Xyz*'))

PTV

$:var=val1,val2
(:pagelist ... $:Var1=Sam $:Var2=1[0-9]3 $:Var3=Jack,Jill:)

 SELECT DISTINCT grp||'.'||name AS pn
   FROM pagestatus, ptvs
  WHERE pagestatus.pageid = ptvs.pageid
    AND (ptvs.var = 'Var1' AND ptvs.value = 'Sam')
 INTERSECT
 SELECT DISTINCT grp||'.'||name AS pn
   FROM pagestatus, ptvs
  WHERE pagestatus.pageid = ptvs.pageid
    AND (ptvs.var = 'Var2' AND ptvs.value GLOB '1[0-9]3')
 INTERSECT
 SELECT DISTINCT grp||'.'||name AS pn
   FROM pagestatus, ptvs
  WHERE pagestatus.pageid = ptvs.pageid
    AND (ptvs.var = 'Var3' AND (ptvs.value = 'Jack' OR ptvs.value = 'Jill')
Edit - History - Print - Recent Changes - Search
Page last modified on April 03, 2009, at 03:37 PM