Yav tas los lub limtiam uas kuv tau siv lub tswv yim no muaj "evolving" muab rau ib tug neeg uas siv cov BDC thiab cov SPQuery thiab khiav rau tej teeb meem siv SPQuery rau ib daim ntawv uas muaj folders. Ntxaib: cob "recursive" mus saib attribute rau cov lus nug.

Kuv scenario:

• Hnub Monday, Upload ib daim ntawv thiab muab tej ntaub ntawv no meta.
• Lub lim tiam li nram no, Kuv upload ib daim ntawv tshiab. Ntau yam ntawm cov ntaub ntawv meta no daim ntawv tus tshiab raws li daim ntawv kuv busy uploaded (uas peb hu tus "npaj ntaub ntawv").
• Peb thiaj tau tsim lub Web site pab façade uas muab hauv BDC interface rau daim ntawv kom cov neeg siv tau yooj yim nrhiav ntawd hnub ib daim ntawv ntawm lub npe nrhiav.
• Ib tug ncej tag BDC tej ntaub ntawv qhia tus neeg siv tus phooj ywg interface. (Qhov no yog ib feem ntawm kuv los kom siv BDC rau sab Lookup ntau tus phooj ywg).

Qhov kawg BDC façade kev siv ib cov lus nug li no ua rau lookup:

 // Siv U2U tuam mus pab generating qhov lus nug no CAML.
      oQuery.Query =
        "<Nyob qhov twg>";

      Yog hais tias (titleFilter.Length > 0)
        oQuery.Query  =
          "  <Thiab>";

      oQuery.Query  =
        "    <Thiab>" +
        "      <Geq>" +
        "        <FieldRef Name = yog muaj "DocumentId" />" +
        "        <Value yam = yog muaj "Text">" + minId + "</Tus nqi>" +
        "      </Geq>" +
        "      <Leq>" +
        "        <FieldRef Name = yog muaj "DocumentId" />" +
        "        <Value yam = yog muaj "Text">" + maxId + "</Tus nqi>" +
        "      </Leq>" +
        "    </Thiab>";

      Yog hais tias (titleFilter.Length > 0)
        oQuery.Query  =
          "    <Muaj>" +
          "      <FieldRef Name = yog muaj "Title" />" +
          "      <Value yam = yog muaj "Text">" + titleFilter + "</Tus nqi>" +
          "    </Muaj>" +
          "  </Thiab>";
      oQuery.Query  =
        "</Nyob qhov twg>";

Thaum pib txog theem ntawm kev loj hlob, qhov no ua haujlwm great. Txawm li cas los, peb nkag tau folders rau hauv cov directory yuav kom daws tau tej teeb meem no thiab mam li nco dheev, Kuv tus BDC picker tsis rov qab muaj ntsiab. Kuv tracked no mus ua tus Disease fact tias tus SPQuery yeej tsis rov muaj ntsiab. Peb siv folders los pub ntau yam ntaub ntawv uas muaj lub npe qub los yuav uploaded tab sis meta tej ntaub ntawv uas muaj neeg. Thaum cov ntaub ntawv yog uploaded, peb yuav tsim ib tug ntawv tais ceev tseg raws li daim ntawv teev khoom tus ID thiab mam li tsiv ntawv muaj (Kuv thiaj sau txog ntawd ntawm no; peb twb muaj mixed ntsuam cov kauj, tiam sis ntawm tus kheej, nws zoo zoo). Tus neeg siv tsis care txog folders thiab tiag, tsis tshua to taub tias muaj ntau yam folders. Peb muaj configured tag nrho cov kev views rau lub tsev qiv ntawv los qhia cov khoom s. folders.

Kuv ntaus cov teeb meem no ob zaug raws li cov kev siv evolved thiab solved nws txawv txhua sij hawm. Thawj thawj zaug, Kuv tsis yog siv tus neeg teb xov tooj CONTAINS rau cov lus nug. Tsis muaj ib tug neeg tsav tsheb CONTAINS, Kuv txawm yuav kom daws tau qhov teeb meem los ntawm specifying cov pom hauv lub SPQuery contructor. Tsis txhob siv lub neej ntawd constructor:

Splist.Update() oList = Web site.Teev["Cov ntaub ntawv"];

SPQuery oQuery = tshiab SPQuery();

Kuv txhais xwb ib constructor uas teev ib saib:

Splist.Update() oList = Web site.Teev["Cov ntaub ntawv"];

SPQuery oQuery = tshiab SPQuery(oList.Views["Cov ntawv"]);

Solved qhov teeb meem ntawd thiab yog tau txais kuv tau.

Ces kuv ntxiv hom kab mob tus neeg teb xov tooj CONTAINS ua tus ntse thiab raug dua. Nws puv tawm uas tus neeg teb xov tooj CONTAINS, thiaj li yuav paub kuv, tsis ua hauj lwm nrog rau cov saib tau ib yam nkaus li rau ib cov zauv GEQ / Tswv LEQ. Kuv tau ua ib co searching thiab kawm tias ViewAttributes cov lus nug yuav tsum muab teev cia rau cov "Recursive", raws li nyob rau hauv:

oQuery.ViewAttributes = "Tau = yog muaj"Recursive"";

Uas solved qhov teeb meem rau CONTAINS. qhov tseeb, qhov no kuj solved kuv yuavtsum nrhiav teebmeem thiab yog hais tias kuv yuav tsum teev cov recursive attribute thawj zaug, Kuv yuav tsis tau khiav mus rau hauv lub qhov teeb meem dua.

Tus fact SPQuery Saib kuas rau qee tus tswv xwb (GEQ/LEQ) thiab tsis yog lwm leej lwm tus (MUAJ), coupled nrog cov fact KPIs tsis zoo li mus ua hauj lwm txhua nrog rau nplaub tshev uas muaj ntaub ntawv qiv leads kuv ntseeg hais tias SPQuery muaj tej qhov teeb meem txog orthogonality.

Tsaug tshwj xeeb:

• Tus zoo folks tom U2U thiab lawv cov lus nug cuab tam.
• Michael Hoffer tus poj "kev kawm tau los ua" Blog ncej, lus thiab cov lus teb.

</kawg>

Subscribe rau kuv blog!