Search by property

This page provides a simple browsing interface for finding entities described by a property and a named value. Other available search interfaces include the page property search, and the ask query builder.

List of results

• dwbST010015:Term.TermID  + (en:ID of the term, Primary key)
• dwbST:TermProperty.TermID  + (en:ID of the term, referes to table Term, Foreign key)
• dwbST:TermReference.RepresentationID  + (en:ID of the term, referes to table TermRepresentation, Foreign key)
• dwbST:TermResource.RepresentationID  + (en:ID of the term, referes to table TermRepresentation, Foreign key)
• dwbST010015:TermProperty.TermID  + (en:ID of the term, refers to table Term (foreign key))
• dwbST010015:TermReference.RepresentationID  + (en:ID of the term, refers to table TermRepresentation (foreign key))
• dwbST010015:TermResource.RepresentationID  + (en:ID of the term, refers to table TermRepresentation, Foreign key)
• dwbG:UserProxy.ID  + (en:ID of the user)
• dwbA020123:UserProxy.ID  + (en:ID of the user)
• dwbST010015:Section.LogInsertedBy  + (en:ID of user who first entered (typed or imported) the recorde into this system. This is the operator (or typist) name, which may be different from the person responsible.<br />''DefaultValue: [dbo].[UserID]() '')
• dwbST010015:SectionTerm.LogInsertedBy  + (en:ID of user who first entered (typed or imported) the recorde into this system. This is the operator (or typist) name, which may be different from the person responsible.<br />''DefaultValue: [dbo].[UserID]() '')
• dwbST010015:Section.LogUpdatedBy  + (en:ID of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.<br />''DefaultValue: [dbo].[UserID]() '')
• dwbST010015:SectionTerm.LogUpdatedBy  + (en:ID of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.<br />''DefaultValue: [dbo].[UserID]() '')
• dwbTN:TaxonCommonName.NameID  + (en:ID taxonomic name. Refers to the column NameID of the table TaxonName (= foreign key).)
• dwbA020123:AgentIdentifier.Identifier  + (en:Identifier for the agent, part of PK)
• dwbA020123:AgentHierarchyOther.HierarchyID  + (en:Identifier of the hierarchy, part of PK)
• dwbTN:TaxonName.HybridNameID4  + (en:If IsHybrid is checked (or 'True'): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key).)
• dwbTN:TaxonName.HybridNameID1  + (en:If IsHybrid is checked (or 'True'): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key).)
• dwbTN:TaxonName.HybridNameID3  + (en:If IsHybrid is checked (or 'True'): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key).)
• dwbTN:TaxonName.HybridNameID2  + (en:If IsHybrid is checked (or 'True'): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key).)
• dwbC:Method.ForCollectionEvent  + (en:If a method may be used during a collection event)
• dwbP:ProjectReference.IsCitation  + (en:If a reference is the citation for the project data, i.e. the way the project data should be cited<br />''DefaultValue: (0) '')
• dwbC:IdentificationUnit.ColonisedSubstratePart  + (en:If a substrate association exists: part of the substrate which is affected in the interaction (e.g. 'leaves', if a fungus is growing on the leaves of an infected plant))
• dwbA020123:ProjectProxy.CreateArchive  + (en:If an archive e.g. by a task schedule should be created)
• dwbTN:TaxonName.IsHybrid  + (en:If checked (or 'True'), the new taxon is a hybrid with or without a hybrid epithet.<br />''DefaultValue: (0) '')

• dwbC:CollectionSpecimenImageProperty.Description  + (en:If description of the property of the image)

• dwbC:CollectionSpecimenPart.StockUnit  + (en:If empty, the stock is given as a count, else it contains the unit in which stock is expressed, e.g. µl, ml, kg etc.)
• dwbC:Identification.TypeStatus  + (en:If identification unit is type of a taxonomic name: holotype, syntype, etc. (= foreign key, see table CollTypeStatus_Enum))
• dwbC:CollectionSpecimenImage.IdentificationUnitID  + (en:If image refers to only one out of several IdentificationUnits for a specimen, refers to the ID of an IdentificationUnit for a collection specimen (= foreign key))
• dwbR:ReferencePeriodical.ImportedFrom  + (en:If imported from another database: The name of the database system or provider; otherwise empty.)
• dwbTN:TaxonName.InfragenericEpithet  + (en:If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc.)
• dwbTN:TaxonName.GenusOrSupragenericName  + (en:If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.)
• dwbTN:TaxonName.SpeciesGenusNameID  + (en:If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus.)
• dwbC:CollectionSpecimenReference.IdentificationUnitID  + (en:If relation refers to a certain organism within a specimen, the ID of an IdentificationUnit (= foreign key))
• dwbC:CollectionSpecimenRelation.IdentificationUnitID  + (en:If relation refers to a certain organism within a specimen, the ID of an IdentificationUnit (= foreign key))
• dwbC:IdentificationUnit.ExsiccataNumber  + (en:If specimen is an exsiccata: Number of current specimen within the exsiccata series)
• dwbC:CollectionSpecimen.ExsiccataAbbreviation  + (en:If specimen is an exsiccata: Standard abbreviation of the exsiccata (not necessarily a unique identifier; editors or publication places may change over time))
• dwbC:CollectionSpecimen.ExsiccataURI  + (en:If specimen is an exsiccata: The URI of the exsiccata series, e.g. as stored within the DiversityExsiccata module)
• dwbTN:TaxonName.PublishingAuthors  + (en:If the authors of the taxon differ from the authors of the publication: the latter (...'in ' Publishing authors ... ))
• dwbC:CollectionSpecimen.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null<br />''DefaultValue: N'Withold by default' '')
• dwbC:CollectionAgent.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null)
• dwbC:CollectionEvent.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null)
• dwbC:CollectionEventImage.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null)
• dwbC:CollectionEventSeriesImage.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null)
• dwbC:CollectionImage.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null)
• dwbC:CollectionSpecimenImage.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null)
• dwbC:IdentificationUnit.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null)
• dwbST010015:TermResource.DataWithholdingReason  + (en:If the data set is withhold, the reason for withholding the data, otherwise null)
• dwbA020123:ProjectProxy.IsLocked  + (en:If the data within the project should not be changeed and the access for all users is restricted to read only)
• dwbA:Agent.DataWithholdingReason  + (en:If the dataset is withhold, the reason for withholding the data, otherwise null)
• dwbA:AgentRelation.DataWithholdingReason  + (en:If the dataset is withhold, the reason for withholding the data, otherwise null)