Site Preferences

help Foswiki's default preferences are located in System.Default Preferences, however settings defined here have override priority and should be used for local customisations.

Default Overrides

Up to 1GB attachments. This preference setting is in KB.
  • Set ATTACHFILESIZELIMIT = 1000000

Customize logo and tooltip texts:

  • #Set WIKILOGOIMG = foswiki-logo.png
  • Set WIKILOGOIMG = COPSlogo_horizntal_Banner468x50.jpg

Customize your top bar background image and color
  • Set WEBHEADERART = /w/pub/System/PatternSkin/header5.gif
  • Set WEBHEADERBGCOLOR = #ffffff

  • #Set BROADCASTMESSAGE = Site Undergoing Maintenance. No Edits are allowed until further notice.
  • Set AMP = &
Output a warning if an included file is missing.
  • Set INCLUDEWARNING = on

Avoid Crawler Traps

  • Set TABLEPLUGIN_SORT = attachments

Table Plugin's way of sorting is pretty arcane. Better use JQData Tables Plugin for these requirements which does client-side table sorting.

Cache

disable cache globally and only cache on expensive pages.
  • Set CACHEABLE = off

Finalisation

FINALPREFERENCES locks site-level preferences that are not allowed to be overridden by Web Preferences or user preferences:

  • Set FINALPREFERENCES = ATTACHFILESIZELIMIT, PREVIEWBGIMAGE, WIKITOOLNAME, WIKIHOMEURL, ALLOWROOTCHANGE, DENYROOTCHANGE, DOCWEB, WIKIWEBMASTER, WIKIWEBMASTERNAME, WIKIAGENTEMAIL, WIKIAGENTNAME

General Macros

  • Set SERVERTIME = %DATETIME{"$year-$mo-$day $hours:$minutes:$seconds"}%
  • Set LOCALTIME = %DATETIME{format="$year-$mo-$day $hours:$minutes:$seconds" inchours="-7"}%
  • Set GMTIMEVAR = 20 May 2024 - 11:51

  • Set HILITE =
  • Set ENDHILITE =

  • Set BG_GREEN =
  • Set BG_YELLOW =
  • Set BG_RED =
  • Set BG_ORANGE =
  • Set BG_TAN =
  • Set BG_WHITE =
  • Set BG_BLACK =

  • Set ENDBG =

Plugin Settings

Do not make settings in plugins because they are overwritten whenever the foswiki system is updated. Instead, add your entries here.
  • Set INTERWIKIPLUGIN_RULESTOPIC = Inter Wikis, Inter Wikis
    • Note: Future upgrades will need to propagate topic Main.InterWikis

  • Set TABLEPLUGIN_TABLEATTRIBUTES = tableborder="1" headerrows="1" footerrows="0" initdirection="down" databg="#FFFFFF,#99FFFF" headerbg="#003366" headercolor="#FFFFFF"

The setting below does not work.
  • Set DATETIMEPLUGIN_TIMEZONEOFFSET = "-7"

  • Set UPDATEINFOPLUGIN_UPDATEINFODAYS = 30

SKIN

  • Set PATTERNSKIN_JQUERY_THEME = Pattern Skin Theme
  • Enable sidebar toggle
    • Set USERSTYLEURL = /w/pub/System/PatternSkinCssCookbookSidebarToggle/SidebarToggle.css

Caching

The following setting is if caching as supplied by foswiki is enabled. I have had trouble with this. # Set CACHELINK =

Cached at %DATETIME{format="$year-$mo-$day $hours:$minutes:$seconds" inchours="-7"}%. Rebuild this page.

The following setting is for the VARCACHE plugin. For this to work, an invocation like this %VARCACHE{refresh="n"}% must exist EXPLICITLY on the page, probably in comment braces. w/o nop!
  • This is no longer being used because it is not compatible with: Image Gallery Plugin nor multiple paged search outputs.
  • CACHELINK is set to nothing.
  • Set CACHELINK =
  • Set OLDCACHELINK =

    Cached at %DATETIME{format="$year-$mo-$day $hours:$minutes:$seconds" inchours="-7"}%. Rebuild the page.

Site-specific Macros

  • Set PHYSICALADDRESS = Citizens Oversight
    771 Jamacha Rd. #148
    El Cajon, CA 92019
   * Set NONOISEWHDR = nosummary="on" nosearch="on" nototal="on" zeroresults="off" noempty="on"
   * Set PAGEBREAK = <sticky><div style="page-break-before: always">&nbsp;</div></sticky>

Note, have had trouble with edit mode in this tblediticon definition because it does not pick up recent edits.
   * Set TBLEDITICON = [[$web.$topic][<img src=\"%ICONURL{viewtopic}%\" width=13 height=13 alt=\"View\" border=0 />]]

This is the part that does not work:<br>
[[%SCRIPTURL{edit}%/$web/$topic?nowysiwyg=1][<img src=\"%ICONURL{edittopic}%\" width=13 height=13 alt=\"Edit\" border=0 />]]

   * Set TBLEDITHDR = %ICON{note}%
   * Set VIEWURL = https://%HTTP_HOST%
   * Set STDTOC = %TWISTY{mode="div" showlink="Show Table of Contents&nbsp;" hidelink="Hide Table of Contents&nbsp;" 
     remember="on"  firststart="show" showimgright="%ICONURLPATH{toggleopen-small}%" 
     hideimgright="%ICONURLPATH{toggleclose-small}%"}%%TOC{depth="3" title="Table of Contents"}%%ENDTWISTY%

   * Set STDTOC2 = %TWISTY{mode="div" showlink="Show Table of Contents&nbsp;" hidelink="Hide Table of Contents&nbsp;" 
     remember="on"  firststart="show" showimgright="%ICONURLPATH{toggleopen-small}%" 
     hideimgright="%ICONURLPATH{toggleclose-small}%"}%%TOC{depth="2" title="Table of Contents"}%%ENDTWISTY%

   * Set VENUEOPTIONLIST = <OPTION selected="selected" name="OtherVenue">Other Venue</OPTION> 
      %SEARCH{search="form.name~'*VenueForm' AND PublishStatus != 'Hidden' " web="Common" nonoise="on" type="query" nosearch="on"  
      format="<OPTION value=\"$topic\">$formfield(Name)</OPTION> " nofinalnewline="on" separator=" " pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set USSTATESOPTIONLIST = <OPTION>AL</OPTION> <OPTION>AK</OPTION> <OPTION>AZ</OPTION> <OPTION>AR</OPTION> <OPTION SELECTED>CA</OPTION> <OPTION>CO</OPTION> <OPTION>CT</OPTION> <OPTION>DE</OPTION> <OPTION>FL</OPTION> <OPTION>GA</OPTION> <OPTION>HI</OPTION> <OPTION>ID</OPTION> <OPTION>IL</OPTION> <OPTION>IN</OPTION> <OPTION>IA</OPTION> <OPTION>KS</OPTION> <OPTION>KY</OPTION> <OPTION>LA</OPTION> <OPTION>ME</OPTION> <OPTION>MD</OPTION> <OPTION>MA</OPTION> <OPTION>MI</OPTION> <OPTION>MN</OPTION> <OPTION>MS</OPTION> <OPTION>MO</OPTION> <OPTION>MT</OPTION> <OPTION>NE</OPTION> <OPTION>NV</OPTION> <OPTION>NH</OPTION> <OPTION>NJ</OPTION> <OPTION>NM</OPTION> <OPTION>NY</OPTION> <OPTION>NC</OPTION> <OPTION>ND</OPTION> <OPTION>OH</OPTION> <OPTION>OK</OPTION> <OPTION>OR</OPTION> <OPTION>PA</OPTION> <OPTION>RI</OPTION> <OPTION>SC</OPTION> <OPTION>SD</OPTION> <OPTION>TN</OPTION> <OPTION>TX</OPTION> <OPTION>UT</OPTION> <OPTION>VT</OPTION> <OPTION>VA</OPTION> <OPTION>WA</OPTION> <OPTION>WV</OPTION> <OPTION>WI</OPTION> <OPTION>WY</OPTION> <OPTION>Other</OPTION>

   * Set CAELECTIONDISTRICTLIST = <OPTION>CA_Alameda</OPTION> <OPTION>CA_Alpine</OPTION> <OPTION>CA_Amador</OPTION> <OPTION>CA_Butte</OPTION> <OPTION>CA_Calaveras</OPTION> <OPTION>CA_Colusa</OPTION> <OPTION>CA_ContraCosta</OPTION> <OPTION>CA_DelNorte</OPTION> <OPTION>CA_ElDorado</OPTION> <OPTION>CA_Fresno</OPTION> <OPTION>CA_Glenn</OPTION> <OPTION>CA_Humboldt</OPTION> <OPTION>CA_Imperial</OPTION> <OPTION>CA_Inyo</OPTION> <OPTION>CA_Kern</OPTION> <OPTION>CA_Kings</OPTION> <OPTION>CA_Lake</OPTION> <OPTION>CA_Lassen</OPTION> <OPTION>CA_LosAngeles</OPTION> <OPTION>CA_Madera</OPTION> <OPTION>CA_Marin</OPTION> <OPTION>CA_Mariposa</OPTION> <OPTION>CA_Mendocino</OPTION> <OPTION>CA_Merced</OPTION> <OPTION>CA_Modoc</OPTION> <OPTION>CA_Mono</OPTION> <OPTION>CA_Monterey</OPTION> <OPTION>CA_Napa</OPTION> <OPTION>CA_Nevada</OPTION> <OPTION>CA_Orange</OPTION> <OPTION>CA_Placer</OPTION> <OPTION>CA_Plumas</OPTION> <OPTION>CA_Riverside</OPTION> <OPTION>CA_Sacramento</OPTION> <OPTION>CA_SanBenito</OPTION> <OPTION>CA_SanBernardino</OPTION> <OPTION>CA_SanDiego</OPTION> <OPTION>CA_SanFrancisco</OPTION> <OPTION>CA_SanJoaquin</OPTION> <OPTION>CA_SanLuisObispo</OPTION> <OPTION>CA_SanMateo</OPTION> <OPTION>CA_SantaBarbara</OPTION> <OPTION>CA_SantaClara</OPTION> <OPTION>CA_SantaCruz</OPTION> <OPTION>CA_Shasta</OPTION> <OPTION>CA_Sierra</OPTION> <OPTION>CA_Siskiyou</OPTION> <OPTION>CA_Solano</OPTION> <OPTION>CA_Sonoma</OPTION> <OPTION>CA_Stanislaus</OPTION> <OPTION>CA_Sutter</OPTION> <OPTION>CA_Tehama</OPTION> <OPTION>CA_Trinity</OPTION> <OPTION>CA_Tulare</OPTION> <OPTION>CA_Tuolumne</OPTION> <OPTION>CA_Ventura</OPTION> <OPTION>CA_Yolo</OPTION> <OPTION>CA_Yuba</OPTION>

   * Set COUNTRYOPTIONLIST = <OPTION>Afghanistan</OPTION> <OPTION>Albania</OPTION> <OPTION>Algeria</OPTION> <OPTION>Andorra</OPTION> <OPTION>Angola</OPTION> <OPTION>Anguilla</OPTION> <OPTION>Antigua & Barbuda</OPTION> <OPTION>Argentina</OPTION> <OPTION>Armenia</OPTION> <OPTION>Aruba</OPTION> <OPTION>Australia</OPTION> <OPTION>Austria</OPTION> <OPTION>Azerbaijan</OPTION> <OPTION>Bahamas</OPTION> <OPTION>Bahrain</OPTION> <OPTION>Bangladesh</OPTION> <OPTION>Barbados</OPTION> <OPTION>Belarus</OPTION> <OPTION>Belgium</OPTION> <OPTION>Belize</OPTION> <OPTION>Benin</OPTION> <OPTION>Bermuda</OPTION> <OPTION>Bhutan</OPTION> <OPTION>Bolivia</OPTION> <OPTION>Bosnia & Herzegovina</OPTION> <OPTION>Botswana</OPTION> <OPTION>Brazil</OPTION> <OPTION>Brunei</OPTION> <OPTION>Bulgaria</OPTION> <OPTION>Burkina Faso</OPTION> <OPTION>Burundi</OPTION> <OPTION>Cambodia</OPTION> <OPTION>Cameroon</OPTION> <OPTION>Canada</OPTION> <OPTION>Cape Verde</OPTION> <OPTION>Cayman Islands</OPTION> <OPTION>Central African Rep.</OPTION> <OPTION>Chad</OPTION> <OPTION>Chile</OPTION> <OPTION>China</OPTION> <OPTION>Colombia</OPTION> <OPTION>Comoros</OPTION> <OPTION>Congo</OPTION> <OPTION>Cook Islands</OPTION> <OPTION>Costa Rica</OPTION> <OPTION>Cote d'Ivoire</OPTION> <OPTION>Croatia</OPTION> <OPTION>Cuba</OPTION> <OPTION>Cyprus</OPTION> <OPTION>Czech Republic</OPTION> <OPTION>Denmark</OPTION> <OPTION>Djibouti</OPTION> <OPTION>Dominica</OPTION> <OPTION>Dominican Republic</OPTION> <OPTION>East Timor</OPTION> <OPTION>Ecuador</OPTION> <OPTION>Egypt</OPTION> <OPTION>El Salvador</OPTION> <OPTION>England</OPTION> <OPTION>Equatorial Guinea</OPTION> <OPTION>Eritrea</OPTION> <OPTION>Estonia</OPTION> <OPTION>Ethiopia</OPTION> <OPTION>Fareoe Islands</OPTION> <OPTION>Falkland Islands</OPTION> <OPTION>Fiji</OPTION> <OPTION>Finland</OPTION> <OPTION>France</OPTION> <OPTION>French Guiana</OPTION> <OPTION>French Polynesia</OPTION> <OPTION>Gabon</OPTION> <OPTION>Gambia</OPTION> <OPTION>Georgia</OPTION> <OPTION>Germany</OPTION> <OPTION>Ghana</OPTION> <OPTION>Gibraltar</OPTION> <OPTION>Great Britain</OPTION> <OPTION>Greece</OPTION> <OPTION>Greenland</OPTION> <OPTION>Grenada</OPTION> <OPTION>Guadeloupe</OPTION> <OPTION>Guam</OPTION> <OPTION>Guatemala</OPTION> <OPTION>Guinea</OPTION> <OPTION>Guinea-Bissau</OPTION> <OPTION>Guyana</OPTION> <OPTION>Haiti</OPTION> <OPTION>Honduras</OPTION> <OPTION>Hong Kong</OPTION> <OPTION>Hungary</OPTION> <OPTION>Iceland</OPTION> <OPTION>India</OPTION> <OPTION>Indonesia</OPTION> <OPTION>Iran</OPTION> <OPTION>Iraq</OPTION> <OPTION>Ireland</OPTION> <OPTION>Israel</OPTION> <OPTION>Italy</OPTION> <OPTION>Jamaica</OPTION> <OPTION>Japan</OPTION> <OPTION>Jordan</OPTION> <OPTION>Kazakhstan</OPTION> <OPTION>Kenya</OPTION> <OPTION>Kiribati</OPTION> <OPTION>Korea</OPTION> <OPTION>Kuwait</OPTION> <OPTION>Kyrgyzstan</OPTION> <OPTION>Laos</OPTION> <OPTION>Latvia</OPTION> <OPTION>Lebanon</OPTION> <OPTION>Lesotho</OPTION> <OPTION>Liberia</OPTION> <OPTION>Libya</OPTION> <OPTION>Liechtenstein</OPTION> <OPTION>Lithuania</OPTION> <OPTION>Luxembourg</OPTION> <OPTION>Macao</OPTION> <OPTION>Macedonia</OPTION> <OPTION>Madagascar</OPTION> <OPTION>Malawi</OPTION> <OPTION>Malaysia</OPTION> <OPTION>Maldives</OPTION> <OPTION>Mali</OPTION> <OPTION>Malta</OPTION> <OPTION>Marshall Islands</OPTION> <OPTION>Martinique</OPTION> <OPTION>Mauritania</OPTION> <OPTION>Mauritius</OPTION> <OPTION>Mexico</OPTION> <OPTION>Micronesia</OPTION> <OPTION>Moldova</OPTION> <OPTION>Monaco</OPTION> <OPTION>Mongolia</OPTION> <OPTION>Montserrat</OPTION> <OPTION>Morocco</OPTION> <OPTION>Mozambique</OPTION> <OPTION>Myanmar</OPTION> <OPTION>Namibia</OPTION> <OPTION>Nauru</OPTION> <OPTION>Nepal</OPTION> <OPTION>Netherlands</OPTION> <OPTION>Netherlands Antilles</OPTION> <OPTION>New Caledonia</OPTION> <OPTION>New Zealand</OPTION> <OPTION>Nicaragua</OPTION> <OPTION>Niger</OPTION> <OPTION>Nigeria</OPTION> <OPTION>Niue</OPTION> <OPTION>Norway</OPTION> <OPTION>Oman</OPTION> <OPTION>Pakistan</OPTION> <OPTION>Palau</OPTION> <OPTION>Panama</OPTION> <OPTION>Papua New Guinea</OPTION> <OPTION>Paraguay</OPTION> <OPTION>Peru</OPTION> <OPTION>Philippines</OPTION> <OPTION>Pitcairn</OPTION> <OPTION>Poland</OPTION> <OPTION>Portugal</OPTION> <OPTION>Puerto Rico</OPTION> <OPTION>Qatar</OPTION> <OPTION>Reunion</OPTION> <OPTION>Romania</OPTION> <OPTION>Russia</OPTION> <OPTION>Rwanda</OPTION> <OPTION>Samoa</OPTION> <OPTION>San Marino</OPTION> <OPTION>Sao Tome & Principe</OPTION> <OPTION>Saudi Arabia</OPTION> <OPTION>Senegal</OPTION> <OPTION>Seychelles</OPTION> <OPTION>Sierra Leone</OPTION> <OPTION>Singapore</OPTION> <OPTION>Slovakia</OPTION> <OPTION>Slovenia</OPTION> <OPTION>Solomon Islands</OPTION> <OPTION>Somalia</OPTION> <OPTION>South Africa</OPTION> <OPTION>Spain</OPTION> <OPTION>Sri Lanka</OPTION> <OPTION>St Helena</OPTION> <OPTION>St Kitts & Nevis</OPTION> <OPTION>St Lucia</OPTION> <OPTION>St Pierre & Miquelon</OPTION> <OPTION>St Vincent</OPTION> <OPTION>Sudan</OPTION> <OPTION>Suriname</OPTION> <OPTION>Swaziland</OPTION> <OPTION>Sweden</OPTION> <OPTION>Switzerland</OPTION> <OPTION>Syria</OPTION> <OPTION>Taiwan</OPTION> <OPTION>Tajikistan</OPTION> <OPTION>Tanzania</OPTION> <OPTION>Thailand</OPTION> <OPTION>Togo</OPTION> <OPTION>Tonga</OPTION> <OPTION>Trinidad & Tobago</OPTION> <OPTION>Tunisia</OPTION> <OPTION>Turkey</OPTION> <OPTION>Turkmenistan</OPTION> <OPTION>Turks & Caicos Is</OPTION> <OPTION>Tuvalu</OPTION> <OPTION>Uganda</OPTION> <OPTION>Ukraine</OPTION> <OPTION>United Arab Emirates</OPTION> <OPTION>United Kingdom</OPTION> <OPTION SELECTED>United States</OPTION> <OPTION>Uruguay</OPTION> <OPTION>Uzbekistan</OPTION> <OPTION>Vanuatu</OPTION> <OPTION>Vatican City</OPTION> <OPTION>Venezuela</OPTION> <OPTION>Vietnam</OPTION> <OPTION>Virgin Islands (US)</OPTION> <OPTION>Wallis & Futuna</OPTION> <OPTION>Yemen</OPTION> <OPTION>Zambia</OPTION> <OPTION>Zimbabwe</OPTION>

   * Set USSTATELIST = AL, AK, AZ, AR, CA, CO, CT, DE, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY, Other

   * Set COUNTRYLIST = Afghanistan, Albania, Algeria, Andorra, Angola, Anguilla, Antigua & Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia & Herzegovina, Botswana, Brazil, Brunei, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Cayman Islands, Central African Rep., Chad, Chile, China, Colombia, Comoros, Congo, Cook Islands, Costa Rica, Cote d'Ivoire, Croatia, Cuba, Cyprus, Czech Republic, Denmark, Djibouti, Dominica, Dominican Republic, East Timor, Ecuador, Egypt, El Salvador, England, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Fareoe Islands, Falkland Islands, Fiji, Finland, France, French Guiana, French Polynesia, Gabon, Gambia, Georgia, Germany, Ghana, Gibraltar, Great Britain, Greece, Greenland, Grenada, Guadeloupe, Guam, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iran, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Korea, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Libya, Liechtenstein, Lithuania, Luxembourg, Macao, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Martinique, Mauritania, Mauritius, Mexico, Micronesia, Moldova, Monaco, Mongolia, Montserrat, Morocco, Mozambique, Myanmar, Namibia, Nauru, Nepal, Netherlands, Netherlands Antilles, New Caledonia, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Pitcairn, Poland, Portugal, Puerto Rico, Qatar, Reunion, Romania, Russia, Rwanda, Samoa, San Marino, Sao Tome & Principe, Saudi Arabia, Senegal, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, Spain, Sri Lanka, St Helena, St Kitts & Nevis, St Lucia, St Pierre & Miquelon, St Vincent, Sudan, Suriname, Swaziland, Sweden, Switzerland, Syria, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad & Tobago, Tunisia, Turkey, Turkmenistan, Turks & Caicos Is, Tuvalu, Uganda, Ukraine, United Arab Emirates, United Kingdom, United States, Uruguay, Uzbekistan, Vanuatu, Vatican City, Venezuela, Vietnam, Virgin Islands (US), Wallis & Futuna, Yemen, Zambia, Zimbabwe

General

  • Set PROGRESSBAR =
    %TITLE% (Currently $%CURRENT%)
    $0$%GOAL%
    • Usage: PROGRESSBAR{TITLE="title" GOAL="number" CURRENT="number" WIDTH="pixels"}%

   * Set ALLAUDITS = %SEARCH{web="Elections" search="form.name~'*AuditForm' " noheader="on"  nototal="on" type="query" nosearch="on" format="   * [[$topic]]" order="$topic" excludetopic="AuditTopicTemplate"}%
   * Set DISTRICTAUDITS = %SEARCH{web="Elections" search="form.name~'*AuditForm' AND ElectionDistrict~'*%TOPIC%*' " noheader="on"  nototal="on" type="query" nosearch="on" format="   * [[$topic]]" order="$topic" excludetopic="AuditTopicTemplate"}%
   * Set DISTRICTAUDITHEADER = ---++ Audits of this District ([[Elections.NewAuditTopic][Add]])
   * Set ATTACHEDAUDITFILES = %ATTACHMENTLIST{sort="$fileName" sortorder="ascending" header="All files:" footer="Number of files: $fileCount" format="   * $fileIcon [[$fileUrl][$fileName]] ($fileSize) -- $fileComment" }%

   * Set SUBMITINCIDENTLINK = %SCRIPTURL{edit}%/Legal/LAUTOINC00000?templatetopic=Legal.LegalIncidentTopicTemplate&topicparent=Legal.LegalIncidents
   * Set INCIDENTLISTHDR = |  *Name (Last,First M)*  |  *Law Enforcement Dept*  |  *Book Num<br>Case Num*  |  *Date<br>Time*  |  *Violation Desc*  |  *Violation Location*  |  *Officer Name (Last, First)<br>Badge Num*  |  *Court Date*  |  *Bail /<br>Bond*  |  *Note*  |  *Tags*  |  *Event Topic*  |  *%TBLEDITHDR%*  |
   * Set INCIDENTLISTFORMAT = |$formfield(NameLast), $formfield(NameFirst) $formfield(NameMiddle)  |$web.$formfield(LawEnforcementDept)  |$formfield(BookNumber)<br>$formfield(CaseNum)  |$formfield(Date)<br>$formfield(Time)  |$formfield(ViolationDescription)  |$formfield(ViolationLocation)  |$formfield(OfficerLastName),&nbsp;$formfield(OfficerFirstName)<br>[[$web.$formfield(LawEnforcementDept)$formfield(BadgeNumber)][$formfield(BadgeNumber)]]  |$formfield(CourtDate)  |$formfield(BailAmount)<br>$formfield(BondAmount) |$formfield(Note)  |$formfield(Tags)  |$formfield(EventTopic)  |  %TBLEDITICON%  |
   * Set INCIDENTSBYDEPT = %SEARCH{search="form.name~'*LegalIncidentForm' AND LawEnforcementDept~'*%TOPIC%*' " web="Legal" type="query" nonoise="on" nosearch="on" format="%INCIDENTLISTFORMAT%" order="$formfield(Name)" excludetopic="LegalIncidentTopicTemplate"}%
   * Set INCIDENTSBYEVENT = %SEARCH{search="form.name~'*LegalIncidentForm' AND EventTopic~'*%TOPIC%*' " web="Legal" type="query" nonoise="on" nosearch="on" format="%INCIDENTLISTFORMAT%" order="$formfield(Name)" excludetopic="LegalIncidentTopicTemplate"}%

   * Set BADGELISTHDR = |  *Name (Last, First)*  |  *Law Enforcement Dept*  |  *Badge Num*  |  *Rank*  |
   * Set BADGELISTFORMAT = |$formfield(OfficerLastName),&nbsp;$formfield(OfficerFirstName)  | $formfield(LawEnforcementDept)  |   [[$web.$topic][$formfield(BadgeNumber)]]  |$formfield(OfficerRank)  |
   * Set BADGESBYDEPT = %SEARCH{search="form.name~'*BadgeForm' AND LawEnforcementDept~'*%TOPIC%*' " web="Legal" type="query" nonoise="on" nosearch="on" format="%BADGELISTFORMAT%" order="$formfield(OfficerLastName)" excludetopic="LegalIncidentTopicTemplate"}%
   * Set ALLBADGES = %SEARCH{search="form.name~'*BadgeForm' " web="Legal" type="query" nonoise="on" nosearch="on" format="%BADGELISTFORMAT%" order="$formfield(OfficerLastName)" excludetopic="BadgeTopicTemplate"}%


Affiliate Programs

  • Set AMAZONAFFILIATELINK = AmazonSmile.JPG



Social Bookmarks

DEPRECATED

   * Set SOCIALBOOKMARKS = <!-- Hupso Share Buttons - https://www.hupso.com/share/ --><div class="hupso-share-buttons"> [[https://www.hupso.com/share/][<img alt="Share Button" src="https://static.hupso.com/share/buttons/share-medium.png" style="border: 0px; padding-top: 5px; float: left;" />]]<script type="text/javascript">var hupso_services_t=new Array("Twitter","Facebook","Google Plus","Pinterest","Linkedin","Tumblr","StumbleUpon","Digg","Reddit","Bebo","Delicious");var hupso_url_t="https://www.CitizensOversight.org";var hupso_title_t="Citizens Oversight Projects (COPs)";var hupso_toolbar_size_t="medium";</script><script type="text/javascript" src="https://static.hupso.com/share/js/share_toolbar.js"></script></div>

   * Set MEDIASOCIALBOOKMARKS = <!-- Hupso Share Buttons - http://www.hupso.com/share/ --><div class="hupso-share-buttons"> [[http://www.hupso.com/share/][<img alt="Share Button" src="http://static.hupso.com/share/buttons/share-medium.png" style="border: 0px; padding-top: 5px; float: left;" />]]<script type="text/javascript">var hupso_services_t=new Array("Twitter","Facebook","Google Plus","Pinterest","Linkedin","Tumblr","StumbleUpon","Digg","Reddit","Bebo","Delicious");var hupso_url_t="http://www.CitizensOversight.org";var hupso_title_t="Citizens Oversight Projects (COPs)";var hupso_toolbar_size_t="medium";</script><script type="text/javascript" src="http://static.hupso.com/share/js/share_toolbar.js"></script></div>

   * Set FBCOMMENTS = %IF{" '%QUERY{"'%BASETOPIC%'/fields.ForumLink"}%' " then="<a href='%QUERY{"'%BASETOPIC%'/fields.ForumLink"}%' target='_blank'>Goto Discussion</a>" else="<div id=\"fb-root\"></div><script src=\"http://connect.facebook.net/en_US/all.js#appId=113186098729812&amp;xfbml=1\"></script><fb:comments href=\"http://%HTTP_HOST%/%BASEWEB%/%BASETOPIC%\" num_posts=\"50\" width=\"500\" reverse=\"0\"></fb:comments>"}%


  • Set REFSPEC = type="regex" format=" * $topic" nonoise="on" excludetopic="CopsCanvassReportIssuesBriefSummary" topic="CopsCanvassReport*"


   * Set VENUENAMEADDR_LINKED_INCLUDE = [[ Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}% ][ %FORMFIELD{"Name" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}% ]] at %FORMFIELD{"Address" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}%  %FORMFIELD{"CityStateZip" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}%

   * Set VENUENAMEADDR_SEARCHFORMAT = [[ Common.$formfield(Venue) ][ $percntFORMFIELD{\"Name\" topic=\"Common.$formfield(Venue)\"}$percnt ]] at 
      $percntFORMFIELD{\"Address\" topic=\"Common.$formfield(Venue)\"}$percnt  $percntFORMFIELD{\"CityStateZip\" topic=\"Common.$formfield(Venue)\"}$percnt

   * Set VENUENAMEADDR_FORHEAD =%FORMFIELD{"Name" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}% at 
      %FORMFIELD{"Address" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}%  %FORMFIELD{"CityStateZip" topic="Common.%FORMFIELD{Venue}%"}%

   * Set SPONSORINFO_LINKED_INCLUDE = %FORMFIELD{"Phone1" topic="Common.%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}%"}% or visit
      %FORMFIELD{"Website" topic="Common.%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}%"}%

   * Set SPONSORINFO_FOR_HEAD = %FORMFIELD{"Phone1" topic="Common.%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}%"}% or visit 
      %FORMFIELD{"Website" topic="Common.%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}%"}%

   * Set SPONSORINFO_SEARCHFORMAT = $percntFORMFIELD{\"Phone1\" topic=\"Common.$formfield(Sponsor)\"}$percnt or visit 
      $percntFORMFIELD{\"Website\" topic=\"Common.$formfield(Sponsor)\"}$percnt

   * Set PROGRAMINFO_LINKED_INCLUDE = [[%FORMFIELD{"Program" topic="%BASETOPIC%"}%][%FORMFIELD{"Title" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}%]] -- %FORMFIELD{"Note" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}%

   * Set PROGRAMINFO_FOR_HEAD = %FORMFIELD{"Title" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}% -- %FORMFIELD{"Note" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}%

   * Set PROGRAMINFO_SEARCHFORMAT = [[$topic][$percntFORMFIELD{\"Title\" topic=\"$formfield(Program)\"}$percnt]] -- $percntFORMFIELD{\"Note\" topic=\"$formfield(Program)\"}$percnt

   * Set THUMBNAILURL_LINKED_INCLUDE = %FORMFIELD{"ThumbnailLink" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}%

   * Set OURCALENDARENTRY_LINKED_INCLUDE =  %DATETIME{"$day $month $year" date="%FORMFIELD{"Date" topic="%INCLUDINGTOPIC%"}%"}% - %FORMFIELD{"Title" topic="%INCLUDINGTOPIC%"}% presents %PROGRAMINFO_LINKED_INCLUDE%  %VENUENAMEADDR_LINKED_INCLUDE% (%FORMFIELD{"EventTime" topic="%INCLUDINGTOPIC%"}%) sponsored by %FORMFIELD{"Sponsor" topic="%INCLUDINGTOPIC%"}%  Info: %SPONSORINFO_LINKED_INCLUDE% [[%WEB%.%TOPIC%][Details]]

   * Set GENCALENDARENTRY_INCLUDE = %DATETIME{"$lwday, $month $day" date="%FORMFIELD{"Date" topic="%BASETOPIC%"}%"}%, %FORMFIELD{"EventTime" topic="%BASETOPIC%"}%: - %FORMFIELD{"Title" topic="%BASETOPIC%"}% presents %PROGRAMINFO_LINKED_INCLUDE%, %VENUENAMEADDR_LINKED_INCLUDE% (%FORMFIELD{"Policy" topic="%BASETOPIC%"}%) Info: %SPONSORINFO_LINKED_INCLUDE%

   * Set GENNEWSENTRY_INCLUDE = %FORMFIELD{"Sponsor" topic="%BASETOPIC%"}% will sponsor %FORMFIELD{"Title" topic="%BASETOPIC%"}% presents %PROGRAMINFO_LINKED_INCLUDE% %DATETIME{"$lwday, $month $day" date="%FORMFIELD{"Date" topic="%BASETOPIC%"}%"}%, %FORMFIELD{"EventTime" topic="%BASETOPIC%"}%. At %VENUENAMEADDR_LINKED_INCLUDE% (%FORMFIELD{"Policy" topic="%BASETOPIC%"}%) Info: %SPONSORINFO_LINKED_INCLUDE%

   * Set SDDEMENTRY_LINKED_INCLUDE = 
%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}% %FORMFIELD{"Title" topic="%BASETOPIC%"}%. %DATETIME{"$lwday, $lmonth $day" date="%FORMFIELD{"Date" topic="%BASETOPIC%"}%"}%, %FORMFIELD{"EventTime" topic="%BASETOPIC%"}% %PROGRAMINFO_LINKED_INCLUDE%. %VENUENAMEADDR_LINKED_INCLUDE% (%FORMFIELD{"Policy" topic="%BASETOPIC%"}%) Info: %SPONSORINFO_LINKED_INCLUDE%

   * Set SDDEMENTRY_SEARCHFORMAT = $formfield(Sponsor) $formfield(Title). $percntDATETIME{\"$lwday, $lmonth $day\" date=\"$formfield(Date)\"}$percnt, $formfield(EventTime): %PROGRAMINFO_SEARCHFORMAT%. %VENUENAMEADDR_SEARCHFORMAT% ($formfield(Policy)) Info: %SPONSORINFO_SEARCHFORMAT%

Note:Upcoming events will use only MediaForm topics.
   * Set UPCOMINGEVENTS = <table border="0" cellspacing="1">
     %SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" excludetopic="MediaTopicTemplate" pager="%IF{"context authenticated" then="on" else="off"}%"}%</table>

   * Set KEYWORDUPCOMINGEVENTS = <table border=0 cellspacing=1>
     %SEARCH{web="Events,Common" search="form.name~'*MediaForm*' AND MediaType~'*Meeting*'  AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' AND (Keywords~'*%TOPIC%*' OR Note~'*%TOPIC%*')" 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" excludetopic="MediaTopicTemplate" pager="%IF{"context authenticated" then="on" else="off"}%"}%</table>

   * Set KEYWORDUPCOMINGEVENTS400 = <table border=0 cellspacing=1>
     %SEARCH{web="Events,Common" search="form.name~'*MediaForm*' AND MediaType~'*Meeting*'  AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' AND (Keywords~'*%TOPIC%*' OR Note~'*%TOPIC%*')" 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' width='400' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" excludetopic="MediaTopicTemplate" pager="%IF{"context authenticated" then="on" else="off"}%"}%</table>

   * Set RECENTEVENTS = <table border=0 cellspacing=1>%SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 30)) AND ((D2N PubDate) <= (NOW)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" reverse="on" excludetopic="PromoTopicTemplate" limit="20" pager="%IF{"context authenticated" then="on" else="off"}%"}%</table>

   * Set KEYWORDRECENTEVENTS = <table border=0 cellspacing=1>%SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 30)) AND ((D2N PubDate) <= (NOW)) AND PublishStatus != 'Hidden'  AND (Keywords~'*%TOPIC%*' OR Note~'*%TOPIC%*')" 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" reverse="on" excludetopic="PromoTopicTemplate" limit="20" pager="%IF{"context authenticated" then="on" else="off"}%"}%</table>

   * Set KEYWORDPASTEVENTS400 = %SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) <= (NOW)) AND PublishStatus != 'Hidden'  AND (Keywords~'*%TOPIC%*' OR Note~'*%TOPIC%*')" 
         nonoise="on" type="query" nosearch="on" 
         format="$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]<br>[[$web.$topic][<img src='$formfield(ThumbnailLink)' width='400' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]]<br>$formfield(EmbedHTML)<br><hr><br>" 
         order="formfield(PubDate)" reverse="on" excludetopic="PromoTopicTemplate,%TOPIC%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set RECENTEVENTSSHORT = <table border=0 cellspacing=1>%SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 30)) AND ((D2N PubDate) <= (NOW)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" reverse="on" excludetopic="PromoTopicTemplate" limit="5"
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]] </td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" order="formfield(Date)" pager="%IF{"context authenticated" then="on" else="off"}%"}%</table>

   * Set RECENTEVENTTHUMBS = %SEARCH{web="Events,Common" search="(form.name~'*PromoForm*'  AND ((D2N Date) >= (NOW - 86400 * 30))  AND ((D2N PubDate) <= (NOW)) OR form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 30))  AND ((D2N PubDate) <= (NOW))) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" order="formfield(Date)" reverse="on" excludetopic="PromoTopicTemplate" limit="20" nofinalnewline="on" separator=""
         format="[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]]" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set UPCOMINGEVENTSCALFORMAT = %SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*'  AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" 
         format="   * $pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*)" order="formfield(PubDate)" excludetopic="MediaTopicTemplate" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set UPCOMINGEVENTSNEWSFORMAT = %SEARCH{web="Events,Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" format="$n   * $formfield(Title)" order="formfield(PubDate)" excludetopic="MediaTopicTemplate" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set ADDPROMOEVENTLINK = %SCRIPTURLPATH{edit}%/Events/EAUTOINC00000?templatetopic=PromoTopicTemplate&topicparent=WebHome&formtemplate=PromoForm

   * Set RELATEDEVENTS = <table border=0 cellspacing=1>%SEARCH{web="Events,Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND (Program~'*%BASETOPIC%*' OR Venue~'*%BASETOPIC%*') AND PublishStatus != 'Hidden'" 
         nonoise="on" type="query" nosearch="on" format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='%QUERY{"Title"}%' onMouseOver=\"window.status='%QUERY{"Title"}%'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" order="formfield(PubDate)" excludetopic="PromoTopicTemplate" pager="%IF{"context authenticated" then="on" else="off"}%"}%</table>




   * Set PUBLISHTEST = %SEARCH{"PUBLISH_" topic="PublishConfigTest" type="regex" multiple="on" nonoise="on" format="   * $pattern(^ +\* Set *PUBLISH_([^\n\r]+).*)"}%<p><form method="POST" name="rename" action="%SCRIPTURLPATH{rest}%/PublishPlugin/publish"><input type="hidden" name="topic" value="%WEB%.%TOPIC%" /><input type="hidden" name="configtopic" value="%WEB%.PublishConfigTest" /><input type="hidden" name="ping" value="%SERVERTIME%" /><input type="submit" class="twikiSubmit" value="Publish to publishtest" /></form>

   * Set PUBLISHRELEASE = %SEARCH{"PUBLISH_" topic="PublishConfigRelease" type="regex" multiple="on" nonoise="on" format="   * $pattern(^ +\* Set *PUBLISH_([^\n\r]+).*)"}%<p><form method="POST" name="rename" action="%SCRIPTURLPATH{rest}%/PublishPlugin/publish"><input type="hidden" name="topic" value="%WEB%.%TOPIC%" /><input type="hidden" name="configtopic" value="%WEB%.PublishConfigRelease" /><input type="hidden" name="ping" value="%SERVERTIME%" /><input type="submit" class="twikiSubmit" value="Publish to root" /></form><p> *Command Line:* <br> perl -T rest /PublishPlugin/publish topic=%WEB%.%TOPIC% configtopic=%WEB%.PublishConfigRelease

   * Set PUBLISHCOMMON = %SEARCH{"PUBLISH_" topic="PublishConfigCommon" type="regex" multiple="on" nonoise="on" format="   * $pattern(^ +\* Set *PUBLISH_([^\n\r]+).*)"}%


Activist Letters


   * Set ACTIVISTLETTERFORMAT = "<div style=\"page-break-before: always\"> <div align=\"center\"> %URLPARAM{UserNameFirst}% %URLPARAM{UserNameLast}%<br/> %URLPARAM{UserAddress}% <br/> %URLPARAM{UserCityStateZip}% <br/> %URLPARAM{UserPhone}% <br/> %URLPARAM{UserEmail}% <br/> <br/></div> %DATE% <br/><br/> 
$formfield(NameFirst) $formfield(NameLast)<br/> %SPACEOUT{$formfield(Organization)}%  <br/> $formfield(PositionTitle)  <br/> $formfield(Address)  <br/> $formfield(CityStateZip)  <br/> &nbsp; <p/> Dear $formfield(NameFirst) $formfield(NameLast): <br/> <br/> %URLPARAM{"LetterBody" newline="<br />"}% <br/> <br/> Sincerely, <br>&nbsp;<br>&nbsp;<br>&nbsp;<br/> %URLPARAM{UserNameFirst}% %URLPARAM{UserNameLast}% </div>"


Media Database


   * Set PAGESIZE = 100

   * Set UNQMEDIAFORMAT =  $percntIF{\"'$formfield(MediaType)'~'*Pictures*'\" then=\"<img src=\\"%ICONURLPATH{jpg}%\\" alt=\\"Images\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Video*'\" then=\"<img src=\\"%ICONURLPATH{mov}%\\" alt=\\"Video\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Audio*'\" then=\"<img src=\\"%ICONURLPATH{mp3}%\\" alt=\\"Audio\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*PDF*'\" then=\"<img src=\\"%ICONURLPATH{pdf}%\\" alt=\\"PDF\\" title=\\"PDF\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Presentation*'\" then=\"<img src=\\"%ICONURLPATH{ppt}%\\" alt=\\"Presentation\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Book*'\" then=\"<img src=\\"%ICONURLPATH{book}%\\" alt=\\"Book\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Article*' OR '$formfield(MediaType)'~'*File*'\" then=\"<img src=\\"%ICONURLPATH{viewtopic}%\\" alt=\\"Article\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Website*'\" then=\"<img src=\\"%ICONURLPATH{sitetree}%\\" alt=\\"Website\\" width=16 height=16 border=0 />\"}$percnt[[$web.$topic][($topic)]] $formfield(PubDate) <i>[[$web.$topic][$formfield(Title)]] $percntISNEW$nop%</i> -- $percntIF{\"istopic '$formfield(Author)'\" then=\"$formfield(Author)\" else=\"$percntSPACEOUT{$formfield(Author)}%\"}$percnt, $percntIF{\"istopic '$formfield(Publisher)'\" then=\"$formfield(Publisher)\" else=\"$percntSPACEOUT{$formfield(Publisher)}%\"}$percnt, $formfield(Note)
   * Set MEDIAFORMAT = "   * %UNQMEDIAFORMAT%"

   * Set MEDIAFORMATWEMBED = "<p>%UNQMEDIAFORMAT%</p><p><noautolink>$formfield(EmbedHTML)<autolink></p><p>&nbsp;"

   * Set MEDIAFORMAT_NOISNEW = "   * $percntIF{\"'$formfield(MediaType)'*'*Pictures*'\" then=\"<img src=\\"%ICONURLPATH{jpg}%\\" alt=\\"Images\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Video*'\" then=\"<img src=\\"%ICONURLPATH{mov}%\\" alt=\\"Video\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Audio*'\" then=\"<img src=\\"%ICONURLPATH{mp3}%\\" alt=\\"Audio\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*PDF*'\" then=\"<img src=\\"%ICONURLPATH{pdf}%\\" alt=\\"PDF\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Presentation*'\" then=\"<img src=\\"%ICONURLPATH{ppt}%\\" alt=\\"Presentation\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Book*'\" then=\"<img src=\\"%ICONURLPATH{book}%\\" alt=\\"Book\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Article*' OR '$formfield(MediaType)'~'*File*'\" then=\"<img src=\\"%ICONURLPATH{viewtopic}%\\" alt=\\"Article\\" title=\\"Article\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Website*'\" then=\"<img src=\\"%ICONURLPATH{sitetree}%\\" alt=\\"Website\\" width=16 height=16 border=0 />\"}$percnt$percnt[[$web.$topic][($topic)]] $formfield(PubDate) <i>[[$web.$topic][$formfield(Title)]]</i> -- $percntIF{\"istopic '$formfield(Author)'\" then=\"$formfield(Author)\" else=\"$percntSPACEOUT{$formfield(Author)}%\"}$percnt, $percntIF{\"istopic '$formfield(Publisher)'\" then=\"$formfield(Publisher)\" else=\"$percntSPACEOUT{$formfield(Publisher)}%\"}$percnt, $formfield(Note)

   * Set SUBMITMEDIALINK = %SCRIPTURL{edit}%/Common/MAUTOINC0?templatetopic=Common.MediaTopicTemplate&topicparent=Common.NewsMedia&formtemplate=Common.MediaForm

   * Set KEYWORDTOPICRECENTMEDIA = %SEARCH{web="Common" 
     search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Author~'*%BASETOPIC%*' OR Publisher~'*%BASETOPIC%*' OR Activist~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'"
     noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" limit="20" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set KEYWORDTOPICMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="off" type="query" nosearch="on" format=""}%
     %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="on"}%

   * Set KEYWORDTOPICMEDIA_NOPAGER = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="off" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" pager="off"}%

   * Set KEYWORDTOPICRESEARCH = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' AND MediaGroup~'*Research*' " noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% reverse="on" order="formfield(PubDate)" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set KEYWORDMEDIAHIGHLIGHTED = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%KEYWORD%*' OR Note~'*%KEYWORD%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' AND CuratorRating='Highlighted' " noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" header="$pager" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%
      * Usage: % KEYWORDMEDIAHIGHLIGHTED{KEYWORD="keyword"}%

   * Set TOPICMEDIAHIGHLIGHTEDWEMBED = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*' ) AND PublishStatus!='Hidden' AND CuratorRating='Highlighted' AND MediaType~'*Video*' " noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMATWEMBED% order="formfield(PubDate)" reverse="on" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set KEYWORDMEDIA = %SEARCH{web="Common" 
         search="form.name~'*MediaForm' AND (Keywords~'*%KEYWORD%*' OR Note~'*%KEYWORD%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' " 
         noheader="on"  nototal="off" type="query" nosearch="on" format="" }%
      %SEARCH{web="Common" 
         search="form.name~'*MediaForm' AND (Keywords~'*%KEYWORD%*' OR Note~'*%KEYWORD%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' " 
         noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%
      * Usage: % KEYWORDMEDIA{KEYWORD="keyword"}%

   * Set KEYWORDRECENTMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%KEYWORD%*' OR Note~'*%KEYWORD%*'  OR text~'*%KEYWORD%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' " noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" limit="20" pager="%IF{"context authenticated" then="on" else="off"}%"}%
      * Usage: % KEYWORDRECENTMEDIA{KEYWORD="keyword"}%

   * Set KEYWORDTOPICMEDIABYTITLE = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Author~'*%BASETOPIC%*' OR Publisher~'*%BASETOPIC%*' OR Activist~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*'   OR text~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(Title)" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set LISTEXPLICITMEDIA = %FORMAT{"%TOPICLIST%" type="topic" format=%MEDIAFORMAT%}%
      * Usage: LISTEXPLICITMEDIA{TOPICLIST="topic,topic"}%

   * Set LISTEXPLICITMEDIAWEMBED = %FORMAT{"%TOPICLIST%" type="topic" format=%MEDIAFORMATWEMBED%}%
      * Usage: LISTEXPLICITMEDIAWEMBED{TOPICLIST="topic,topic"}%

   * Set CONTEXTTOPICMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (text~'*%SPACEOUT{%BASETOPIC%}%*' OR text~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on"}%

   * Set CONTEXTTOPICS = %SEARCH{web="Common" search="(NOT form.name~'*MediaForm') AND (text~'*%SPACEOUT{%BASETOPIC%}%*' OR text~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format="  * $topic" order="$topic"}%

   * Set SELECTEDMEDIA1 = %SEARCH{web="Common" search="form.name~'*MediaForm' AND %MEDIASELECTCRITERIA1% 
     AND PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT%}%

   * Set SELECTEDMEDIA2 = %SEARCH{web="Common" search="form.name~'*MediaForm' AND %MEDIASELECTCRITERIA2% AND 
     PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT%}%

   * Set SELECTEDMEDIA3 = %SEARCH{web="Common" search="form.name~'*MediaForm' AND %MEDIASELECTCRITERIA3% AND
      PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT%}%

   * Set ALLMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="off" nosearch="on" type="query" format="" excludetopic="MediaTopicTemplate"}%
     %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set PRESSROOM = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaGroup~'*NewsRelease*' AND Publisher~'*CitizensOversight*' " 
     noheader="on"  nototal="off" type="query" nosearch="on" format="" excludetopic="MediaTopicTemplate"}%
     %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaGroup~'*NewsRelease*' AND Publisher~'*CitizensOversight*' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set LATESTPRESS = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaGroup~'*NewsRelease*' AND Publisher~'*CitizensOversight*' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate" limit="10" }%

   * Set ALLMEDIABYNAME = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="$topic" excludetopic="MediaTopicTemplate"  header="$pager" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set ALLCOPSMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND (MediaGroup~'*RequestLetter*' OR MediaGroup~'*ResponseLetter*)' " 
     noheader="on"  nototal="off" type="query" nosearch="on" 
     format="" excludetopic="MediaTopicTemplate"}%
     %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND (MediaGroup~'*RequestLetter*' OR MediaGroup~'*ResponseLetter*)' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate"  header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set ALLGOVTMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND (MediaGroup~'*GovtDoc*' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate"  header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set ALLMODIFIEDMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="modified" reverse="on" excludetopic="MediaTopicTemplate"  header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set MODIFIEDMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="modified" reverse="on" excludetopic="MediaTopicTemplate" limit="10"}%

   * Set MODIFIEDNONMEDIA = %SEARCH{web="Common" search="NOT form.name~'*MediaForm' AND NOT uc(text)~'*INFRASTRUCTURE*' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format="   * [[$topic]] %ISNEW% - $summary" order="modified" reverse="on" excludetopic="Web*, EventList, MediaTopicHeader, MediaTopicTemplate" limit="10"}%

   * Set ALLHIDDENMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" 
     reverse="on" excludetopic="MediaTopicTemplate" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set AUTHORSEARCH = %SEARCH{web="Common" 
      search="form.name~'*MediaForm' AND (Author~'*%TOPIC%*' OR Publisher~'*%TOPIC%*' OR Activist~'*%TOPIC%*' OR Note~'*%TOPIC%*' OR Keywords~'*%TOPIC%*'  OR text~'*%TOPIC%*') AND PublishStatus!='Hidden'" 
      noheader="on"  nototal="off" nosearch="on" type="query"  format="" excludetopic="MediaTopicTemplate" }%
      %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Author~'*%TOPIC%*' OR Publisher~'*%TOPIC%*' OR Activist~'*%TOPIC%*' OR Note~'*%TOPIC%*' OR Keywords~'*%TOPIC%*'  OR text~'*%TOPIC%*') AND PublishStatus!='Hidden'" 
      noheader="on"  nosummary="on" type="query" nototal="on" nosearch="on" format=%MEDIAFORMAT% excludetopic="MediaTopicTemplate" 
      order="formfield(PubDate)" reverse="on" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%


   * Set PUBLISHERSEARCH = %AUTHORSEARCH%

   * Set DATASETLIST = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Author~'*%TOPIC%*' OR Publisher~'*%TOPIC%*' OR Activist~'*%TOPIC%*' OR Note~'*%TOPIC%*' OR Keywords~'*%TOPIC%*'  OR text~'*%TOPIC%*') AND PublishStatus!='Hidden' AND MediaType~'*Dataset*'" 
     noheader="on"  nosummary="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" header="$pager" footer="$pager" pagesize="%PAGESIZE%" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set MEDIASUMMARYHEADER = ---++ Summary of articles submitted ([[%SUBMITMEDIALINK%][Add]]  | [[Common.NewsMedia][All]]):

Note: embed does not work in Chrome. Must use iframe but if this is used in firefox, it pops open the document in another window instead of in-line.
   * Set EMBEDPDFMEDIA = <iframe src="%QUERY{"MediaLink"}%" type="application/x-pdf" width="700" height="890"></iframe>
   * Set EMBEDPDFMEDIALAND = <iframe src="%QUERY{"MediaLink"}%" type="application/x-pdf" width="700" height="540"></iframe>
Note: embed does not work in Chrome. Must use iframe but if this is used in firefox, it pops open the document in another window instead of in-line.

   * Set EMBEDPDFBYURL = <iframe  src='%ENCODE{"%URL%"}%#toolbar=1' type='application/pdf' width='700px' height='890px'>iframe tag not supported. Click <a href="%URL%" target="new">here</a> to view the document.</iframe><br>If the document does not display above, click <noautolink><a href="%URL%" target="new">here</a></noautolink>
      * Usage: EMBEDPDFBYURL{URL="full pdf url"}%
   * Set EMBEDPDFLANDBYURL = <iframe  src='%ENCODE{"%URL%"}%#toolbar=1' type='application/pdf' width='700px' height='540px'>iframe tag not supported. Click <a href="%URL%" target="new">here</a> to view the document.</iframe><br>If the document does not display above, click <noautolink><a href="%URL%" target="new">here</a></noautolink>
      * Usage: EMBEDPDFLANDBYURL{URL="full pdf url"}%

   * S et EMBEDPDFMEDIA = <embed src="%QUERY{"MediaLink"}%" type="application/x-pdf" width="700" height="890"/><br>If the document does not display above, click <a href="%QUERY{"MediaLink"}%" target="new">here</a>
   * S et EMBEDPDFMEDIALAND = <embed src="%QUERY{"MediaLink"}%" type="application/x-pdf" width="700" height="540"/><br>If the document does not display above, click <a href="%QUERY{"MediaLink"}%" target="new">here</a>

   * S et EMBEDPDFMEDIA = <object data='%ENCODE{"%QUERY{"MediaLink"}%"}%#toolbar=1' type='application/pdf' width='700px' height='890px'>Object tag not supported. Click <a href="%QUERY{"MediaLink"}%" target="new">here</a> to view the document.</object><br>If the document does not display above, click <noautolink><a href="%QUERY{"MediaLink"}%" target="new">here</a></noautolink>
   * S et EMBEDPDFMEDIALAND = <object data='%ENCODE{"%QUERY{"MediaLink"}%"}%#toolbar=1' type='application/pdf' width='700px' height='540px'>Object tag not supported. Click <a href="%QUERY{"MediaLink"}%" target="new">here</a> to view the document.</object><br>If the document does not display above, click <noautolink><a href="%QUERY{"MediaLink"}%" target="new">here</a></noautolink>

   * S et EMBEDPDFBYURL = <iframe  data='%ENCODE{"%URL%"}%#toolbar=1' type='application/pdf' width='700px' height='890px'>Object tag not supported. Click <a href="%URL%" target="new">here</a> to view the document.</object><br>If the document does not display above, click <noautolink><a href="%URL%" target="new">here</a></noautolink>
      * Usage: EMBEDPDFBYURL{URL="full pdf url"}%
   * S et EMBEDPDFLANDBYURL = <object data='%ENCODE{"%URL%"}%#toolbar=1' type='application/pdf' width='700px' height='540px'>Object tag not supported. Click <a href="%URL%" target="new">here</a> to view the document.</object><br>If the document does not display above, click <noautolink><a href="%URL%" target="new">here</a></noautolink>
      * Usage: EMBEDPDFLANDBYURL{URL="full pdf url"}%

   * Set RIGHTBARFORMAT = "<tr><td bgcolor=\"#FFFFFF\" colspan=2><center><b> [[$topic][$formfield(Title,1000,\"<br/>\")]] </b>$formfield(Note,1000,\"<br/>\")<br>$formfield(EmbedHTML)</center></td></tr>"

   * Set RIGHTBARSCREENDIM = width="300" height="212"

   * Set COPSVIDEOMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaType~'*Video*' AND Publisher='CitizensOversight' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMATWEMBED% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate"  header="$pager" footer="$pager" pagesize="25" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set OTHERVIDEOMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaType~'*Video*' AND Publisher!='CitizensOversight' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMATWEMBED% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate" header="$pager" footer="$pager" pagesize="25" pager="%IF{"context authenticated" then="on" else="off"}%"}%

   * Set AUDIOMEDIA = <audio controls><source src="%QUERY{"MediaLink"}%" type="audio/mpeg">Your browser does not support the audio element. [[%QUERY{"MediaLink"}%][Try playing it directly.]]</audio>

#   * Set AUDIOMEDIA = <audio controls><source src="formfield(MediaLink)" type="audio/mpeg">Your browser does not support the audio element. [[formfield(MediaLink)][Try playing it directly.]]</audio>


   * Set ATTACHEDFILELIST = %ATTACHMENTLIST{sort="$fileName" sortorder="ascending" header="All files:" footer="Number of files: $fileCount" format="   * $fileIcon <a href=\"$fileUrl\" target=\"_blank\">$fileName</a> ($fileSize) -- $fileComment" }%


People Database


   * Set PROJECTPEOPLEHDR = |  *Name*  |  *Address<BR>City, State, Zip*  |  *Phone1<BR>Phone2*  |  *email*  |  *Orgs; Positions; Notes*  |  *Edit*  |
   * Set PROJECTPEOPLEFORMATNQ = |<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink>  |<span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span>  |$formfield(Phone1)<BR>$formfield(Phone2)  |$formfield(Email)  |$formfield(Organization); $formfield(PositionsHeld); $formfield(Note)  |  %TBLEDITICON%  |
   * Set PROJECTPEOPLE = %SEARCH{web="People" search="form.name ~ '*PeopleForm' AND (KeywordTags ~ '*%TOPIC%*' OR Tags ~ '*%TOPIC%*' OR Note ~ '*%TOPIC%*') AND NOT Association~'Adversary' " noheader="on"  type="query" nosearch="on" format="%PROJECTPEOPLEFORMATNQ%"}%
   * Set PROJECTADVERSARIES = %SEARCH{web="People" search="form.name ~ '*PeopleForm' AND (KeywordTags ~ '*%TOPIC%*' OR Tags ~ '*%TOPIC%*' OR Note ~ '*%TOPIC%*') AND Association~'Adversary'  " noheader="on"  type="query" nosearch="on" format="%PROJECTPEOPLEFORMATNQ%"}%
   * Set PROJECTPEOPLEEMAILLIST = %SEARCH{web="People" search="form.name ~ '*PeopleForm' AND (KeywordTags ~ '*%TOPIC%*' OR Tags ~ '*%TOPIC%*' OR Note ~ '*%TOPIC%*') AND NOT Association~'Adversary'  " noheader="on"  type="query" nosearch="on" format="$formfield(Email)<br>"}%
   * Set CONTACTFORMAT = "   * [[$topic][$formfield(NameFirst) $formfield(NameLast)]] $formfield(Email) $formfield(Phone1)"

   * Set MEMBTRANSACTIONHEADER = |  *Date*  |  *Num*  |  *Amt*  |  *Pmt Type*  |  *Type*  |  *Item*  |  *Description*  |  *Count*  |  *Entity*  |  *...*  |

   * Set MEMBTRANSACTIONFORMATNQ = |$formfield(TransDate)  |$formfield(TransChkNum)  |$formfield(TransAmt)  |<noautolink>$formfield(TransPmtType) </noautolink> |$formfield(TransType)  |$formfield(TransItem)  |$formfield(TransDesc)  |$formfield(TransCount)  |<noautolink>$formfield(TransEntity)<autolink>  |  %TBLEDITICON%  |

   * Set MEMBTRANSACTIONFORMAT = "%MEMBTRANSACTIONFORMATNQ%"

   * Set TRANSACTIONHEADER = %MEMBTRANSACTIONHEADER%  *Memb Topic*  |

   * Set TRANSACTIONFORMAT = "%MEMBTRANSACTIONFORMATNQ% [[People.$formfield(MembTopic)][$percntFORMFIELD{\"NameFirst\" topic=\"People.$formfield(MembTopic)\"}$percnt $percntFORMFIELD{\"NameLast\" topic=\"People.$formfield(MembTopic)\"}$percnt]]  |"

   * Set MEMBLISTTRANSFORMAT = "<p>[[People.$formfield(MembTopic)][$percntFORMFIELD{\"NameFirst\" topic=\"People.$formfield(MembTopic)\"}$percnt $percntFORMFIELD{\"NameLast\" topic=\"People.$formfield(MembTopic)\"}$percnt]] ($formfield(TransCount))<br>$percntFORMFIELD{\"Address\" topic=\"People.$formfield(MembTopic)\"}$percnt <br> $percntFORMFIELD{\"CityStateZip\" topic=\"People.$formfield(MembTopic)\"}$percnt <br> $percntFORMFIELD{\"Phone1\" topic=\"People.$formfield(MembTopic)\"}$percnt $percntFORMFIELD{\"Phone2\" topic=\"People.$formfield(MembTopic)\"}$percnt"<br> $percntFORMFIELD{\"Email\" topic=\"People.$formfield(MembTopic)\"}$percnt $percntFORMFIELD{\"Email2\" topic=\"People.$formfield(MembTopic)\"}$percnt"

   * Set MEMBERINFOHEADER = |  *Name*  |  *Address / email*  |  *Phone*  |  *Level<BR>Date*  |  *Interest<br>Contrib*  |  *Note / Tags*  |  *...*  |

   * Set MEMBERINFOFORMAT = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink> [[$web.$topic][<nop>]] %ISNEW%  |<noautolink><span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span><br></noautolink> $formfield(Email, 35) $formfield(Email2, 35)   |<noautolink>$formfield(Phone1)<BR>$formfield(Phone2)</noautolink> |$formfield(Level)<BR>$formfield(DatePaid2008)  $formfield(DatePaid)  |$formfield(Interest) <br> $formfield(Lutz08Contrib)  |$formfield(Note) $formfield(Tags) $formfield(Processing) |  %TBLEDITICON%  |"

   * Set MEMBERSEARCHSPEC = search="form.name~'*PeopleForm' AND lc(NameLast)~lc('%URLPARAM{NameLast}%*') AND lc(NameFirst)~lc('%URLPARAM{NameFirst}%*') AND (lc(Email)~lc('*%URLPARAM{Email}%*') OR  lc(Email2)~lc('*%URLPARAM{Email}%*') ) AND (Phone1~'*%URLPARAM{Phone}%*' OR Phone2~'*%URLPARAM{Phone}%*') AND lc(Address)~lc('%URLPARAM{Address}%*') AND lc(CityStateZip)~lc('%URLPARAM{CityStateZip}%*') "


   * Set CONTACTSIMPLEHEADER = |  *Name*  |  *Address / email*  |  *Phone*  |  *...*  |

   * Set CONTACTSIMPLEFORMAT = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink> [[$web.$topic][<nop>]] %ISNEW% <br>$formfield(PositionsHeld)  |<noautolink><span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span><br></noautolink> $formfield(Email) $formfield(Email2)   |<noautolink>$formfield(Phone1)<BR>$formfield(Phone2)</noautolink> |  %TBLEDITICON%  |"

   * Set TAGGEDMEMBERS = %SEARCH{web="People" search="form.name~'*PeopleForm*' AND Tags~'*%TOPIC%*' " format=%CONTACTSIMPLEFORMAT% nonoise="on" type="query" nosearch="on" }%

   * Set TAGGEDMEMBERHEADER = %CONTACTSIMPLEHEADER%

Use:
TAGGEDMEMBERHEADER%
TAGGEDMEMBERS%

   * Set MEMBERORGHEADER = |  *Name*  |  *Organization*  |  *Address / email*  |  *Phone*  |  *Notes*  |  *...*  |

   * Set MEMBERORGFORMAT = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink> [[$web.$topic][<nop>]] %ISNEW%  |$formfield(Organization)  |<noautolink><span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span><br></noautolink> $formfield(Email, 35) $formfield(Email2, 35)   |<noautolink>$formfield(Phone1)<BR>$formfield(Phone2)</noautolink>  |$formfield(Note)  |  %TBLEDITICON%  |"

   * Set PHONELISTHEADERNOEMAIL = |  *Name*  |  *Phones* |  *Notes*  |  *...*  |
   * Set PHONELISTFORMATNOEMAIL = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink>  |$formfield(Phone1)<br>$formfield(Phone2)  |Paid: $formfield(DatePaid2008) <br> $formfield(Note); $formfield(LastContact)  |  %TBLEDITICON%  |"

   * Set PHONELISTHEADEREMAIL = |  *Name*  |  *Phones* |  *Email*  |  *Notes*  |  *...*  |
   * Set PHONELISTFORMATEMAIL = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink>  |$formfield(Phone1)<br>$formfield(Phone2)  |$formfield(Email) <br> $formfield(Email2)   |Paid: $formfield(DatePaid2008) <br> $formfield(Note); $formfield(LastContact)  |  %TBLEDITICON%  |"


   * Set MEMBERCSVHEADER = "NameLast","NameFirst","Address","CityStateZip","Phone1","Phone2","Email","Email2","Organization","Website","Note","Tags","PositionsHeld","Volunteer Activities","House Party Info"<br/>
   * Set MEMBERCSVFORMAT = "\"$formfield(NameLast)\",\"$formfield(NameFirst)\",\"$formfield(Address)\",\"$formfield(CityStateZip)\",\"$formfield(Phone1)\",\"$formfield(Phone2)\",\"$formfield(Email)\",\"$formfield(Email2)\",\"$formfield(Organization)\",\"$formfield(Website)\",\"$formfield(Note)\",\"$formfield(Tags)\",\"$formfield(PositionsHeld)\",\"$formfield(Volunteer Activities)\",\"$formfield(House Party Info)\"<br/>"



Contacts Database


   * Set CONTACTORGHEADER = |  *Organization*  |  *Address / web / email*  |  *Phone*  |  *Notes*  |  *...*  |

   * Set CONTACTORGFORMAT = "|$formfield(Organization) [[$web.$topic][<nop>]] %ISNEW%  |<noautolink><span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span><br></noautolink> $formfield(Website)  $formfield(Email) $formfield(Email2)   |<noautolink>$formfield(Phone1)<BR>$formfield(Phone2)</noautolink>  |$formfield(Note)  |  %TBLEDITICON%  |"

   * Set CONTACTLISTFORMAT = "   * [[$web.$topic][$formfield(Organization)]] %ISNEW% --  [[$formfield(Website)][Website]] [[mailto:$formfield(Email)][Email]] -- <noautolink>$formfield(Address), $formfield(CityStateZip)</noautolink> -- $formfield(Phone1) -- $formfield(Note)"

   * Set RELATEDTOORGHEADER = ---++ Contacts related to this Organization ([[NewContact][Add]])

   * Set RELATEDTOORGSEARCH = %SEARCH{search="form.name~'*ContactForm*' AND (Organization~'*%TOPIC%*' OR Organization~'*%FORMFIELD{Organization}%*') "
     noheader="on"  nosummary="on" type="query" nosearch="on" 
     format=%CONTACTFORMAT% order="formfield(NameLast)" excludetopic="%TOPIC%"}%
     <h4>Contacts from Secured Database</h4>
     %SEARCH{search="form.name~'*PeopleForm*' AND (Organization~'*%TOPIC%*' OR Organization~'*%FORMFIELD{Organization}%*') " 
     header="$n%MEMBERORGHEADER%"  nosummary="on" type="query" nosearch="on" 
     format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="%TOPIC%"}%


Listserve


   * Set LISTSERVEHEADER = |  *List Title<br>(Name)*  |  *Description*  |  *Project*  |  *Who may subscribe?*  |  *Who May Post*  |  *Info <br> Admin*  |
   * Set LISTSERVEFORMAT = "| [[$topic]]<br>($formfield(ListName))   | $formfield(ListDescription)  |   $formfield(ProjectTopic)  |   $formfield(WhoMayJoin) <br> [[$formfield(SubscribeLink)][Subscribe]]    |   $formfield(WhoMayPost) <br> [[mailto:$formfield(PostEmail)][Post]]    |  [[$formfield(ListInfoLink)][Info]]    [[$formfield(ArchiveLink)][Archive]]   [[$formfield(AdministrateLink)][Admin]]    |"

   * Set LISTSERVELIST = %SEARCH{search="form.name~'*ListServeForm' AND Hidden != 'Yes'" header="%LISTSERVEHEADER%"  nototal="on" type="query" nosearch="on" format=%LISTSERVEFORMAT% order="topic" excludetopic="ListServeTopicTemplate, ListServe,ListServeForm"}%

   * Set KEYWORDTOPICLISTSERVE = %SEARCH{search="form.name~'*ListServeForm' AND (ProjectTopic~'*%BASETOPIC%*' OR ListTags~'*%BASETOPIC%*'" 
     header="$n%LISTSERVEHEADER%"  nototal="on" type="query" nosearch="on" format=%LISTSERVEFORMAT% order="topic" excludetopic="ListServeTopicTemplate, ListServe,ListServeForm"}%

The following to be used in ListServeTopicHeader
   * Set LISTTOPICLISTSERVE = %SEARCH{search="form.name~'*ListServeForm' AND name='%BASETOPIC%' " header="$n%LISTSERVEHEADER%"  nototal="on"  type="query" nosearch="on" format=%LISTSERVEFORMAT% order="topic" excludetopic="ListServeTopicTemplate, ListServe,ListServeForm"}%

The following used in subscription forms
   * Set SELECTLISTSERVES = %SEARCH{search="form.name='ListServeForm' AND (Advertise = 'Yes' OR name='%BASETOPIC%' " nototal="on" type="query" nosearch="on" format="<input type=\"checkbox\" name=\"lists\" value=\"$formfield(ListName)\" $percentIF{\" '%BASETOPIC%'=$'topic' \" then=\"checked\" else=\"\"}$percent><b>[[$topic]]</b> - ($formfield(ListName)) $formfield(ListDescription)<br>" separator="" order="topic" excludetopic="ListServeTopicTemplate, ListServe,ListServeForm"}%


Subscription Blocks

  • Set SUBSCRIBE_COPSMAIN =
    Email: Name: Info

  • Set SUBSCRIBE_COPSMAIN_VERTBAR =
    Email:

    Name:

    Info


Projects


   * Set PROJECTLISTHEADER = |  *Project*  |  *Description*  |  *Parent Project*  |  *Curator*  |  *Status*  |

   * Set PROJECTLISTFORMAT = "| [[$topic][$formfield(ProjectName)]]   | $formfield(ProjectDescription)  |   $formfield(ProjectParents)  |   $formfield(ProjectCurator)  |   $formfield(ProjectStatus)    |"

   * Set CREATEPROJECT = <form action="%SCRIPTURLPATH%/edit%SCRIPTSUFFIX%/%WEB%/">Add Project: Topic Name: <input type="text" name="topic" size="32" /><input type="submit" value="Create" /><input type="hidden" name="templatetopic" value="ProjectTopicTemplate" /><input type="hidden" name="topicparent" value="WebHome" /><input type="hidden" name="topicform" value="ProjectForm" /></form>

   * Set CHILDPROJECTLIST = %SEARCH{web="Common" search="form.name~'*ProjectForm' AND ProjectParents~'*%TOPIC%*'" header="$n|  *Topic*  |  *Description*  |  *Status*  |  *Parents*  |"  nototal="on" type="query" nosearch="on" format="| [[$topic]] %ISNEW%  | $formfield(ProjectDescription)  | $formfield(ProjectStatus)  | $formfield(ProjectParents)  |" order="ProjectName" excludetopic="ProjectTopicTemplate"}%

   * Set RELATEDPROJECTLIST = %SEARCH{web="Common" search="form.name~'*ProjectForm' AND (RelatedKeywords~'*%TOPIC%*' OR ProjectParents~'*%TOPIC%*') " header="$n|  *Topic*  |  *Description*  |  *Status*  |  *Parents*  |"  nototal="on" type="query" nosearch="on" format="| [[$topic]] %ISNEW%  | $formfield(ProjectDescription)  | $formfield(ProjectStatus)  | $formfield(ProjectParents)  |" order="ProjectName" excludetopic="ProjectTopicTemplate"}%

   * Set MAINPROJECTLIST = %INCLUDE{Common.MainProjectList}%
% SEARCH{web="Common" search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot' AND (ProjectType='IssueOversight') " 
  nonoise="on" type="query" format="   * [[$topic]]" 
  order="ProjectName" excludetopic="ProjectTopicTemplate"}%



   * Set PROJECTSIMPLELIST2LEVEL = %SEARCH{web="Common" 
   search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot')" 
   nonoise="on" type="query" 
   format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $n$percntSEARCH{web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND (ProjectStatus='Active' OR ProjectStatus='Hot')\" nonoise=\"on\" type=\"query\" format=\"   * &nbsp;&nbsp; [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]]\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"off\"}$percnt" 
   order="ProjectName" 
   excludetopic="ProjectTopicTemplate" 
   separator=""}%
   
   * Set PROJECTSIMPLELIST2LEVELISSUES = %SEARCH{web="Common" 
   search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot') AND ProjectType='IssueOversight' " 
   nonoise="on" type="query" 
   format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $n$percntSEARCH{web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND (ProjectStatus='Active' OR ProjectStatus='Hot')\" nonoise=\"on\" type=\"query\" format=\"   * &nbsp;&nbsp; [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]]\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"off\"}$percnt" 
   order="ProjectName" 
   excludetopic="ProjectTopicTemplate" 
   separator=""}%

   * Set PROJECTSIMPLELIST2LEVELGOVT = %SEARCH{web="Common" 
   search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot') AND ProjectType='GovtOversight' " 
   nonoise="on" type="query" 
   format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $n$percntSEARCH{web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND (ProjectStatus='Active' OR ProjectStatus='Hot')\" nonoise=\"on\" type=\"query\" format=\"   * &nbsp;&nbsp; [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]]\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"off\"}$percnt" 
   order="ProjectName" 
   excludetopic="ProjectTopicTemplate" 
   separator=""}%

   * Set PROJECTSIMPLELIST2LEVELINFRASTRUCTURE = %SEARCH{web="Common" 
   search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot') AND ProjectType='Infrastructure Project' " 
   nonoise="on" type="query" 
   format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $n$percntSEARCH{web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND (ProjectStatus='Active' OR ProjectStatus='Hot')\" nonoise=\"on\" type=\"query\" format=\"   * &nbsp;&nbsp; [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]]\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"off\"}$percnt" 
   order="ProjectName" 
   excludetopic="ProjectTopicTemplate" 
   separator=""}%


   * Set PROJECTLISTGROUPED = %INCLUDE{Common.ProjectListGrouped}%
 
   * Set PROJECTKEYWORDS = %SEARCH{web="Common" search="form.name~'*ProjectForm' " nonoise="on" type="query" format="$topic " order="ProjectName" excludetopic="ProjectTopicTemplate"}%

% SEARCH{
      header="$n<b> [[Common.InfrastructureProjects][Infrastructure]] </b> - Projects related to how we manage projects and support information.$n" 
      web="Common" search="form.name~'*ProjectForm' AND ProjectParents='' AND ProjectType='InfrastructureProject' "  
      type="query" nosearch="on" nototal="on" order="ProjectName" excludetopic="ProjectTopicTemplate" separator=""
      format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $percntISNEW% -- $formfield(ProjectDescription)$n$percntSEARCH{
         web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND ProjectType='InfrastructureProject' \" 
         type=\"query\"  nosearch=\"on\" nototal=\"on\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\" nofinalnewline=\"on\"
         format=\"      * [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]] $dollarpercntISNEW% -- $dollarformfield(ProjectDescription)\"  }$percnt"
    }%%SEARCH{ 
      header="$n<b> Common.GovtOversight </b> - Choose a governmental body and monitor it.$n"
      web="Common" search="form.name~'*ProjectForm' AND ProjectParents='' AND ProjectType='GovtOversight' " 
      type="query" nosearch="on" nototal="on" order="ProjectName" excludetopic="ProjectTopicTemplate"  separator=""
      format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $percntISNEW% -- $formfield(ProjectDescription)$n$percntSEARCH{
         web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND ProjectType='GovtOversight'\" 
         type=\"query\" nosearch=\"on\" nototal=\"on\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"on\"
         format=\"      * [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]] $dollarpercntISNEW% -- $dollarformfield(ProjectDescription)\"  }$percnt"
    }%%SEARCH{
      header="$n<b> Common.IssueOversight </b> - When important issues arise, we track them as projects.$n"
      web="Common" search="form.name~'*ProjectForm' AND ProjectParents='' AND ProjectType='IssueOversight' " 
      type="query" nosearch="on" nototal="on" order="ProjectName" excludetopic="ProjectTopicTemplate"  separator=""
      format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $percntISNEW% -- $formfield(ProjectDescription)$n$percntSEARCH{
         web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*'  AND ProjectType='IssueOversight'\" 
         type=\"query\"  nosearch=\"on\" nototal=\"on\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"on\"
         format=\"      * [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]] $dollarpercntISNEW% -- $dollarformfield(ProjectDescription)\"  }$percnt" }%

List Contacts with %TOPIC%Core (sans Con) included in Keywords

   * Set TOPIC_CORE_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%Core*' AND NOT Keywords~'*%TOPIC%CoreCon*' " 
            header="$n%CONTACTORGHEADER%" type="query" %NONOISEWHDR% 
            format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%
   * Set TOPIC_LINK_LIST = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%*' AND NOT (Keywords~'*%TOPIC%CoreCon*' OR Keywords~'*%TOPIC%Con*' ) " 
            noheader="on" type="query" %NONOISEWHDR% 
            format=%CONTACTLISTFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Members with %TOPIC%Core (sans Con) included in Tags

   * Set TOPIC_CORE_MEMBERS = %SEARCH{ web="People" search="form.name~'*PeopleForm' AND Tags~'*%TOPIC%Core*' AND NOT Tags~'*%TOPIC%CoreCon*' " 
            header="$n%MEMBERORGHEADER%" type="query" %NONOISEWHDR% 
            format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="MembersTopicTemplate"}%

List Opponent Contacts with %TOPIC%CoreCon included in Keywords

   * Set TOPIC_CORE_CON_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%CoreCon*' " 
             header="$n%CONTACTORGHEADER%" type="query" %NONOISEWHDR% 
             format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Opponent Members with %TOPIC%CoreCon included in Tags

   * Set TOPIC_CORE_CON_MEMBERS = %SEARCH{search="form.name~'*PeopleForm' AND Tags~'*%TOPIC%CoreCon*' " 
            header="$n%MEMBERORGHEADER%" type="query" %NONOISEWHDR% web="People"
            format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="MembersTopicTemplate"}%

List Allied Contacts with %TOPIC% (sans Con or Core or Decider or Neutral) included in Keywords

   * Set TOPIC_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%*' AND NOT (Keywords~'*%TOPIC%Core*'  OR Keywords~'*%TOPIC%Con*' OR Keywords~'*%TOPIC%Decider*' OR Keywords~'*%TOPIC%Neutral*')  " 
           header="$n%CONTACTORGHEADER%" type="query" %NONOISEWHDR% web="Common"
           format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Opponent Contacts with %TOPIC%Con included in Keywords

   * Set TOPIC_CON_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%Con*' " 
            header="$n%CONTACTORGHEADER%"  type="query" %NONOISEWHDR% web="People"
             format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Stakeholder Members with %TOPIC% (sans Con or Core or Decider or Neutral) included in Tags

   * Set TOPIC_MEMBERS = %SEARCH{search="form.name~'*PeopleForm' AND Tags~'*%TOPIC%*' AND NOT (Tags~'*%TOPIC%Core*' OR Tags~'*%TOPIC%Con*' OR Tags~'*%TOPIC%Decider*' OR Tags~'*%TOPIC%Neutral*') " 
            header="$n%MEMBERORGHEADER%"   type="query" %NONOISEWHDR% web="People"
            format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="MembersTopicTemplate"}%

List Opponent Followers - Citizens and activists who support and follow the opponents. %TOPIC%Con included in Tags

   * Set TOPIC_CON_MEMBERS = %SEARCH{search="form.name~'*PeopleForm' AND Tags~'*%TOPIC%Con*' " 
            header="$n%MEMBERORGHEADER%"  type="query" %NONOISEWHDR% web="People"
            format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="MembersTopicTemplate"}%

List Governmental Decision Makers: Contacts with %TOPIC%Decider included in Keywords

   * Set TOPIC_DECIDER_CONTACTS = %SEARCH{search="form.name~'ContactForm' AND Keywords~'%TOPIC%Decider' " 
            header="$n%CONTACTORGHEADER%"  type="query" %NONOISEWHDR% 
            format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Primary "Neutral" News Media Contacts

   * Set TOPIC_NEUTRAL_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%Neutral*' " 
            header="$n%CONTACTORGHEADER%"   type="query" %NONOISEWHDR% 
            format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

Summary of all contacts related to this project.

   * Set TOPIC_RELATED_CONTACTS =
    <p>[[Common.NewContact][Add Organization]] | [[People.NewMember][Add Person (secured)]] 
    <h3>Core Proponents</h3>%TOPIC_CORE_CONTACTS%
    <p>%TOPIC_CORE_MEMBERS%
    <h3>Other Proponents</h3>%TOPIC_CONTACTS%
    <p>%TOPIC_MEMBERS%
    <h3>Decision Makers</h3>%TOPIC_DECIDER_CONTACTS%
    <h3>Primary "Neutral" and News Media Contacts</h3>%TOPIC_NEUTRAL_CONTACTS%
    <h3>Core Opponents</h3>%TOPIC_CORE_CON_CONTACTS%
    <p>%TOPIC_CORE_CON_MEMBERS%
    <h3>Other Opponents</h3>%TOPIC_CON_CONTACTS%
    <p>%TOPIC_CON_MEMBERS%


Here is the dynamic MAINPROJECTLIST. This takes too many CPU cycles to do it all the time without caching.


Here is the dynamic PROJECTLISTGROUPED. This takes too many CPU cycles to do it all the time without caching.

Infrastructure - Projects related to how we manage projects and support information.
  • COPs Program -- Parent project to all COPs projects.
    • COPs Resources -- Compilation of resources and related information useful to COPs participants.
    • Project Anatomy -- A "project of projects" -- how we manage and organize COPs projects on this site.
Govt Oversight - Choose a governmental body and monitor it.
  • Grossmont Healthcare Board -- After being cited by the California Medical review board, the community became aware that the District Board was unaware of these events, despite a clear expectation by the community that they stay perform hospital oversight.
  • Grossmont Union High School District -- Oppose the sad story of a high school district taken over by religious radicals and left in disarray. Now, they've done it again.
Issue Oversight - When important issues arise, we track them as projects.
  • Border Security -- This topic includes discussion of the border fence, and the larger issue of border security and immigration reform.
  • Election Integrity -- Comprises all election integrity issues
    • Manual Tally Issues -- 1% Manual Tally is required for certification of elections but are either not completed or are insufficient to report vote-substitution errors. SERIOUS PROBLEMS DETECTED IN SAN DIEGO!
    • Open Ballot Initiative -- Describes a method of election canvass processing that uses high-speed electronic equipment but is not subject to hacking vulnerabilities
    • Scanner Tape Review -- Our attempt to audit the elections process in San DIego County regarding Diebold scanner tapes.
  • Energy Policy -- Consideration of various approaches to solving fossil fuel addiction.
  • Local Politics -- East County Politics that is not covered by another project
  • Private Mercenaries -- Considers the rise of private mercenary firms and warfare training camps.
    • Blackwater Otay -- Opposition to private mercenary training center in Otay Mesa, San Diego
    • Blackwater Worldwide -- Considers the entire family of companies related to Erik Prince, the founder of Blackwater Lodge Training Center.
    • Covert Canyon -- A shooting range training area in East San Diego County, off Japatul Valley Rd and operated by Marc Halcon.
    • Procinctu Group -- Opposition to development of "The Ranch", a mercenary training center in Riverside County
    • Wind Zero -- Mercenary-style trainging camp just east of San Diego County in Ocotillo/Nomirage.

I Attachment Action Size Date Who Comment
AmazonSmile.JPGJPG AmazonSmile.JPG manage 28 K 27 Sep 2018 - 21:13 Raymond Lutz Amazon Smile affiliate image
Topic revision: r29 - 08 Apr 2024, RaymondLutz
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Cops? Send feedback