Skip to content

Izihluzi Zeekholam ​

Itafile Yedata inokubonisa amakhulu amawaka eerekhodi. Izihluzi zeekholam yindlela osuka ngayo kuzo zonke uye kwezimbalwa obuzifuna ngokwenene - ngaphandle kokubhala umbuzo, kwaye ngaphandle kokushiya itafile.

Zimbini iindlela zokubuza, kwaye zizimbono ezimbini zento enye:

  • umgca wokukhangela, ibhokisi ngaphantsi kwentloko nganye yekholam, ukwenzela "ndibonise ezo zithi MAIN" ngokukhawuleza;
  • i-funnel (isihluzi) entlokweni, evula imenyu epheleleyo yekholam - uluhlu lokuphawula lwamaxabiso okwenene aloo kholam, kunye nayo yonke imibuzo enokubuzwa kolo hlobo lwekholam.

Oko okusetayo kwenye kuvela nakwenye. Azisoze zibe zizihluzi ezibini ezahlukeneyo ezilwayo.

Intloko yeTafile Yedata ibonisa i-funnel kwintloko nganye yekholam, umgca wokukhangela ngaphantsi, amaqhosha esihluzi esiphucukileyo kunye nokucima kwiseli yokuqala, kunye nezitshintshi zeVisible, Selected kunye neUngeocoded ngaphantsi kwetafile
Sonke isilawuli sesihluzi kwitafile, kunye noko sinye ngasinye sikwenzayo

Zihlala phi

Umgca wokukhangela uhlala ngqo ngaphantsi kweentloko zeekholam. Ukuba awuwuboni, wuvule kwakhona ngeqhosha lika-Khangela kwibha yamaphepha ngezantsi kwetafile. Ii-funnel zihlala zisezintlokweni ngamaxesha onke.

Umgca wokukhangela ​

Uphawuluziso: ukuchwetheza uMAIN kwibhokisi ngaphantsi kwekholam yeStreet; imigca engahambelaniyo iyabhanga, inani leerekhodi liyehla, kwaye i-funnel yeStreet iyazala
Chwetheza kwibhokisi yaye itafile izincitshise

Cofa ibhokisi, uchwetheze, uze ume. Awucofi u-Enter yaye alikho iqhosha lika-Apply - itafile ihlaziyeka malunga nesiqingatha somzuzwana emva kokuba uyekile ukuchwetheza. Cima ibhokisi yaye ikholam iyeka ukuhluza.

Ibhokisi nganye ibuza umbuzo ohambelana nekholam yayo, kwaye umbhalo omdaka ongwevu kwibhokisi engenanto ukuxelela ukuba nguwuphi:

Ibhokisi ithiIya kuthiIikholam eziqhelekileyo
contains…ifumane umbhalo wakho naphi na kwixabisoigama lesitrato, inkcazo, amanqaku
equals…ihambelane ncam nenani olichwethezayoubungakanani, ubude, ixabiso, izifundo ze-GPS
is…ivule ikhalenda encinci ize ihambelane nolo sukukubhalwe, kulinganisiwe, utshintsho lokugqibela
is one of…ikuvumele uphawule amaxabiso kuluhlui-zoning, imeko, nayiphi na ikholam eneempendulo ezimbalwa
no searchakukho nto - le kholam ayinakuhluzwaiifoto, izitywina, iiphaswedi

Ukuhambelana kombhalo akukhathali ngoonobumba abakhulu: main, Main no-MAIN bafumana imigca efanayo.

"value filter" kwibhokisi

Ukuba ibhokisi ibonisa value filter ize ingavumeli ukuchwetheza, kuthetha ukuba uphawule amaxabiso kwi-funnel yaloo kholam. Ezi zimbini azinakudityaniswa kwibhokisi enye - cima isihluzi se-funnel yaye ibhokisi iyasebenza kwakhona.

Ukucima umgca ​

Isitshintshi se-Khangela kwibha yamaphepha sifihla wonke umgca xa ufuna ubude obongezelelweyo beerekhodi. Ukusifihla akucimi nto oyisetileyo - ii-funnel zihlala zizele yaye ibheji iyaqhubeka ibala. Amaqhosha esihluzi esiphucukileyo nawokucima afudukela kwibha yezixhobo ukuze usakwazi ukuwafikelela.

I-funnel: imenyu yekholam ​

Cofa i-funnel kwintloko nganye yekholam yaye imenyu yaloo kholam iyavuleka.

Imenyu yekholam: ukubethelela nokulinganisa ubungakanani, cima le kholam, uluhlu lwe-operator, ibhokisi yokukhangela amaxabiso, uluhlu lokuphawula kunye namanani, uphawu lwe-(Blanks), isishwankathelo ngolwimi olucacileyo, namaqhosha eCancel neOK
Imenyu yekholam, inxalenye nganye
InxalenyeOko ikwenzayo
Pin to left / Pin to rightIbethelela ikholam ukuze ihlale ibonakala ngelixa uskrola ecaleni. Ayinikwa ikholam esengaphakathi kwebhanti yentloko.
Autosize columnIlinganisa ikholam ukuze ilingane noko kukuyo.
Clear Filter From "…"Isusa isihluzi kule kholam inye kuphela, zonke ezinye zishiyeke zingachukunyiswanga. Icinyiwe xa kungekho nto inokucinywa.
<Uhlobo> Filters ▸Beka kuyo yaye ii-operator zolu hlobo lwekholam ziyavela. Jonga Ukubuza omnye umbuzo.
Search values…Ikhangela kumaxabiso ekholam. Ijonga irekhodi nganye yetafile, kungekhona kuphela lawo akweli phepha loluhlu.
Uluhlu lokuphawulaIxabiso ngalinye elahlukileyo kwikholam, kunye nenani leerekhodi ezinalo.
(Blanks)Iirekhodi apho le kholam ingenaxabiso konke konke.
Umgca wesishwankatheloOko u-OK aya kukwenza ngokwenene, kuthethwe ngamagama.
Cancel / OKAkukho nto uyiphawulileyo isetyenziswayo phambi kokuba ucofe u-OK. Iinketho ze-pin, Autosize column ne-Clear Filter From zisebenza kwangoko xa uzicofa.

Akukho kuhlelwa apha

Akukho migca ka-Sort A → Z kule menyu. Kwitafile yedata, ulandelelwano luvela kuluhlu lwe-Lungelelanisa Ngo kwibha yezixhobo, echazwe ku-Itafile Yedata.

Ukuphawula amaxabiso ​

Uphawuluziso: ukuvula i-funnel yeZoning, ukususa uphawu ku-(Select All), ukuphawula uResidential 1 noResidential 2, ukucofa u-OK, kwaye itafile incitshiswa yaya kwimigca emine ehambelanayo
Susa uphawu ku-(Select All), phawula oko ukufunayo, cofa u-OK

Uluhlu luvuleka nako konke kuphawuliwe, kuba "konke kuphawuliwe" yindlela yale menyu yokuthi akukho sihluzi kule kholam.

Indlela eqhelekileyo yile:

  1. Cofa u-(Select All) kanye ukususa onke amaphawu.
  2. Phawula amaxabiso ofuna ukuwagcina.
  3. Cofa u-OK.

Unokwenza nangenye indlela - shiya konke kuphawuliwe uze ususe uphawu kumaxabiso amabini ofuna ukuwalahla. Umgca wesishwankathelo ngezantsi ukuxelela ukuba yeyiphi kwezi zimbini oyenzayo:

Isishwankathelo sithiIntsingiselo
Showing every value - no filter on this column.Akukho nto ihluzwayo apha.
Showing only the 3 ticked.Iirekhodi kuphela ezinelinye lala maxabiso mathathu.
Showing everything except the 2 unticked.Yonke into ngaphandle kwalawo mabini.
Showing only the rows where this column is blank.Iirekhodi ezingenanto kuphela.
Blanks are included / excluded.Ukuba amaxabiso angenanto ayahamba na.
Values the search hides are not included.Ukhangele ngaphakathi kuluhlu, ngoko amaxabiso afihlwa kukukhangela ayinxalenye yoko ukugcinayo.

Funda loo mgca phambi kokuba ucofe u-OK. Kuluhlu olude, "gcina la mathathu" no "susa la mathathu" babonakala befana ngamaphawu, kodwa zizihluzi ezahluke kakhulu.

Amaxabiso owaphawulileyo aya phezulu ​

Amaxabiso aphawuliweyo aqokelelwa phezulu koluhlu, ngaphezu komgca omncinci. Olo landelelwano lubekiwe xa uluhlu lulayishwa yaye alutshintshi ngelixa ucofa, ukuze ixabiso lingaphumi phantsi kwesalathisi.

Amanani ​

Inani elikwicala lasekunene lexabiso ngalinye linani leerekhodi ezinalo, ngaphakathi koko itafile ikubonisayo ngoku - kungekhona amangaphi akhoyo kumaleko lonke. Vula isitshintshi sobubanzi okanye uhluze enye ikholam, kwaye amanani ayahamba nawo.

Ukuba ikholam inkulu kakhulu ukuba ingabalwa ngexesha elifanelekileyo, uya kubona u-Counts unavailable endaweni yoko. Amaxabiso asachanekile; ngamanani kuphela angekhoyo.

Uluhlu olude ​

Ikholam eneewaka zamaxabiso ahlukeneyo ayinakuwabonisa onke ngaxeshanye:

  • kuvela amaphepha amancinci ngaphantsi koluhlu - ixabiso ngalinye lifikeleleka ngokuhamba ngamaphepha;
  • inqaku lixela ukuba makangaphi amaxabiso ahlukeneyo ekukonke;
  • ibhokisi ye-Search values… ikhangela kuyo yonke ikholam, ngoko unokutsibela ngqo koko ukufunayo endaweni yokutyhila.

Ezinye iikholam ezinkulu kakhulu zithatha ixesha. Imenyu iya kuthi Loading… ize iqhubeke ilayisha endaweni yokwala - uluhlu oluthatha ixesha lufanele ukwaziwa, kwaye umlawuli wakho angongeza i-index kuloo kholam.

Kunqabile ukuba ubone u-Too many different values to list. Use a filter rule below instead. Ayikho kholam engenanto le - kuthetha ukuba le kholam ithile ayinakubalwa yonke, yaye kufuneka usebenzise uluhlu lwee-operator. Ngumyalezo owahlukileyo ku-No items match your search, othetha kanye oko akutshoyo.

(Blanks) ​

Amaxabiso angenanto anophawu lwawo, ahlukile kwixabiso ngalinye lokwenene. Oku kubaluleke ngaphezu kokuba kuvakala: kwikholam ye-Ewe/Hayi, irekhodi apho kungekho mntu waphendulayo asiyorekhodi ephendule hayi, kwaye luphawu lwe-(Blanks) kuphela olunokuzahlula.

Umxube omnye uluhlu lokuphawula olungenakuwuqulatha

"Akukho namnye kwala maxabiso, kodwa gcina angenanto" yeyona nto inye engenakuchazwa sisihluzi sekholam enye. Ukuba uyayicela, umyalezo uyakuxelela yaye isihluzi asisetyenziswa - endaweni yokukunika iirekhodi ezininzi kunezo uzicelileyo ngokuthe cwaka. Susa uphawu ku-(Blanks), okanye wakhe umbono ofanayo kuluhlu lwee-operator.

Ukubuza omnye umbuzo ​

Uphawuluziso: ukubeka kuNumber Filters, ukukhetha uBetween kuluhlu oluvelayo, ukuchwetheza u-800 no-1 100, ukucofa u-OK, uze uvule i-funnel kwakhona ubone amaxabiso ahambelanayo ephawuliwe eqokelelwe phezulu
Khetha i-operator, gcwalisa iibhokisi, cofa u-OK

Ukuphawula amaxabiso kulungile xa ikholam ineempendulo ezimbalwa. Kwi-inkulu kune, phambi ko, phakathi kwe nezinye, beka kumgca we-<Uhlobo> Filters uze ukhethe kuluhlu oluvelayo.

Ukukhetha i-operator kutshintsha uluhlu lokuphawula lube yifomu encinci:

  • uninzi lwee-operator luthatha ibhokisi enye;
  • Between ithatha ezimbini, kwaye ibandakanya zombini iziphelo;
  • Is empty no-Is not empty azithathi nanye - cofa nje u-OK;
  • Add Rule yongeza imeko yesibini kwikholam efanayo (ukuya kwezine), kunye ne-Match All / Match Any ukuchaza ukuba irekhodi kufuneka yanelise zonke okanye nayiphi na enye.

Back to values ikubuyisela kuluhlu lokuphawula ngaphandle kokulahlekelwa nto.

Ukuvula kwakhona ikholam oyihluze ngemeko ​

Vula i-funnel kwakhona kwikholam ehluzwe ngo-, masithi, Between 800 and 1 100, yaye uluhlu lokuphawula lukubonisa oko loo meko iyibambayo: amaxabiso ahambelanayo aphawuliwe kwaye aqokelelwe phezulu, kunye nenqaku elithi Ticked to match Between 800 and 1 100.

Amaphawu ngumfanekiso wemeko, hayi ukhetho olwenziwe ngumntu. Nje ukuba ucofe olunye, luba luluhlu lokuphawula oluqhelekileyo yaye imeko ithatyathelw' indawo koko ukuphawulileyo.

Oko uhlobo ngalunye lwekholam lukuvumela ukukubuza ​

Ii-operator ezinikwayo zivela kwi-hlobo lwentsimi, kungekhona kwigama lekholam okanye koko kukuyo. Kungoko inombolo yesalathiso egcinwe njengombhalo inikeza Starts with, ngelixa umlinganiselo unikeza Greater than.

Uhlobo lwekholamOko unokukubuza
UmbhaloContains, Does not contain, Starts with, Ends with, Equals, Does not equal, Is empty, Is not empty
Inani nemaliEquals, Does not equal, Less than, Less than or equal, Greater than, Greater than or equal, Between, Is empty, Is not empty
Umhla, okanye umhla nexeshaIs, Is not, Before, After, Between, Is empty, Is not empty
Ewe / HayiEquals (Yes, No), Is empty, Is not empty
Iikhowudi: i-barcode, i-device ID, inombolo ye-ID, ifowuni, i-email, ilinkiEquals, Starts with, Contains, Is empty, Is not empty
I-ID ezimeleyoEquals, Starts with, Is empty, Is not empty
UmbalaEquals, Is empty, Is not empty. Uluhlu lokuphawula lubonisa umbala ngamnye ecaleni kwekhowudi yawo.

Iziphumo ezimbalwa ekufuneka zaziwe:

  • Umbhalo ofana nenani ugcina oonqaku bakhe bokuqala. Ikhowudi efana no-007 ngumbhalo, ngoko ifumana ii-operator zombhalo yaye ihlelwa njengombhalo. Ayiguqulwa ibe ngu-7.
  • Iikhowudi zibuza imibuzo yexabiso lonke kuqala - Equals, emva koko Starts with. I-barcode okanye inombolo ye-ID iyakhangelwa, ayityhilwa nje.
  • I-ID ezimeleyo ayinayo i-contains. Isiqwenga esivela embindini wesitshixo asihambelani nanto eluncedo.
  • Imihla ihambelana nosuku lonke, kungekhona umzuzwana, ngoko Is 14 March ifumana konke okubhalwe ngaloo mini.
  • Ikholam yelookup inika uluhlu lwayo. Ibhokisi engaphantsi kwesihloko luluhlu oluwayo lwamaxabiso e-lookup, kwaye uluhlu lwamaphawu lwe-funnel lubonisa ixabiso ngalinye kuluhlu ngegama, kunye nokuba mingaphi imigca eliphetheyo, endaweni yekhowudi egcinwe kwikholam.
  • Ezinye iikholam azisoze zihluzwe, nokuba useto luthini: iifoto, iifoto ezininzi, iividiyo, ii-voice note, izitywina, iiphaswedi, i-geometry kunye nedatha ye-binary. Iikholam ze-multi-select azikangeni kwizihluzi zeekholam okwangoku - zisafikeleleka ngebhokisi ye-Search yebha yezixhobo.

Ikholam engenayo i-funnel nebhokisi

Umlawuli wakho uphawula intsimi nganye ukuba ingakhangeleka okanye hayi. Intsimi engaphawulwanga ukuba ingakhangeleka ayifumani bhokisi yesihluzi okanye i-funnel - sisigqibo soseto, ayisosiphoso. Ukuba ikholam oyifunayo ayinakuhluzwa, cela umlawuli wakho ayenze loo ntsimi ikhangeleke.

Izihluzi ziyadibana ​

Akukho nto oyisetayo ithatha indawo yenye. Irekhodi kufuneka yanelise yonke into ngaxeshanye ukuze ivele kwitafile.

Umzobo: oko uvumelekileyo ukukubona, Filter By, ibhokisi yokukhangela, Visible, Selected, Ungeocoded kunye nezihluzi zakho zeekholam zidibana nge-AND ukuvelisa imigca yetafile, amaxabiso anikwa yi-funnel, kunye neempawu ezizotywe kwimephu
Konke kuncitshisa iqela elinye leerekhodi

Oku kubandakanya:

  • oko iakhawunti yakho nemithetho yomaleko ikuvumela ukukubona - isebenza ngamaxesha onke;
  • isihluzi se-Hluza Ngo esibekwe kwangaphambili okanye esigciniweyo kwibha yezixhobo;
  • ibhokisi ye-Search yebha yezixhobo, ejonga kuphela intsimi yesihloko somaleko;
  • izitshintshi ze-Iyabonakala, Ekhetiweyo kunye ne-Engakhange iqheliswe;
  • isihluzi ngasinye sekholam osisetileyo, nokuba zingaphi iikholam.

Imephu iyalandela nayo: umaleko uyazoba kwakhona ukuze ubonise iimpawu ezifanayo nezo itafile izibonisayo.

Ukuhluza ngaphakathi kweVisible neSelected ​

Uphawuluziso: ukuvula iVisible kuncitshisa itafile iye kwiirekhodi ezingaphakathi kwembono yemephu, kwaye uluhlu lwamaxabiso lwe-funnel yeZoning luncitshiswa luye kwii-zoning ezimbini ezingaphakathi kwaloo mbono, ngamanani ahambelanayo
IVisible neSelected zincitshisa uluhlu lwamaxabiso, kungekhona itafile kuphela

Izitshintshi ezithathu zebha yamaphepha zigqiba ukuba zeziphi iirekhodi ezikhoyo ngokubhekiselele kwintsalela yokuhluza:

IsitshintshiSibonisa
IyabonakalaIirekhodi ezingaphakathi kwembono yangoku yemephu kuphela. Shukumisa okanye u-zoom kwaye iqela liyatshintsha.
EkhetiweyoIirekhodi ezikhethiweyo kwimephu ngoku kuphela.
Engakhange iqhelisweIirekhodi ezingenayo i-geometry konke konke - ziluncedo ekufumaneni oko kusafuna ukubekwa.

I-Ungeocoded izimele yodwa: ukuyivula kucima iVisible neSelected, kuba irekhodi engenajometri ayinakuba semboneni okanye ikhethwe kwimephu.

Inxalenye ebalulekileyo kukuba ezi zincitshisa nazo ii-funnel. Xa i-Iyabonakala ivuliwe, i-funnel idwelisa ii-zoning ezingaphakathi kwembono yemephu - kungekhona zonke ii-zoning zomaleko - kwaye amanani asecaleni ngamanani angaphakathi kwaloo mbono. Uluhlu lwamaxabiso alunakukunika into itafile ephambi kwakho engenakuyibonisa.

Cima isitshintshi kwaye uluhlu lubuyela kumaleko lonke.

Into enye i-funnel engazincitshisi ngayo ​

I-funnel ityeshela isihluzi sekholam yayo xa yakha uluhlu lwayo. Ukuba bekungenjalo, ukuphawula i-zoning enye bekuya kukushiya ujonge uluhlu lwe-zoning enye kuphela, ngaphandle kwendlela yokongeza eyesibini. Isihluzi sayo nayiphi na enye ikholam sisasebenza.

Ukusebenza kwiikholam ezininzi ​

Seta iikholam ezininzi njengoko ufuna; ziyadibana. Ibheji kwiseli yokuqala yomgca wokukhangela ibala ukuba zingaphi iikholam ezihluzayo ngoku.

  • Cima ikholam enye: cima ibhokisi yayo, okanye usebenzise u-Clear Filter From "…" kwimenyu yayo.
  • Cima yonke into: iqhosha u-⊗ ecaleni kwebheji. Lisusa isihluzi ngasinye sekholam, intetho ephucukileyo, kunye nokhetho lwesihluzi esigciniweyo ngaxeshanye.
  • Isihluzi esiphucukileyo: iqhosha le-funnel ecaleni livula umhleli wentetho opheleleyo, apho unokudibanisa iimeko kwiikholam ezahlukeneyo nge-AND kunye ne-OR. Oko okwakhayo apho kubuyela kwiibhokisi nakwii-funnel, kwaye oko okusetayo kwiibhokisi nakwii-funnel kukho xa uvula. Sisihluzi esinye esibonwa ngeendlela ezimbini. Eli qhosha livela kuphela ukuba umlawuli wakho unike imvume yokuhluza okuphucukileyo kumaleko - jonga Isihluzi Esiphucukileyo nezihluzi zakho ezigciniweyo.

Azikulandeli kumaleko olandelayo

Izihluzi zeekholam zihlala logama usekumaleko olo. Tshintsha umaleko osebenzayo yaye ziyacinywa, ngoko uqala umaleko omtsha ngayo yonke into ephambi kwakho. Hluza Ngo, Lungelelanisa Ngo kunye ne-Hlela Itemplate zisebenza ngokwahlukileyo - ezo zikhunjulwa ngokomaleko ngamnye.

Isihluzi Esiphucukileyo nezihluzi zakho ezigciniweyo ​

Isihluzi Esiphucukileyo sakha isihluzi kwiikholam ezininzi, kwaye Gcina Njengo usigcina phantsi kwegama lakho, ukuze ngexesha elizayo sibe lukhetho olunye ku-Hluza Ngo. Sinokuthelekisa nekholam enye nenye ikholam - Area m² inkulu kune Title deed area - into iibhokisi nee-funnel ezingenakuyenza.

Ayinguye wonke umntu onayo le nto, kwaye ayikho kuwo onke amaleko

Isihluzi Esiphucukileyo, ukugcina izihluzi zakho nokuthelekisa iikholam ezimbini zonke zicinyiwe de umlawuli wakho azivule. Izitshintshi ezimbini kufuneka zombini zivuliwe, kwaye zisetwa nge-role nangomaleko:

  • Vumela Izihluzi Eziphucukileyo kwi-role yakho, kwaye
  • Izihluzi Eziphucukileyo kwimvume yomaleko yaloo role.

Xa nokuba sinye sicinyiwe kumaleko, loo maleko awunalo iqhosha lesihluzi esiphucukileyo, akukho Gcina Njengo, kwaye akukho nasinye sezihluzi zakho ezigciniweyo ku-Hluza Ngo. Ngoko unokuba nayo kumaleko omnye ungabi nayo kolandelayo, kwaye ugxa okwenye i-role unokuba nayo apho wena ungenayo. Akukho nto yaphukileyo xa ungakwazi ukuyifumana: cela umlawuli wakho ayivule kwi-role yakho kuloo maleko. Umgca wokukhangela nee-funnel ezichazwe ngasentla zisebenzela wonke umntu, kwanjalo nezihluzi ekwabelwana ngazo neakhawunti yakho.

Ukwakha isihluzi ​

  1. Cofa iqhosha le-funnel kwiseli yokuqala yomgca wokukhangela, ecaleni ko-⊗. Xa umgca wokukhangela ucinyiwe, iqhosha elifanayo likwibha yezixhobo. I-dialog ethi Isihluzi Esiphucukileyo ivuleka ku-Ngokubona.
  2. Cofa intsimi phantsi kwe-Iintsimi ezikhoyo (chwetheza ku-Iintsimi Zokukhangela ukuyifumana kuluhlu olude). Iya ku-Intsimi.
  3. Khetha Umsebenzi uze ugcwalise Ixabiso. Kumhla ukhetha Umhla othile nosuku, okanye Namhlanje, Namhlanje + N iintsuku okanye Namhlanje − N iintsuku, ezihamba nekhalenda. Ikholam enoluhlu lweempendulo inikeza olo luhlu. Ibalwe iqulethe amaxabiso amalunga nawe, afana ne-currentUserEmail, ukwenzela iirekhodi endizifakileyo.
  4. Cofa Yongeza. Umthetho uya kwiqela elingezantsi.
  5. Yongeza eminye imithetho ngendlela efanayo. Kwaye igcina kuphela iirekhodi ezanelisa yonke imithetho; Okanye igcina ezo zanelisa nawuphi na omnye. Yongeza iqela iqalisa iqela ngaphakathi kweqela, ukwenzela (oku okanye okuya) kwaye nokunye, kwaye Yongeza umthetho apha ibeka umthetho kwelo qela. Umgqomo wenkunkuma ususa umthetho.
  6. Cofa Sebenzisa. Itafile, inani leerekhodi nemephu zonke ziyalandela.

Okungaxutywanga kubonisa isihluzi esifanayo njengentetho, intsimi nganye ibhalwe kwizibiyeli ezisisikwere ngegama layo kwidatabase, njengo-[zoning] = 'Residential 1'. Tshintsha nawuphi na umbono kwaye omnye uyalandela. Xa intetho ingaphezu koko iimenyu zeekholam zinokukubonisa (Okanye kwiikholam ezimbini, okanye iikholam ezimbini ezithelekiswayo), i-dialog iyakuxelela phambi kokuba usisebenzise, kwaye emva koko ibha yezixhobo ibonisa ithegi ethi Isihluzi esiphucukileyo. Isihluzi sisasetyenziswa ngokupheleleyo; vula i-dialog ukuze usibone sonke.

Ukusigcina njengesihluzi sakho ​

Uphawuluziso: ukuvula Isihluzi Esiphucukileyo kumgca wokukhangela, ukongeza umthetho Zoning = Residential 1, ukucofa Gcina Njengo, ukuchwetheza igama elithi Residential 1 erven nokucofa Gcina; ii-dialog ziyavalwa, Hluza Ngo ibonisa isihluzi esitsha esinomfanekiso womntu, kwaye itafile incitshiswa iye kwimigca ehambelanayo
Sakhe, Gcina Njengo, sinike igama
  1. Yakha isihluzi njengoko kuchaziwe ngasentla.
  2. Cofa Gcina Njengo endaweni ye-Sebenzisa.
  3. Chwetheza Igama lesihluzi uze ucofe Gcina.

Isihluzi sisetyenziswa kwangoko kwaye Hluza Ngo iyasibonisa, siphawulwe ngomfanekiso womntu. Igama osele ulisebenzisile kulo maleko lithatha indawo yeso sihluzi; i-dialog ikulumkisa kuqala: Isihluzi esinegama elinjalo sele sikhona kwaye siza kutshintshwa.

UmbuzoImpendulo
Ngubani onokusibona?Nguwe, nabalawuli bakho: i-Site Administrator ibona sonke isihluzi esigciniweyo, i-Account Administrator ibona ezo zabantu abakwiakhawunti yayo. Oogxa bakho abasiboni, kwaye indawo yokusebenza owabelana ngayo ayisidluliseli, de umlawuli asabelane naso neakhawunti.
Sinikwa phi?Kumaleko osigcine kuwo, ku-Hluza Ngo: phantsi komgca ongezantsi ko-Akukho sihluzi nazo naziphi na izihluzi ekwabelwana ngazo neakhawunti yakho, ngaphezu kwezihluzi zomaleko ngokwawo.
Ngaphezu kweakhawunti enye?Sesakho, asisosakhawunti. Sikhona kuloo maleko kuyo yonke iakhawunti apho izihluzi eziphucukileyo zivuliwe kuwe.
Ingaba singabonisa ngaphezu koko ndivumelekileyo ukukubona?Hayi. Sihlala sincitshisa kuphela iirekhodi osele uvumelekile ukuzibona.
Kuthekani ukuba izihluzi eziphucukileyo zicinywa kum kamva?Izihluzi zakho ezigciniweyo zaloo maleko ziyaphuma ku-Hluza Ngo. Azicinywa, kwaye ziyabuya xa izitshintshi zivulwa kwakhona.

Ukusebenzisa, ukutshintsha nokucima isihluzi esigciniweyo ​

Uluhlu lwe-Hluza Ngo luvulekile: Akukho sihluzi; isihluzi ekwabelwana ngaso neakhawunti, siphawulwe ngomfanekiso wabantu kwaye sikhethiwe; isihluzi sakho esigciniweyo, siphawulwe ngomfanekiso womntu; emva koko izihluzi ezimbini zomaleko ngokwawo, iqela ngalinye liphantsi komgca owahlulayo
Ekwabelwana ngazo neakhawunti (abantu), ezakho (umntu), emva koko izihluzi zomaleko ngokwawo
  • Ukusisebenzisa: sikhethe ku-Hluza Ngo. Akukho sihluzi siyasisusa kwakhona.
  • Ukusitshintsha: sikhethe, vula Isihluzi Esiphucukileyo, tshintsha imithetho, emva koko Gcina Njengo ngegama elifanayo. Ukuba ucofa Sebenzisa kutshintsho ngaphandle kokulugcina, Hluza Ngo ibuyela ku-Akukho sihluzi, kuba igama eligciniweyo alisachazi oko kusetyenzisiweyo; isihluzi esigciniweyo ngokwaso asitshintshi.
  • Ukusicima: sikhethe ku-Hluza Ngo, vula Isihluzi Esiphucukileyo uze ucofe Cima, emva koko uqinisekise. Iqhosha elithi Cima likhona kuphela xa sinye sezihluzi zakho ezigciniweyo sikhethiwe. Akunakubuyiselwa umva.
  • Kwindawo yokusebenza: indawo yokusebenza egciniweyo ikhumbula ukuba sesiphi kwizihluzi zakho ebesikhethiwe kumaleko ngamnye, kwaye isikhethe kwakhona xa uyivula. Isihluzi osele usicimile emva koko sishiywa ngaphandle nje.

Izihluzi ekwabelwana ngazo neakhawunti yakho ​

I-Site Administrator, okanye i-Account Administrator yakho, inokuthatha isihluzi esigcinwe ngumntu ize yabelane ngaso neakhawunti. Emva koko sivela ku-Hluza Ngo kuwo wonke umntu ongene kuloo akhawunti onokuvula umaleko, siphawulwe ngomfanekiso wabantu, ngaphezu kwezihluzi zabo bonke abantu ezizezabo.

  • Akudingi izitshintshi zeSihluzi Esiphucukileyo ukuze usisebenzise: ukusikhetha kuphela okufunekayo.
  • Sinokuzoba umaleko ngesimbo saso ngelixa sikhethiwe, njengoko izihluzi zomaleko ngokwawo zinokwenza.
  • Awunakusitshintsha okanye usicime, nokuba nguwe owasigcina kuqala. Abalawuli bakho bakwenza oko kumaleko, kwi-Iisetingi zemephu.
  • Ukwabelana kuyasihambisa isihluzi: xa esinye sezakho sabelwana ngaso, asisekho phakathi kwezakho (umfanekiso womntu) kodwa siphakathi kwezo kwabelwana ngazo (umfanekiso wabantu). Indawo yokusebenza ebisikhumbula isasikhetha.

Ukuthelekisa iikholam ezimbini ​

Uphawuluziso: kwi-Isihluzi Esiphucukileyo, ukucofa Area m², ukutshintsha i-operator ibe ngu-inkulu kune okanye ilingana no, ukutshintsha Ixabiso libe ngu-Enye intsimi, ukukhetha Title deed area, ukucofa Yongeza noSebenzisa; itafile igcina kuphela imigca apho indawo ingekho ngaphantsi kwe-title deed area, kwaye kuvela ithegi ethi Isihluzi esiphucukileyo
Ixabiso okanye Enye intsimi: thelekisa ikholam nenye ikholam yerekhodi enye

Ngamanye amaxesha umbuzo asingo "ngaphezu kwe-800" kodwa "ngaphezu kwale kholam yenye" - indawo elinganisiweyo ngokuchasene ne-title deed area, umhla wokuphela ngokuchasene nomhla wokuqala. Irekhodi nganye ijongwa ngokuchasene namaxabiso ayo.

  1. Vula Isihluzi Esiphucukileyo uze ucofe intsimi yokuqala, masithi Area m².
  2. Khetha enye yee-operator =, !=, >, >=, < okanye <=. Ileyibhile ethi Ixabiso ngaphezu kwebhokisi iba sisitshintshi: Ixabiso | Enye intsimi.
  3. Cofa Enye intsimi uze ukhethe intsimi yesibini kuluhlu (Khetha enye intsimi).
  4. Cofa Yongeza. Umthetho ufundeka ngolu hlobo: Area m² >= Title deed area; ku-Okungaxutywanga ngu-[area_m2] >= [title_area].
  5. Cofa Sebenzisa, okanye Gcina Njengo ukusigcina.

Oko ekufuneka ukwazi:

  • Kunikwa kuphela iintsimi zohlobo olufanayo: amanani namanani, imihla nemihla (umhla, nomhla nexesha, zibalwa njengohlobo olunye), umbhalo nombhalo, Ewe/Hayi ne-Ewe/Hayi. Xa umaleko ungenayo enye intsimi ehluzekayo yolo hlobo, isitshintshi asiveli.
  • Izithuba ezingenanto azisoze zihambelane. Irekhodi apho nokuba yeyiphi ikholam ingenanto iyashiywa ngaphandle, kwanange-!=. Ukuzigcina nazo, beka uthelekiso kwiqela le-Okanye elinomthetho othi Is Null kwikholam enokuba ingenanto.
  • Umbhalo kufuneka uhambelane ncam, oonobumba abakhulu nezithuba kubandakanyiwe: Main Road no-MAIN ROAD bahlukile apha, ngokungafaniyo nakwiibhokisi zokukhangela.
  • Iimenyu zeekholam azinakukubonisa. Ithegi ethi Isihluzi esiphucukileyo iyavela kwibha yezixhobo kwaye ii-funnel zeekholam zombini ziyakhanya. Vula Isihluzi Esiphucukileyo ukuze uyibone okanye uyitshintshe.
  • Uthelekiso ludibana neminye imithetho njengawo nawuphi na umthetho, kwaye imephu ibonisa iirekhodi ezifanayo nezo zisetafileni.

Imizekelo ​

Amagama eentsimi yimizekelo; umaleko wakho unawo awakhe.

UfunaUmthethoKu-Okungaxutywanga
Ii-erven ezinkulu kunoko kutshiwo yi-title deed yazoArea m² > Title deed area[area_m2] > [title_area]
Umsebenzi obhalwe njengogqityiweyo phambi kokuba uqaleEnd date < Start date[end_date] < [start_date]
Uhlolo olwenziwe emva komhla ebelufanele lwenziwe ngawoInspected > Due date[inspected] > [due_date]
Ufundo lwemitha olungaphantsi kolwangaphambiliReading < Previous reading[reading] < [prev_reading]
I-suburb yeposi eyahlukileyo kwi-suburbPostal suburb != Suburb[postal_suburb] != [suburb]
Inkulu kune-title deed, kwaye i-zoning yayo yi-Residential 1umthetho wokuqala, Kwaye Zoning = Residential 1[area_m2] > [title_area] AND [zoning] = 'Residential 1'
Edlulelwe lixesha, ngokuchasene nanamhlanje kunokuba kube nenye ikholamDue date < Namhlanje[due_date] < {today}

Ukuba kukho into ebonakala ingalunganga ​

Oko ukubonayoOko kudla ngokuthetha
Akukho bhokisi okanye i-funnel naphi naAkukho ntsimi yomaleko ephawulwe njengekhangelekayo. Buza umlawuli wakho.
Ibhokisi ithi no searchOlo hlobo lwentsimi alusoze luhluzwe (ifoto, isitywina, iphaswedi, i-geometry, i-binary).
Ibhokisi ithi value filter yaye ayichwetheziIkholam iphethe isihluzi soluhlu lokuphawula. Sicime kuqala kwi-funnel.
Imenyu ithi Loading… ixesha elideIkholam enkulu kakhulu engenayo i-index yale njongo. Iya kugqiba; chazela umlawuli wakho ngaloo kholam.
Too many different values to listIkholam ayinakubalwa yonke. Sebenzisa uluhlu lwee-operator.
No items match your searchUkukhangela kwakho ngaphakathi koluhlu lwamaxabiso akufumananga nto. Cima ibhokisi yokukhangela.
Filter not applied ivela njengomyalezoNokuba akukho maxabiso aphawuliweyo, okanye ucele "akukho namnye kwezi kodwa gcina ezingenanto", into ikholam enye engenakuyichaza.
Itafile ayinanto kodwa ubulindele imigcaJonga izitshintshi ze-Iyabonakala, Ekhetiweyo kunye ne-Engakhange iqheliswe kunye noluhlu lwe-Hluza Ngo - zincitshisa itafile phambi kwezihluzi zakho zeekholam.
Amanani abonakala emancinci kakhuluNgamanani angaphakathi koko itafile ikubonisayo, ngoko isitshintshi sobubanzi okanye isihluzi senye ikholam siyasebenza.
Akukho qhosha lesihluzi esiphucukileyo, akukho Gcina Njengo, okanye izihluzi zam ezigciniweyo zimkile ku-Hluza NgoIzihluzi eziphucukileyo azivulwanga kwi-role yakho kulo maleko. Jonga izitshintshi; buza umlawuli wakho.
Esinye sezihluzi zam ezigciniweyo ngoku sinomfanekiso wabantu, kwaye andikwazi ukusicimaUmlawuli wabelane ngaso neakhawunti yakho. Ngoku sesakhawunti; jonga Izihluzi ekwabelwana ngazo neakhawunti yakho.
Akukho sitshintshi esithi Ixabiso | Enye intsimiI-operator ayisiyo enye ye-=, !=, >, >=, <, <=, okanye umaleko awunayo enye intsimi ehluzekayo yohlobo olufanayo.
Uthelekiso lweekholam ezimbini lushiya ngaphandle iirekhodi ebendizilindeleEnye yeekholam ezimbini ayinanto kwezo rekhodi, okanye (kumbhalo) oonobumba abakhulu okanye izithuba ziyahluka.

Jonga nako ​

  • Itafile Yedata - konke okunye kwetafile: ibha yezixhobo, iikholam, izenzo zomgca, uhlelo
  • Ukukhangela - ibhokisi yokukhangela yebha yezixhobo nokukhangela kwimephu
  • Ukhetho Lweempawu - indlela isitshintshi se-Ekhetiweyo esifumana ngayo iirekhodi zaso
  • Iindawo Zokusebenza - ukugcina imaleko noseto osebenza ngazo

1map provides organisations with specialised visualisation tools and data systems. By showing users their data within the context of the real-world, decision-makers get the information they need to make fast and effective decisions that will take their organisations to new heights.