1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir<helpdocument version="1.0"> 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir<!-- 5*cdf0e10cSrcweir*********************************************************************** 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 12*cdf0e10cSrcweir * 13*cdf0e10cSrcweir * This file is part of OpenOffice.org. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 16*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 17*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 18*cdf0e10cSrcweir * 19*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 20*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 21*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 22*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 23*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 24*cdf0e10cSrcweir * 25*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 26*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 27*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 28*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 29*cdf0e10cSrcweir * 30*cdf0e10cSrcweir ************************************************************************ 31*cdf0e10cSrcweir --> 32*cdf0e10cSrcweir 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir<meta> 35*cdf0e10cSrcweir <topic id="textswriterguidefields_userdataxml" indexer="include" status="PUBLISH"> 36*cdf0e10cSrcweir <title xml-lang="en-US" id="tit">Querying User Data in Fields or Conditions</title> 37*cdf0e10cSrcweir <filename>/text/swriter/guide/fields_userdata.xhp</filename> 38*cdf0e10cSrcweir </topic> 39*cdf0e10cSrcweir </meta> 40*cdf0e10cSrcweir <body> 41*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3153398"><bookmark_value>fields; user data</bookmark_value> 42*cdf0e10cSrcweir <bookmark_value>user data; querying</bookmark_value> 43*cdf0e10cSrcweir <bookmark_value>conditions; user data fields</bookmark_value> 44*cdf0e10cSrcweir <bookmark_value>hiding;text, from specific users</bookmark_value> 45*cdf0e10cSrcweir <bookmark_value>text; hiding from specific users, with conditions</bookmark_value> 46*cdf0e10cSrcweir <bookmark_value>user variables in conditions/fields</bookmark_value> 47*cdf0e10cSrcweir</bookmark> 48*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153398" role="heading" level="1" l10n="U" 49*cdf0e10cSrcweir oldref="59"><variable id="fields_userdata"><link href="text/swriter/guide/fields_userdata.xhp" name="Querying User Data in Fields or Conditions">Querying User Data in Fields or Conditions</link> 50*cdf0e10cSrcweir</variable></paragraph> 51*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154239" role="paragraph" l10n="U" oldref="60">You can access and compare some user data from conditions or fields. For example, you can compare user data with the following operators:</paragraph> 52*cdf0e10cSrcweir <table id="tbl_id3154255"> 53*cdf0e10cSrcweir <tablerow> 54*cdf0e10cSrcweir <tablecell> 55*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155889" role="tablehead" l10n="U" oldref="94">Operator</paragraph> 56*cdf0e10cSrcweir </tablecell> 57*cdf0e10cSrcweir <tablecell> 58*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147110" role="tablehead" l10n="U" oldref="95">Meaning</paragraph> 59*cdf0e10cSrcweir </tablecell> 60*cdf0e10cSrcweir </tablerow> 61*cdf0e10cSrcweir <tablerow> 62*cdf0e10cSrcweir <tablecell> 63*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150508" role="tablecontent" l10n="U" oldref="96">== or EQ</paragraph> 64*cdf0e10cSrcweir </tablecell> 65*cdf0e10cSrcweir <tablecell> 66*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150531" role="tablecontent" l10n="U" oldref="97">equals</paragraph> 67*cdf0e10cSrcweir </tablecell> 68*cdf0e10cSrcweir </tablerow> 69*cdf0e10cSrcweir <tablerow> 70*cdf0e10cSrcweir <tablecell> 71*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150725" role="tablecontent" l10n="U" oldref="98">!= or NEQ</paragraph> 72*cdf0e10cSrcweir </tablecell> 73*cdf0e10cSrcweir <tablecell> 74*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150748" role="tablecontent" l10n="U" oldref="99">is not equal to</paragraph> 75*cdf0e10cSrcweir </tablecell> 76*cdf0e10cSrcweir </tablerow> 77*cdf0e10cSrcweir </table> 78*cdf0e10cSrcweir 79*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153167" role="paragraph" l10n="U" oldref="101">If you want, you can use a condition to hide specific text in your document from a specific user.</paragraph> 80*cdf0e10cSrcweir <list type="ordered"> 81*cdf0e10cSrcweir <listitem> 82*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153190" role="listitem" l10n="U" oldref="102">Select the text in the document that you want to hide.</paragraph> 83*cdf0e10cSrcweir </listitem> 84*cdf0e10cSrcweir <listitem> 85*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145273" role="listitem" l10n="U" oldref="103">Choose <emph>Insert - Section</emph>.</paragraph> 86*cdf0e10cSrcweir </listitem> 87*cdf0e10cSrcweir <listitem> 88*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145297" role="listitem" l10n="U" oldref="104">In the <item type="menuitem">Hide</item> 89*cdf0e10cSrcweir <emph/>area, select the <item type="menuitem">Hide</item> check box.</paragraph> 90*cdf0e10cSrcweir </listitem> 91*cdf0e10cSrcweir <listitem> 92*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155533" role="listitem" l10n="U" oldref="105">In the <emph>With Condition</emph> box, type <emph>user_lastname == "Doe"</emph>, where "Doe" is the last name of the user that you want to hide the text from. </paragraph> 93*cdf0e10cSrcweir </listitem> 94*cdf0e10cSrcweir <listitem> 95*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155573" role="listitem" l10n="U" oldref="107">Click <emph>Insert</emph> and then save the document.</paragraph> 96*cdf0e10cSrcweir </listitem> 97*cdf0e10cSrcweir </list> 98*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147760" role="note" l10n="U" oldref="108">The name of the hidden section can still be seen in the Navigator.</paragraph> 99*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147777" role="paragraph" l10n="U" oldref="61">The following table is a list of the user variables that you can access when defining a condition or a field:</paragraph> 100*cdf0e10cSrcweir <table id="tbl_id3147793"> 101*cdf0e10cSrcweir <tablerow> 102*cdf0e10cSrcweir <tablecell> 103*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147819" role="tablehead" l10n="U" oldref="62">User variables</paragraph> 104*cdf0e10cSrcweir </tablecell> 105*cdf0e10cSrcweir <tablecell> 106*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147218" role="tablehead" l10n="U" oldref="63">Meaning</paragraph> 107*cdf0e10cSrcweir </tablecell> 108*cdf0e10cSrcweir </tablerow> 109*cdf0e10cSrcweir <tablerow> 110*cdf0e10cSrcweir <tablecell> 111*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147245" role="code" l10n="U" oldref="64">user_firstname</paragraph> 112*cdf0e10cSrcweir </tablecell> 113*cdf0e10cSrcweir <tablecell> 114*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147268" role="paragraph" l10n="U" oldref="65">First name</paragraph> 115*cdf0e10cSrcweir </tablecell> 116*cdf0e10cSrcweir </tablerow> 117*cdf0e10cSrcweir <tablerow> 118*cdf0e10cSrcweir <tablecell> 119*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145592" role="code" l10n="U" oldref="66">user_lastname</paragraph> 120*cdf0e10cSrcweir </tablecell> 121*cdf0e10cSrcweir <tablecell> 122*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145615" role="paragraph" l10n="U" oldref="67">Last name</paragraph> 123*cdf0e10cSrcweir </tablecell> 124*cdf0e10cSrcweir </tablerow> 125*cdf0e10cSrcweir <tablerow> 126*cdf0e10cSrcweir <tablecell> 127*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145642" role="code" l10n="U" oldref="68">user_initials</paragraph> 128*cdf0e10cSrcweir </tablecell> 129*cdf0e10cSrcweir <tablecell> 130*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145666" role="paragraph" l10n="U" oldref="69">Initials</paragraph> 131*cdf0e10cSrcweir </tablecell> 132*cdf0e10cSrcweir </tablerow> 133*cdf0e10cSrcweir <tablerow> 134*cdf0e10cSrcweir <tablecell> 135*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151200" role="code" l10n="U" oldref="70">user_company</paragraph> 136*cdf0e10cSrcweir </tablecell> 137*cdf0e10cSrcweir <tablecell> 138*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151223" role="paragraph" l10n="U" oldref="71">Company</paragraph> 139*cdf0e10cSrcweir </tablecell> 140*cdf0e10cSrcweir </tablerow> 141*cdf0e10cSrcweir <tablerow> 142*cdf0e10cSrcweir <tablecell> 143*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151250" role="code" l10n="U" oldref="72">user_street</paragraph> 144*cdf0e10cSrcweir </tablecell> 145*cdf0e10cSrcweir <tablecell> 146*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3152912" role="paragraph" l10n="U" oldref="73">Street</paragraph> 147*cdf0e10cSrcweir </tablecell> 148*cdf0e10cSrcweir </tablerow> 149*cdf0e10cSrcweir <tablerow> 150*cdf0e10cSrcweir <tablecell> 151*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3152940" role="code" l10n="U" oldref="74">user_country</paragraph> 152*cdf0e10cSrcweir </tablecell> 153*cdf0e10cSrcweir <tablecell> 154*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3152963" role="paragraph" l10n="U" oldref="75">Country</paragraph> 155*cdf0e10cSrcweir </tablecell> 156*cdf0e10cSrcweir </tablerow> 157*cdf0e10cSrcweir <tablerow> 158*cdf0e10cSrcweir <tablecell> 159*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3152990" role="code" l10n="U" oldref="76">user_zipcode</paragraph> 160*cdf0e10cSrcweir </tablecell> 161*cdf0e10cSrcweir <tablecell> 162*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145679" role="paragraph" l10n="U" oldref="77">Zip Code</paragraph> 163*cdf0e10cSrcweir </tablecell> 164*cdf0e10cSrcweir </tablerow> 165*cdf0e10cSrcweir <tablerow> 166*cdf0e10cSrcweir <tablecell> 167*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145706" role="code" l10n="U" oldref="78">user_city</paragraph> 168*cdf0e10cSrcweir </tablecell> 169*cdf0e10cSrcweir <tablecell> 170*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145729" role="paragraph" l10n="U" oldref="79">City</paragraph> 171*cdf0e10cSrcweir </tablecell> 172*cdf0e10cSrcweir </tablerow> 173*cdf0e10cSrcweir <tablerow> 174*cdf0e10cSrcweir <tablecell> 175*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145756" role="code" l10n="U" oldref="80">user_title</paragraph> 176*cdf0e10cSrcweir </tablecell> 177*cdf0e10cSrcweir <tablecell> 178*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145779" role="paragraph" l10n="U" oldref="81">Title</paragraph> 179*cdf0e10cSrcweir </tablecell> 180*cdf0e10cSrcweir </tablerow> 181*cdf0e10cSrcweir <tablerow> 182*cdf0e10cSrcweir <tablecell> 183*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156284" role="code" l10n="U" oldref="82">user_position</paragraph> 184*cdf0e10cSrcweir </tablecell> 185*cdf0e10cSrcweir <tablecell> 186*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156307" role="paragraph" l10n="U" oldref="83">Position</paragraph> 187*cdf0e10cSrcweir </tablecell> 188*cdf0e10cSrcweir </tablerow> 189*cdf0e10cSrcweir <tablerow> 190*cdf0e10cSrcweir <tablecell> 191*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156334" role="code" l10n="U" oldref="84">user_tel_work</paragraph> 192*cdf0e10cSrcweir </tablecell> 193*cdf0e10cSrcweir <tablecell> 194*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156357" role="paragraph" l10n="U" oldref="85">Business telephone number</paragraph> 195*cdf0e10cSrcweir </tablecell> 196*cdf0e10cSrcweir </tablerow> 197*cdf0e10cSrcweir <tablerow> 198*cdf0e10cSrcweir <tablecell> 199*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156384" role="code" l10n="U" oldref="86">user_tel_home</paragraph> 200*cdf0e10cSrcweir </tablecell> 201*cdf0e10cSrcweir <tablecell> 202*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149728" role="paragraph" l10n="U" oldref="87">Home telephone number</paragraph> 203*cdf0e10cSrcweir </tablecell> 204*cdf0e10cSrcweir </tablerow> 205*cdf0e10cSrcweir <tablerow> 206*cdf0e10cSrcweir <tablecell> 207*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149756" role="code" l10n="U" oldref="88">user_fax</paragraph> 208*cdf0e10cSrcweir </tablecell> 209*cdf0e10cSrcweir <tablecell> 210*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149778" role="paragraph" l10n="U" oldref="89">Fax number</paragraph> 211*cdf0e10cSrcweir </tablecell> 212*cdf0e10cSrcweir </tablerow> 213*cdf0e10cSrcweir <tablerow> 214*cdf0e10cSrcweir <tablecell> 215*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149806" role="code" l10n="U" oldref="90">user_email</paragraph> 216*cdf0e10cSrcweir </tablecell> 217*cdf0e10cSrcweir <tablecell> 218*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147294" role="paragraph" l10n="U" oldref="91">E-mail address</paragraph> 219*cdf0e10cSrcweir </tablecell> 220*cdf0e10cSrcweir </tablerow> 221*cdf0e10cSrcweir <tablerow> 222*cdf0e10cSrcweir <tablecell> 223*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147321" role="code" l10n="U" oldref="92">user_state</paragraph> 224*cdf0e10cSrcweir </tablecell> 225*cdf0e10cSrcweir <tablecell> 226*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147344" role="paragraph" l10n="U" oldref="93">State</paragraph> 227*cdf0e10cSrcweir </tablecell> 228*cdf0e10cSrcweir </tablerow> 229*cdf0e10cSrcweir </table> 230*cdf0e10cSrcweir 231*cdf0e10cSrcweir <section id="relatedtopics"> 232*cdf0e10cSrcweir <embed href="text/swriter/guide/fields.xhp#fields"/> 233*cdf0e10cSrcweir <embed href="text/swriter/guide/conditional_text.xhp#conditional_text"/> 234*cdf0e10cSrcweir <embed href="text/swriter/guide/hidden_text.xhp#hidden_text"/> 235*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147392" role="paragraph" l10n="C"><link href="text/swriter/02/14020000.xhp" name="List of operators">List of operators</link></paragraph> 236*cdf0e10cSrcweir </section> 237*cdf0e10cSrcweir </body> 238*cdf0e10cSrcweir</helpdocument>