I am trying to search for documents with a certain field that contain any of a possible ~2000 values.I have an extremely large query generated automatically which I’ve ensured is less than 32K.
When I copy/paste the query into the Notes designer as a selection formula for the test view, the query is parsed fine. When I open the test view in the Notes client - it seems to work fine.
However, when I execute Database.search, I get:
Notes error: Formula Error
Does anyone have any suggestions how to make this work?
Are there other restrictions on queries that could cause this error (besides the apparent 32K limit)?
Thanks,
Chuck
P.S. For the record, here is my query:
VaultusTemp_Person_Contact_ID_Values1 := “Wn000809152111”:“Ro041005094342”:“Jg010513162159”:“Ar000828095829”:“An040422120554”:“940208104136”:“Ar001103104722”:“Mr970211150130”:“Jl051114101440”:“Ra970513145712”:“Br030211172301”:“Ce040426181851”:“Jl051024155527”:“Li050624114426”:“Ra970918160744”:“Jg990730172959”:“Sy011018185958”:“931201155244”:“Sr990809152317”:“Je970625081910”:“Sn990303120232”:“Cr040325141914”:“Oo050131152509”:“Jk020118162824”:“Jy030320095824”:“Dn041006132625”:“Ma960514154144”:“Js020311102945”:“Co011203181021”:“Jk020820151202”:“Jk010530121710”:“La040709152523”:“Ar001023101613”:“Ai000318210858”:“Sr000329161852”:“Ma960502103047”:“So980113150916”:“Ls961112114148”:“Ld971103105307”:“Te960213134814”:“Pi961028145156”:“Nr981218115841”:“La040712090701”:“Ss000323171705”:“Li050624081243”:“B.Sh940124102513”:“Jn001016174046”:“Ce950828152901”:“Cr040628114824”:“Ds030506100125”:“An030822092529”:“C.D.940124162104”:“Ml050201132741”:“Mc010126144840”:“Am980922202250”:“Sr021122122734”:“Rn021122162423”:“An040423122434”:“Ci000717114743”:“Jl050124145309”:“Ge040729163814”:“Ss000328135450”:“Jk010813110308”:“ZdPn940803145654”:“Pu960404123716”:“Jg981030115129”:“940225121758”:“Sr060206134552”:“Cn050628124101”:“Ld001020101436”:“An031203112831”:“R.Fe940115140759”:“JkKy940518204131”:“940107123520”:“Ma951023085745”:“Mc991109162746”:“Cr031027120923”:“940325101730”:“An000911171336”:“Sa991017151311”:“Jl050131120759”:“DdRr950313100111”:“Es991006150731”:“Da960115144802”:“Ce960827113045”:“De991020181256”:“An010807181404”:“Sr990414145009”:“Jl041019094636”:“940223172734”:“Jl040910114305”:“Gn970805163738”:“IhSo950313135254”:“Li050606131115”:“So980318093550”:“Cd010705140740”:“Ts040721123227”:“Le980123142758”:“Nr971028122436”:“Bg010905083908”:“Sr020513140439”:“Sr021031133000”:“AnTr940329145109”:“An030402160121”:“D Cr940302103149”:“JmPe940111124011”:“Li050624110102”:“Ma960320093644”:“Ra950820215625”:“NJMA-4AA37G”:“Sr060516163542”:“Sr990506143246”:“M.Mz940614165134”:“Li051024151820”:“Jk030411133508”:“Ps981215103326”:“Ma980803135412”:“Ds011026122938”:“Mn990428163158”:“Jl060626101504”:“CORP7418”:“Ln010213085534”:“JfBy950410102430”:“Jk021115091038”:“R.Fs950116115721”:“940322185622”:“Js021125154702”;
VaultusTemp_Person_Contact_ID_Values2 := “Tz960801111258”:“Ty971114141704”:“Jl040826162920”:“Rn010309151810”:“Es001002111108”:“Kr030905095715”:“Ji050607142401”:“Ar000824093325”:“Ar000824094926”:“Sh960813112606”:“931230124103”:“P.Ge940901161735”:“PkCs950203163049”:“Jh001205142732”:“FIX30”:“Jl040826152005”:“AnLt950105195709”:“NJMA-4A72ZX”:“Jl041206124130”:“Sn980202093608”:“Ls000721143657”:“Sr991025124238”:“Co011129174925”:“Jk021213135946”:“Mr041129202416”:“Jl040910110006”:“Jl060206125932”:“Ml041108132311”:“UK1708”:“Jk020213161609”:“Ps990405130218”:“Cr031222124723”:“Jl041206111504”:“Nr000720165206”:“CORP5149”:“Ms030912194940”:“Ld001206142238”:“UK2079”:“Jl050707122317”:“SeCn940113114523”:“CORP12257”:“PlDo940511131946”:“Cd020531130245”:“Jg020205104839”:“Ld030605082000”:“Es000201142648”:“Sy000724105517”:“Mn010430164622”:“Ma960229164319”:“Js021125161152”:“Jk030606150926”:“At960207143626”:“At981109161703”:“Jl050810121518”:“Ts011129133652”:“Jl060626104201”:“940218132611”:“IkKv940620170046”:“M.Ms950309134450”:“Ka991005112836”:“Gt030130181815”:“Tn970220173208”:“Jk020213160447”:“Ma951205090056”:“Bs960103132449”:“Aa050826104400”:“At050810155550”:“CrSy940401102100”:“Js030127165249”:“Jy010710142947”:“Ld980630130346”:“Jy001101122446”:“Sr050317094200”:“Sk020318110818”:“CORP6325”:“Ar000606112404”:“Sr990519111700”:“Ar000602095030”:“Ar001023102052”:“JlWt940715115340”:“Jk030514170625”:“Sa981001110852”:“Kn961128143453”:“NJMA-4A924W”:“931213134217”:“Bn980525014236”:“Ld010418163453”:“Po060321084740”:“GgRs950313140143”:“Cy051206100452”:“Mt000508140447”:“Mr010201135845”:“Jy000309165108”:“Bl991103104759”:“So960415095638”:“Rn020605173129”:“Jl060208113201”:“Gg001020125314”:“Sn970508142613”:“Cr031023135116”:“De961029114943”:“Jk020821142719”:“CORP7835”:“940322152558”:“NJMA-4CTUZZ”:“Dt991220133552”:“Jk030205143005”:“Li050523164500”:“D.Hy940404105411”:“Sn990720151939”:“KhWx940610111843”:“Ma960322095106”:“FIX37”:“So961204095151”:“Jt980706103421”:“Ls970130145644”:“940321152549”:“Jl051205161630”:“Nn960328122158”:“Pr060612162806”:“EcAu940722142108”:“Mn960913172515”:“Ls971027155916”:“Ma960621124310”:“931028095509”:“MlZk931009181621”:“Tr980108202400”:“Gg001019171733”:“An040423121222”:“931207195155”:“Sr020318103035”;
VaultusTemp_Person_Contact_ID_Values3 := “DnHd940525153101”:“Sr060508165000”:“Ln991005091552”:“Da951128091935”:“CORP6358”:“940217141341”:“Sk010514110128”:“CORP1243”:“De970415093434”:“Tm950901150627”:“Dy980608132012”:“De961022162246”:“Jy030221171050”:“H.Qs950405100621”:“Jt030129150947”:“Mh000927114935”:“Pr950830122040”:“Dy040518202317”:“Co011130184146”:“940308113754”:“CORP4321”:“Ld000420160053”:“Jg950719134034”:“An040422112005”:“Le950927171832”:“Ar001003100637”:“Ld030213104303”:“Ts021126163235”:“Jl051115103222”:“Ls021011143804”:“Sn001206110653”:“Gg001019170751”:“Vd000823165145”:“De970109093515”:“JiMy931009181252”:“Ma990706110521”:“Jy990805133744”:“Jg990730190507”:“Sn951025171153”:“Pr961113144538”:“Ss020614162856”:“PrBs940124082911”:“An030825165718”:“De980604114033”:“BnLe940525140043”:“De971007162719”:“CORP516”:“Sr060508162843”:“Re960523152002”:“Ml050215104236”:“Ld020509093146”:“Jk020821162252”:“NJMA-49ELKB”:“931228152645”:“JnRo950525163136”:“S.Br940512102559”:“Sr000321160925”:“Sr060215134307”:“Kd010628143655”:“Sr020722103352”:“Jl041025092017”:“Ra000328120227”:“W.Pk940606113607”:“SnBr940509164535”:“Jl041019104647”:“Hr010920122220”:“931013203934”:“Jp001227164537”:“La040712093344”:“G.By940124165756”:“JmMr940418153011”:“Ls980218154303”:“JnNt940711095934”:“Jy040316171827”:“Mz990901140950”:“Jk021114100731”:“Jk010530121327”:“931209201318”:“931110091308”:“Le950926172454”:“D&Te940512141054”:“Gg001019163614”:“Jk020415114507”:“Rs000323103930”:“Jk021014134201”:“GePk950405103429”:“An040421152239”:“An040217111949”:“CORP2922”:“At990510134009”:“G.Bn941003141509”:“940308134554”:“Sr030219110232”:“Ld980105143344”:“Vd011011135810”:“MlBs931009180602”:“P.Bt950201113338”:“T.Bn940115143651”:“So970508105837”:“An040421114611”:“D.Kg940816181049”:“HdMz940408164353”:“Jk020509141431”:“Jl040826163611”:“R.On940511103736”:“Jk030224151422”:“Jt030129145919”:“Sn991207125419”:“Ls970728144717”:“Je961231092200”:“Jp010615132258”:“By011207181531”:“Jl060626100056”:“Sy990520125555”:“Nr970922114409”:“Ty991015164049”:“Sr040816162742”:“931208190154”:“CORP3659”:“Ar010309144047”:“An040422103708”:“Dt030403145840”:“Jl041025085822”:“Ma980820175105”:“Sn981112115551”:“Jt030129150149”:“DdGn940124115823”:“Sr001221113150”;
VaultusTemp_Person_Contact_ID_Values4 := “Ls960130160615”:“Jg990816102825”:“L.Ps950411114608”:“T.Lr941205114900”:“Nr001102115238”:“Mf041111163007”:“Se040406105819”:“Sy000313121427”:“Sr060426113033”:“Ml050113110006”:“So971105145344”:“Ar010109164002”:“Pr041209104025”:“Sr991025130213”:“Gn970420111958”:“Jk011005151143”:“An040423114209”:“ByCn950221144732”:“Jt030129150501”:“Jk010629105658”:“Jl051024164841”:“Mn040625112058”:“Jl050209095043”:“Jl050406112259”:“Jr951102160204”:“Se040607102739”:“Dl000104184233”:“MlGg940523162513”:“An040422104522”:“Mf040702120028”:“Jl041028133255”:“Jk020213153356”:“Ma960415170902”:“Ls010830141715”:“De980126090920”:“Sr020808153321”:“Jl051110160248”:“TdEn941202134529”:“Jl041028135844”:“Ml031211124132”:“Sr040825115630”:“CORP12306”:“Sn000515113731”:“UK2223”:“Mi020610084205”:“Li050418121135”:“Jt030115161408”:“CORP865”:“Lg971111123256”:“Jl051110153143”:“Pr011101140840”:“Cr031027114711”:“Nr990311155958”:“Jl041202142013”:“Sn000511093658”:“De970505115810”:“Dy980828103314”:“Ma011129180538”:“Li051019165025”:“Li050624113934”:“No970219102017”:“Ez010502092644”:“Sr060711095859”:“Li050919100815”:“T.E.950510151825”:“Rn980921114309”:“Kd010510111750”:“J.Rn940115133454”:“Js021125133747”:“GnHn950210130824”:“G.Go950223104458”:“Ma960723162625”:“Sn981211093214”:“Ar000815101140”:“Es001012102159”:“Tr980406092210”:“Cd021015105230”:“Ld040318161239”:“CdCr940124181913”:“Mh000119144908”:“Jl000814153430”:“931116181057”:“CORP11167”:“Tm010403183610”:“Ee990824193706”:“Jg980514121710”:“Jy990316101354”:“Cr031118125743”:“Sr060621145856”:“Jl040910115743”:“Jk020920120255”:“Rn980701163812”:“Mg970109172122”:“HyMe940621105539”:“M.Sh940120113816”:“Rn971020094642”:“RdPo940719112115”:“Kr980918163251”:“Sr060601102819”:“Jk030603122807”:“J.Ot950608100339”:“931209133908”:“Sr020813114139”:“Si960906143106”:“Mi021111145018”:“Jl060626095706”:“Jd051006150006”:“Ss031017105324”:“Mr970410092025”:“Sr050407105547”:“Cd001023172150”:“Mn010629134007”:“Bs981002135252”:“Sr991025124750”:“Jk010910150236”:“Ar000606111655”:“Mn960927134118”:“WmFd941115111458”:“Cd020501172632”:“En990611170649”:“WmEs940624171915”:“Gs990930142006”:“Cs050513164252”:“De961022104933”:“Li060113155158”:“Nr990309151855”:“Ty020416102536”;
VaultusTemp_Person_Contact_ID_Values5 := “No970401100727”:“Lg961029153922”:“NJMA-4A3JD6”:“Jy990305161432”:“PlBw940509144349”:“Ge970501112335”:“Bw000620095317”:“JmDe940608154141”:“940126163416”:“Mn030212103729”:“Ji041004162048”:“Ts050721134045”:“An031203113312”:“ZrZl950405093749”:“Sr990414145652”:“L.Sg950222153018”:“Jn010203182459”:“Ag000228120440”:“Jl041019125726”:“Jk020814092758”:“De970122105408”:“Ci990817230323”:“An030708145200”:“940221092910”:“Jl060208103624”:“Ss991104105858”:“TeJi941011171734”:“Sr991101150413”:“Sk040905144428”:“AxOr940404140626”:“Li051109102821”:“NJMA-4A72Z9”:“P.Ri940502142650”:“Li050624092709”:“Jg970225195102”:“De970325092222”:“DdLn950217115501”:“Nr010307094945”:“Ls011211163539”:“An040422124419”:“Ez000831153634”:“Ls971230135550”:“So970723114706”:“Jl001002121328”:“Sr990318143436”:“Aa040621162125”:“Cs050606124136”:“Jl041019145119”:“BeAo950307101910”:“Am990430203307”:“Ld981106120130”:“Jl060208112936”:“An030313114354”:“La040712101827”:“R.Se940124162254”:“Mn040524182435”:“AnFd950105102438”:“Va980323162451”:“NkPs940516142320”:“Jl060621122816”:“Jl050616113951”:“Jl050707121351”:“Vd010301161232”:“Ml051201120444”:“940325095027”:“Li051024160107”:“Sr991108155708”:“O.Ce940115140822”:“Sn000523092611”:“NJMA-49EJUY”:“DdSk950202171427”:“YiMt950309102232”:“So991006184028”:“Ls990623111833”:“Ar000412141908”:“Tr980727140527”:“Dy990528110209”:“Jk021014140246”:“S.Pr940115144513”:“Jg970912121139”:“Ss010213174019”:“Ld980105143527”:“Rn990611134329”:“Sn981211094513”:“Rn010326161948”:“931130151544”:“Jk030224152633”:“Az040604144647”:“An040421113815”:“Jk021204161716”:“Sr991025130725”:“Ld980320104757”:“Sn981208120548”:“Ar001016113538”:“Mg961108121301”:“Jl060306140449”:“Sh970929090359”:“Jk020926125117”:“RdGn940906105741”:“Az040610180810”:“BeEd940513170643”:“Ld971224120925”:“Jk010515140201”:“Jk030224152110”:“940322170509”:“NJMA-4A98N9”:“Sn981102103718”:“Li051024154851”:“Jg020522115118”:“Jl041221111856”:“Cd020514115700”:“Jg960520184820”:“RkBo940125121258”:“Mr990713114238”:“Jl041110123959”:“GdSr941013120605”:“Es010315172513”:“De991007112212”:“Ma050606102335”:“Jl050203114330”:“Jl060208103915”:“NJMA-4A9SE8”:“Ld001020124931”:“So970716130430”:“BOBR-495QKG”:“E.Krn941109133258”:“En990318195643”; VaultusTemp_Person_Contact_ID_Values6 := “931209134158”:“Cm010226214646”:“Ar000912152513”:“Bs970112092915”:“Ls970130151243”:“LySi940404150533”:“Ar000818135702”:“NJMA-49YCSD”:“So951205091553”:“De981006122626”:“An040422104706”:“Cg000914142716”:“Ty020117154837”:“Ls990921162923”:“UK2166”:“Sl010102142154”:“GyCw940131125205”:“Jk030107093023”:“Sr020722104753”:“Jy991012093024”:“Ps980601173831”:“Jt030919152351”:“Ls970912160210”:“Jl060206134619”:“940222194605”:“De961003101606”:“St960920182651”:“Nk020321102624”:“Es001012102938”:“De980618092628”:“Sn980421060050”:“Ma960717101747”:“Ld990319093709”:“940208093652”:“Jl041206114939”:“At950922134030”:“Eo000524154106”:“F.La940414154019”:“Am990520152406”:“Sr991108123950”:“Sn000202132041”:“Sr000301113159”:“L.Co940804151136”:“L.Ve950608100810”:“Jt030129151943”:“RhLa940624160605”:“Sn980814163355”:“Ma950727164912”:“NJMA-4CTMPW”:“Es991006161652”:“Ld000718101722”:“CORP3504”:“Py000509181454”:“ByBn950404180506”:“Ld000825094542”:“M.Ro940115145324”:“NJMA-4AA4LF”:“NJMA-4CTTQC”:“F.Ys950417143131”:“Ld011115100503”:“Sr060505151641”:“940107112207”:“Sr060621152521”:“MkSn940607152451”:“Jk030514171254”:“Jl050311164455”:“De980326163554”:“Dt000120173327”:“Sr050404175912”:“Jk020822160533”:“Ji030304175114”:“Li050617104339”:“940325183739”:“Le970224095740”:“Li060103104404”:“So981110192528”:“Jk021014164611”:“Ml060509141838”:“940103154819”:“Jt030129123037”:“931209134813”:“No960418170524”:“Kd010626170326”:“Ts031218165856”:“Sr041118150039”:“T.Mn940801144947”:“An980324131118”:“Jg990929174903”:“GnEs940125094314”:“Jk030331115146”:“Ts060314132939”:“Sn990303120153”:“Jt030129152243”:“Js010328152246”:“En990318200417”:“Pa000609182058”:“Li051202145252”:“931229133429”:“931115165001”:“Jk020822164602”:“Ty971105100833”:“Ps970718191555”:“An010702114208”:“Ls980217120632”:“Tn980105164156”:“NJMA-4A3K2J”:“NJMA-4AA6K8”:“R.Ke940401111143”:“Jg020212120438”:"Sn0006191
30029":“Jl041015160237”:“Jd010319101428”:“Ts030422153058”:“Pr060706104911”:“E.Gr950112174111”:“940222151937”:“Ls980908152258”:“Br960709121637”:“JnRd950216113533”:“Dn031110100746”:“Sh970513104353”:“940323145618”:“Ld961015121817”:“Ld960627171843”:“Dn990315175635”:“T.Nn940701130518”:“Lg960705115736”:“Ld980810123217”:“Jg950721190844”; VaultusTemp_Person_Contact_ID_Values7 := “940222093157”:“LnHo950303174017”:“JnTt940408094855”:“Gt030130182004”:“Br970813115833”:“Jy980824100614”:“Jl041101112130”:“940222094749”:“Gg001108174015”:“Jl050810121219”:“An020617094743”:“So971105145528”:“Ma960621102808”:“Sr060308104303”:“Ka991005115132”:“Sr060511133918”:“ThCe950103141508”:“Bn960910121114”:“Mc990928110912”:“940128091423”:“Sr060612144052”:“Ee970415111317”:“Ty970516142627”:“Pi961028145404”:“940106114654”:“Sr040122114133”:“Jk010719101309”:“JsCd941202144742”:“Sr060602144642”:“Jl060626101213”:“Re021219143956”:“Jl041206124618”:“Ld960712161511”:“Jd000630113505”:“Jl041015161926”:“Vo971126175207”:“Ld010102163807”:“Jy030320103250”:“Ml040614122220”:“Ma960402112119”:“JhNn941011131947”:“Sa990202112654”:“Ma950710162723”:“Bs970424140029”:“CORP7825”:“931228171043”:“931208195509”:“Ar001011135246”:“Li050624105008”:“Ls960116155440”:“Jl050311141357”:“De980115120959”:“Jk021014165233”:“En990401132314”:“J.Bi950522161138”:“Ld980325100629”:“Ag020117094837”:“Re020523161848”:“Sr010613153710”:“Hr010920155003”:“Jy020725144325”:“Jk030512122416”:“Sa990924205228”:“Hn950525092529”:“Ld030326090223”:“RdEr950113104422”:“E.Lt940111211910”:“940328095442”:“Jk020822164423”:“So980413162451”:“Sn990602141315”:“Jk020822162241”:“Sr991110164243”:“Ts050523093613”:“Sn960429145452”:“An031203110613”:“GyMr940401131342”:“SlAz950615120519”:“Mn030724142817”:“Jy010430145537”:“Ma950710164508”:“Jl050209094755”:“Ar001204083458”:“No951026100935”:“Nh060508145820”:“GoTi941129100822”:“Nn960322131730”:“Es000126103144”:“Jl060621121356”:“P.Cy941026150311”:“Jp030505174958”:“C.Ke940124160218”:“An020916151814”:“Ss991104130807”:“J.Mn940421171205”:“Ld990419111946”:“Gz010529144350”:“ArEd950628093241”:“Ar000815101021”:“UK2337”:“Jy971201100847”:“CORP12256”:“CORP6164”:“Jg990413180857”:“Bn041129125808”:“A.W.940121135003”:“Ld001010122638”:“Jl050311164703”:“P Cn950113104353”:“Re991012223515”:“Sy990308125850”:“Sr990616104616”:“An960222100622”:“Sr060621152014”:“DaCa940330163708”:“Mg961028121001”:“BdBm950130153456”:“Re970123130409”:“Jl050720122348”:“Li050721120542”:“Cr981110093107”:“Ty980922100018”:“Jl050311141822”:“Mr010403102911”:“Ma980805104106”:“Jt020812190803”:“940322102434”:“Es980310105745”; VaultusTemp_Person_Contact_ID_Values8 := “Ls970129151303”:“CsGo950517100958”:“Sn990104111718”:“Jk020510163101”:“Li050624101001”:“Jk020424130609”:“Jy961022094907”:“Tm950809133738”:“Ar001011102807”:“940303114840”:“Gg001030173403”:“Jl051024171445”:“Ma951023085631”:“Si970627164748”:“Tn060228175852”:“De961022105208”:“M.Mn940622105129”:“NJMA-49EJMC”:“Ld951219155755”:“Az040714162702”:“A.Ks940502143126”:“Sr990804143645”:“Ar000801120043”:“Ar000824154245”:“RdDn940714154034”:“Ma960325112207”:“UK1794”:“Mh020730120434”:“Ld991111174544”:“MlSt950313135435”:“Sr011206091237”:“Ls970129161134”:“Kd960621103753”:“Rn990803111051”:“Dt991011125723”:“Sr060427114627”:“Gn990311150824”:“Dt000615151723”:“Sg981013152620”:“FIX42”:“Rn000515170501”:“An040423120718”:“Cr040628113518”:“Lg970324104951”:“Sy990429164646”:“Gn970611131741”:“Jk030811130256”:“Jk030714121233”:“So950725110104”:“Ys981120005741”:“Jk030331123048”:“RrPs940124155153”:“Jg981105190204”:“940104135843”:“Jg981030115213”:“931216162439”:“SeFr940708090435”:“Sn981125114337”:“Jy020828155035”:“Es990604152031”:“De961029152231”:“Li050624080804”:“Jl060626085714”:“Sr060621150030”:“Sr060621145641”:“Jl050628142150”:“Cr040628113005”:“940322141753”:“So980928164915”:“Ty020903173214”:“NJMA-4AAABF”:“Co011129180652”:“931208154602”:“Co011130182235”:“Ar000913104008”:“Ma011129180955”:“Rn990818131925”:“Jl050323090400”:“Rk991228185620”:“SnWm941121165435”:“Cr040628120351”:“RhUn941208105116”:“940308114022”:“Rs980706122934”:“Jl060119161848”:“Sr060621151512”:“Ln000503114002”:“SnCy940509170522”:“Ps980701150937”:"93120915
0205":“Js060316094633”:“Sr060619110602”:“Bn991126133406”:“Nr020403102813”:“Nr040407155814”:“Ah980814131807”:“931228135456”:“EcSy950503162100”:“De970618143936”:“Le950916143748”:“Ls970129154452”:“Jt040310152652”:“BlAr940811154237”:“JnNl940526121528”:“De980323145143”:“Jk030306153757”:“Jl050616114257”:“De970618161728”:“An960429114508”:“RdBr950320165354”:“Sr020801163859”:“Jl060208111433”:“De970402102558”:“940316160608”:“Sn950717125008”:“Nr991031104955”:“Js021125154738”:“Ar000913103459”:“Ag020321101757”:“Jk020801105755”:“Jk021014165851”:“Ts030514095525”:“Ld960626151340”:“Sn000121180833”:“Li050624082621”:“Js951018103126”:“So961119095109”:“931014135531”; VaultusTemp_Person_Contact_ID_Values9 := “Jk020620114005”:“Sr060505162139”:“UK1597”:“Ek030410161139”:“Jr980904102608”:“Jk010904114928”:“Ar001023095337”:“Ts011129122905”:“Jh001009085033”:“931119161700”:“Sr020626173210”:“Br970611142426”:“Ar000913104310”:“W.Bn940208093525”:“Ok001212140950”:“Nn960509200917”:“De970924132350”:“Nr010307100214”:“GnEs940103182318”:“Sy960304182811”:“R.Ce940810153935”:“So960509155202”:“Es980811100548”:“Sr050525124202”:“Sy000112132242”:“Jk021014162803”:“Sn000420093650”:“940222094305”:“Sy000306171335”:“Sn980914161350”:“NJMA-4AA7N6”:“Ln040114084851”:“Ce060404105141”:“931028165240”:“Jk020118163251”:“Ar001026110814”:“Sn980318154222”:“Jk010611152526”:“Gy000829095246”:“Hr010920153217”:“Sr060505140407”:“CORP2028”:“CORP4156”:“RyBm940421164448”:“DnMd950427185857”:“931117123900”:“Ma980803123352”:“Ld961112121640”:“Ji041028160422”:“Jk020821142957”:“Jk030331121439”:“NJMA-4A9EJT”:“Cr031008131621”:“Sr060629125354”:“CORP7572”:“Jk020822101412”:“Le971103103151”:“Dr970827185150”:“Ar000727120827”:“Jk030306154407”:“DdHt941114130417”:“Hl971009232620”:“Es990729103625”:“Ls990517111908”:“940228160844”:“An031203115706”:“T.Kn950403103041”:“Ld981124132322”:“Cr040301120334”:“940325125802”:“Cr031024114427”:“Bdkg950418090251”:“Jy001115141938”:“Sr000511164206”:“So970115100626”:“JhMh940928185227”:“940316155405”:“Az040610180813”:“Mr970908151701”:“940127203949”:“Ld040305124302”:“Sr060621151812”:“W.Bn940125154737”:“Cr031031105247”:“Ds011214104303”:“So960320174342”:“NJMA-4A9BYL”:“Mg971010181613”:“Mn010716121313”:“940104164447”:“Sr000608130516”:“Ld010712162147”:“FIX17”:“Ar001006154038”:“Ld980220112123”:“Ji040204161633”:“Cs050525125608”:“Ts030918142734”:“So960321150717”:“InFn940407161641”:“D.Lg940712150006”:“Ds021029212754”:“Sr060623095114”:“Ea990625130532”:“ByFn940115134623”:“NJMA-49EJS2”:“Ls020911154348”:“Ps980706113143”:“Sr040206095333”:“Lg961204113140”:“Eg000526092644”:“Mr970919160817”:“Cd031105162419”:“Ar001011102256”:“GaHn940115141046”:“Jk020923113150”:“Ar010406112912”:“Ps991104132304”:“Jl051115103436”:“Sr060621152253”:“931025175210”:“De980629131418”:“Sr060621152127”:“Sr040614113110”:“Ar000801115006”:“De961029152733”:“A.Ki941013120943”:“Jl051025173348”:“Pr041209100259”:“Vd000818135340”; VaultusTemp_Person_Contact_ID_Values10 := “Js971114172953”:“Sn981211103907”:“Li050721120136”:“Jg990108163758”:“Sr050311144437”:“Pr960212103033”:“DdCn940505171324”:“Sy970708112618”:“Ld020910095018”:“Ce040426181712”:“Sr060517170943”:“An040423120222”:“Ld000531150803”:“Ao981207151356”:“Pr060214133845”:“Jg960520185014”:“Ts020624163208”:“Lt960829152817”:“Ln950726110314”:“940218154622”:“Ma950929094002”:“Sn980213144730”:“Ea971204121035”:“Sr991101145540”:“ShRy950605184246”:“Mh000302125712”:“Ss991104105227”:“Kd010511140951”:“Pa980304191144”:“EnGr950616182717”:“Cl050418153236”:“Jl040910111755”:“Es991216124753”:“La040715141218”:“Ln010411171709”:“Rs980918095315”:“Li051014151412”:“Az040526130735”:“Mn010802182931”:“Jy990422180356”:“Br980701152737”:“BlWn940114121148”:“Es000911121848”:“PlSe950307172352”:“Dr950928093912”:“So971113143233”:“Sr000608152933”:“Ka991005170655”:“Jl051024155350”:“Mc010110151734”:“Vo971126173713”:“Pr950808090007”:“LfHh941221151414”:“Ld960904124433”:“Sr001109144307”:“Jl041202143223”:“931227140459”:“Jl040826153509”:“Jy031008152747”:“931207195036”:“So970407155521”:“Jl060620101359”:“Li050624114932”:“Jl001205151223”:“931116182037”:“NJMA-4AM9YR”:“Mn050412100758”:“Cn950829075820”:“Ls980608153351”:"DsBe95053
1093814":“Ts010206105408”:“Co011130184444”:“Mn020923155921”:“Ne041222135413”:“Nr990308171215”:“Sn960325091047”:“De970722150132”:“AlBr940926104456”:“Sn980806151735”:“Jk021015164527”:“Ez010206171618”:“Je980116074458”:“Jt030624114439”:“Sr990809145607”:“Nr990311163621”:“Ar000912150045”:“Se040406111010”:“940103092853”:“Rh050502100620”:“Jl060626102517”:“NJMA-4A99C5”:“Ar000913104414”:“Ld001115104856”:“Ra991101142640”:“Cn050628123817”:“Dt991118112535”:“Sn991221152146”:“KtJs931116182504”:“Jk021015164841”:“L.Cr950118110942”:“Jy970613105916”:“R.Je950412155506”:“Sh951018185409”:“Ma951120164321”:“Es001013102239”:“Sr060215121638”:“Es001012152756”:“Ma960415090530”:“Jy030320094442”:“Jk030205151231”:“Jk030224143800”:“CORP12050”:“NJMA-4A9CA8”:“Ra990108103545”:“De970620162637”:“Ma980803134638”:“RdTa950412095642”:“Tr960924113535”:“Jy990401133733”:“Jk020204155807”:“Sn981005172431”:“Co011129172417”:“Ma011129180307”:“Jl040910110935”:“Gg001030121811”:“Li050624091314”:“Jt050125142739”;
VaultusTemp_Person_Contact_ID_Values11 := “JoLt940509182055”:“Re980630154840”:“SeWh950223093840”:“Jk030811130032”:“De961029105259”:“Ty990420174437”:“Jk030606100244”:“Ar000913102958”:“So951213153527”:“Ld010205151010”:“Ts050523093857”:“Mr050301182544”:“Jk020503092453”:“Ld030210112047”:“OrTr950322162018”:“Mr960716110315”:“Cr031023132730”:“Sr991102104835”:“Jk030205151112”:“An000911154526”:“Jk010907095404”:“NJMA-49EKAF”:“Ar001011094100”:“Ro040908092720”:“Cr031008160118”:“Gg001102115914”:“Bs040614113139”:“Ld970827114543”:“Mt060608102657”:“An030820120503”:“An040422114154”:“Jl060206124844”:“Ls970130150651”:“Es040106145859”:“Jl060227085515”:“Ma950929100848”:“Li050624105919”:“Bs021011171903”:“Mi020325113000”:“Mn030930145628”:“Mc010410140229”:“De971007162903”:“940126114857”:“RdRs940117162758”:“Sr021206120512”:“Sr060214152120”:“Js021125145913”:“DnTs931009181550”:“Jk020213152911”:“An040422141233”:“De980602123517”:“P.Cy950116144038”:“Jk021014163246”:“Cr040526162437”:“Tn970325094707”:“Jk030515144544”:“Sn981207135804”:“Ai011008164802”:“JnGy950322113721”:“Sa991026130719”:“Cr000828111507”:“Mi011022114126”:“Ra050118152837”:“BOBR-49LTFB”:“Jl060620100728”:“940104164803”:“Jy990226165914”:“D.Ro940914120744”:“CORP9297”:“Gs990210134048”:“Es030724110852”:“Es001013092832”:“CORP276”:“Jy951218125141”:“Ar000914102942”:“Ss991104112013”:“Jr030618183301”:“Js020325164018”:“Jk030411135530”:“Sa970429142040”:“Cr031024124651”:“Nr991220112703”:“M.Ko950309170739”:“Le950916144022”:“Ty030707095747”:“Nr000731114746”:“931228170651”:“Es001031104753”:“Jy030320104345”:“Rn000411142246”:“J.Lw950504103819”:“Ld020626113311”:“Sn990111111745”:“Pr950725195214”:“Pr960212102941”:“CORP2284”:“Sy000301161710”:“Ar001121161253”:“Ld000427170732”:“940222155503”:“M.Pa940115144319”:“940106131556”:“Jg971107151655”:“An031203120038”:“Sr060511152543”:“Li050624084443”:“Le971218102606”:“Jy950705135600”:“Sr021031133222”:“YhLe950406163402”:“Sn991123150926”:“S.Py950322112131”:“Jl050311143410”:“D.Ty940125161918”:“NJMA-4AA4T7”:“Ct050802112942”:“Jl050203115432”:“Ok960916113558”:“Ld981007163609”:“G.Kl940516133449”:“Jh010302140557”:“Ar000630132908”:“Sk971014150352”:“An040423120022”:“Jk010904114333”:“Di000519093720”:“Cr031024133259”:“931229115137”;
VaultusTemp_Person_Contact_ID_Values12 := “Jk010629105005”:“Sk991206083513”:“De970307110010”:“Li051031150921”:“Dr000629143710”:“M.Oe941220104909”:“Pr040323101431”:“Rs010108173758”:“Ma950915151457”:“Sr060505114138”:“Na060605110444”:“Li050624111837”:“Jl050209100839”:“So970220161752”:“DPSz950214154118”:“Jt960531103033”:“De970617145704”:“Ar010305093248”:“Ji021104140751”:“An010125184242”:“De961029152029”:“Es001013095330”:“Ln970227110643”:“Wn001213093112”:“Ah970815095506”:“Lu970618115250”:“No960126114353”:“De970108113455”:“Va960419142906”:“Sr040927162433”:“Ar000823162448”:“Sr000511162357”:“Ld w950606112934”:“Br991214155306”:“Jl060621123052”:“Jy990528132434”:“Ka991008152720”:“Bs040311171200”:“931207185915”:“Ml050110130208”:“CORP14021”:“931207190917”:“GdB.950105170239”:“De970401160249”:“En000612163018”:“Jl050720122600”:“Lg961211100749”:“Jk020820165142”:“NJMA-4A9A9C”:“KnKy950502141145”:“Na010207140339”:“DeFe950314164027”:“Jg980316104403”:“Ea970805153307”:“Ty980827132611”:“940106133059”:“Li050718121316”:“CORP4095”:“Ld001010120716”:“Eo000105122355”:“T.Sl940411090141”:“Co011129181214”:“940314181749”:“Jk010511081530”:“ArMa940921153154”:“E.Gr940115144055”:“Sr050210120154”:“940107113442”:“Co011130185423”:“Kn961203151618”:“Ah970923111159”:“940215102857”:“Sr060717114743”:“Mr961205174610”:“Ej000908190109”:“Jl060620100931”:“Ez030403175451”:“An031006122101”:“At950713151152”:“NJMA-49EKVH”:“Ba030819104614”:“Ld990426122808”:“JnMn940607183518”:“De971009163027”:“Li051024154204”:“De980601152911”:“BnJs950411144936”:“Ln010213085808”:“No970115125027”:“W.EI940824162957”:“Cr040322144647”:“Jk030206120019”:“Bs990517132016”:“Jr010109142019”:“Ar000823164027”:“Am980119091513”:“Jk030117162133”:“An031023113531”:“Es000630120632”:“Jk030605102537”:“Sr020718153413”:“Jk030204114404”:“940211133616”:“931230132313”:“Li051024152515”:“Si960930135121”:“Ld990526124734”:“K.So941014093504”:“Lg981102161350”:“Ln950731144117”:“CORP1801”:“Jg970328115626”:“Jk020118123535”:“940322153733”:“Ln951207112253”:“Nr041027161542”:“Jk020927161248”:“W.Kb941202125226”:“Gg001020104131”:“Sr990414152859”:“Mn011101180358”:“Li050624121516”:“Ar000801115815”:“Jk021014161124”:“Sw000612200635”:“Dy981228114337”:“Ls990316152748”:“Oo040928105455”;
VaultusTemp_Person_Contact_ID_Values13 := “931208191712”:“Sn950630112847”:“Li050624090130”:“Jy991022135653”:“Jl060206133807”:“So950922092710”:“AKIG-5DTK9K”:“An040422091518”:“Sr060505135222”:“Co011129175254”:“Bs970428163806”:“BOBR-49LTGA”:“Es001012121932”:“940314121303”:“Ld000802153512”:“Ld980928120516”:“Mr980909094040”:“Sr050329101248”:“Jy030320102336”:“Ml040608092157”:“Ty040128172455”:“Jk021114101125”:“Jl051024170955”:“Rs980706113159”:“Ci000612102400”:“Jl041105095849”:“Vo981223194719”:“So980212092613”:“Nr010307100547”:“Mg970108160241”:“Ld000127142924”:“NJMA-49Y92F”:“Sa981201141342”:“Jg960117171309”:“Jl050209101205”:“Sr991025115258”:“Rn000327172931”:“Pr960130121904”:“Jl050720124127”:“940303160344”:“Br960110113622”:“Dl990916151655”:“940316152234”:“Jl051110160445”:“Ts020102122032”:“Jk010731093757”:“De980818101411”:“Cr040511172450”:“Ts051006083919”:“Nr981110095235”:“J.Cr940117163135”:“CsAn940421080642”:“Cr981028090721”:“No960403094314”:“Bn040929182825”:“Jk020820165438”:“Ln000925125202”:“Ml001031151249”:“Rs971031180107”:“Co011129171830”:“No950808161844”:“CORP2032”:“An040213083209”:“CgMe940609103310”:“Ao020801123037”:“Fo021010092513”:“Ai031203101620”:“Ma951005150935”:“LaPn940713114050”:“Li050524150550”:“Jl040921153324”:“Ek981027123622”:“Sr060621150340”:“NyDn940224124112”:“Jy960813101112”:“Nr981105101701”:“MkSn940421135109”:“Rn000327172532”:“Sr990903141237”:“Ld010227164118”:“Cd010312143054”:“CdKh940401180209”:“De970123151341”:“Lm030903134012”:“D.WI950302153353”:“Ts991221104048”:“940321164247”:“Ar000824152823”:“S.On950301104312”:“Kr010621113405”:“Jk020820110739”:“Mc001121111939”:“Ma980930154620”:“Sr040818124212”:“Sg990208143021”:“Ml001204141603”:“Ss000329122434”:“VaBr940202103744”:“De981006113226”:“Ln000503095030”:“Ss020625123334”:“931011174733”:“Jk010515112026”:“Ld040128122553”:“Ls980413150420”:“Li050624112911”:“Li050615105522”:“La040715115437”:“Jg970918130827”:“RkRn950407160938”:“Sr020925101445”:“Jl051024124900”:“NJMA-4AN8AM”:“Aa000504124636”:“Jg960725204226”:“Ra030912103325”:“Ar000815154709”:“Cd000831131112”:“Es010314102338”:“Jy990809195047”:“Sy000410111615”:“Ma960725132754”:“An021023131056”:“940126152157”:“Ez000605102727”:“Ea991022180751”:“Jy960409102740”:“Ld000414172751”;
VaultusTemp_Person_Contact_ID_Values14 := “Se040406110933”:“JnFr940826142110”:“Cn961015125016”:“Mn000712094809”:“Qu000801181937”:“Ao000703204427”:“Sr021011144150”:“De960829104657”:“P.Az931009180238”:“Mn000420085538”:“Ts971106163729”:“Jt030109100721”:“Sl020205141247”:“Co011130183212”:“Ea971117163917”:“Sr060510110128”:“FIX35”:“Ld960415175729”:“Sn010919151058”:“Ah971106081412”:“Ld010511160652”:“Ls960904175355”:“Ma950831144808”:“Sr031009120638”:“Lg961204153929”:“Ts040609173954”:“Ls970916101716”:“Ty981130090506”:“940109100026”:“Sr010816104440”:“Ls980122171902”:“Ra991228124312”:“Rn990319172340”:“Mr970203170041”:“Jy951218130026”:“E.An941011131901”:“Ld990506094430”:“No961119121643”:“940324184544”:“Ao981208102918”:“Cr031203114643”:“Ld031015180513”:“Ls970129153023”:“Sr011107092413”:“Lu981013204158”:“De961113144824”:“Ld960612165650”:“Ka990512164935”:“Js040225164822”:“Jl050218082933”:“K.Fy950411113642”:“931020110849”:“Sr990701152521”:“Sn980824130926”:“Cr031027115815”:“Me990927150102”:“Mn990204170126”:“Br020725143549”:“Dm020422180634”:“931208201320”:“Ar000731111938”:“Sr030130162137”:“Jg970912164354”:“Jl041206112203”:“Ar000913103331”:“Ty970516161504”:“W.Me940115151510”:“Sn990616101722”:“CORP11108”:“Mn960405104502”:“PrBe950202171633”:“Rn961118141714”:“Jl060208105843”:“Ru040617164353”:“JfLe940112121122”:“Jl060208112359”:“Jl060208105203”:“JsTs941114133705”:“Es001031110827”:“A.Ke940426165732”:“Bn950928182854”:“Jl041028135323”:“Ty970521093232”:“CORP13338”:“Jy020114083027”:“An030701104704”:“Jk021203140556”:“Sy981008103001”:“Ts020523135610”:“Li050624080047”:“Ja001110100803”:“931221124446”:“No970404103409”:“CORP5755”:“Dy970522155015”:“Ts021206090705”:“Ma980803140433”:“NJMA-4A6VXN”:“Lg960603102138”:“Jh001128181906”:“Sr060621151318”:“Sr060626104450”:“Jg970703153756”:“Sr041027161442”:“Ma960725132046”:“Cr040715105546”:“Ar000731091320”:“JyCr940506131154”:“Cg000818100203”:“Li050624113439”:“SeBm950614145001”:“Ma950710164036”:“Cr040628114416”:“Jk010531155350”:“BtAy940608101242”:“Le950925151710”:“Li051024155547”:“Cn951128092544”:“Cs050603092416”:“Cr980820101219”:“Re960628112443”:“Cr031009115030”:“YaZl950327103725”:“Rn990920140137”:“Jt020918114011”:“KnKn950425114051”:“Sr000630173830”:“Sl010619172800”;
SELECT (Form=“RMS\Relationship” | Form=“RMSRel”) & (ContactIDSideA=VaultusTemp_Person_Contact_ID_Values1:VaultusTemp_Person_Contact_ID_Values2:VaultusTemp_Person_Contact_ID_Values3:VaultusTemp_Person_Contact_ID_Values4:VaultusTemp_Person_Contact_ID_Values5:VaultusTemp_Person_Contact_ID_Values6:VaultusTemp_Person_Contact_ID_Values7:VaultusTemp_Person_Contact_ID_Values8:VaultusTemp_Person_Contact_ID_Values9:VaultusTemp_Person_Contact_ID_Values10:VaultusTemp_Person_Contact_ID_Values11:VaultusTemp_Person_Contact_ID_Values12:VaultusTemp_Person_Contact_ID_Values13:VaultusTemp_Person_Contact_ID_Values14)