Skip to contents

select and filter records from tblanlageoderstudie

Usage

kuras_anlageoderstudie(
  where = NULL,
  where_aID = NA,
  where_aName = NA,
  where_aMassnahmenTypID = NA,
  where_aMassnahmenEbeneID = NA,
  where_aStandortID = NA,
  where_aAdresse = NA,
  where_aKoordinateX = NA,
  where_aKoordinateY = NA,
  where_aEntwaesserungssystem = NA,
  where_aBetreiberInstitutionID = NA,
  where_aInbetriebnahme = NA,
  where_aAusserbetriebnahme = NA,
  where_aBetriebsweise = NA,
  where_aBeschreibung = NA,
  where_aProjektID = NA,
  where_aFotoOrdner = NA,
  where_aDokumentOrdner = NA,
  where_aAngelegtAm = NA,
  where_aAngelegtVonPersonID = NA,
  where_aGeaendert = NA,
  where_aKoordinatensystem = NA,
  where_aReferenzGruppeID = NA,
  where_aIstStudie = NA,
  select = NULL,
  select_aID = NA,
  select_aName = NA,
  select_aMassnahmenTypID = NA,
  select_aMassnahmenEbeneID = NA,
  select_aStandortID = NA,
  select_aAdresse = NA,
  select_aKoordinateX = NA,
  select_aKoordinateY = NA,
  select_aEntwaesserungssystem = NA,
  select_aBetreiberInstitutionID = NA,
  select_aInbetriebnahme = NA,
  select_aAusserbetriebnahme = NA,
  select_aBetriebsweise = NA,
  select_aBeschreibung = NA,
  select_aProjektID = NA,
  select_aFotoOrdner = NA,
  select_aDokumentOrdner = NA,
  select_aAngelegtAm = NA,
  select_aAngelegtVonPersonID = NA,
  select_aGeaendert = NA,
  select_aKoordinatensystem = NA,
  select_aReferenzGruppeID = NA,
  select_aIstStudie = NA,
  orderBy = NULL,
  orderBy_aID = NA,
  orderBy_aName = NA,
  orderBy_aMassnahmenTypID = NA,
  orderBy_aMassnahmenEbeneID = NA,
  orderBy_aStandortID = NA,
  orderBy_aAdresse = NA,
  orderBy_aKoordinateX = NA,
  orderBy_aKoordinateY = NA,
  orderBy_aEntwaesserungssystem = NA,
  orderBy_aBetreiberInstitutionID = NA,
  orderBy_aInbetriebnahme = NA,
  orderBy_aAusserbetriebnahme = NA,
  orderBy_aBetriebsweise = NA,
  orderBy_aBeschreibung = NA,
  orderBy_aProjektID = NA,
  orderBy_aFotoOrdner = NA,
  orderBy_aDokumentOrdner = NA,
  orderBy_aAngelegtAm = NA,
  orderBy_aAngelegtVonPersonID = NA,
  orderBy_aGeaendert = NA,
  orderBy_aKoordinatensystem = NA,
  orderBy_aReferenzGruppeID = NA,
  orderBy_aIstStudie = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_aID

condition for field aID: Enter a field description here

where_aName

condition for field aName: Enter a field description here

where_aMassnahmenTypID

condition for field aMassnahmenTypID: Enter a field description here

where_aMassnahmenEbeneID

condition for field aMassnahmenEbeneID: Enter a field description here

where_aStandortID

condition for field aStandortID: Enter a field description here

where_aAdresse

condition for field aAdresse: Enter a field description here

where_aKoordinateX

condition for field aKoordinateX: Enter a field description here

where_aKoordinateY

condition for field aKoordinateY: Enter a field description here

where_aEntwaesserungssystem

condition for field aEntwaesserungssystem: Enter a field description here

where_aBetreiberInstitutionID

condition for field aBetreiberInstitutionID: Enter a field description here

where_aInbetriebnahme

condition for field aInbetriebnahme: Enter a field description here

where_aAusserbetriebnahme

condition for field aAusserbetriebnahme: Enter a field description here

where_aBetriebsweise

condition for field aBetriebsweise: Enter a field description here

where_aBeschreibung

condition for field aBeschreibung: Enter a field description here

where_aProjektID

condition for field aProjektID: Enter a field description here

where_aFotoOrdner

condition for field aFotoOrdner: Enter a field description here

where_aDokumentOrdner

condition for field aDokumentOrdner: Enter a field description here

where_aAngelegtAm

condition for field aAngelegtAm: Enter a field description here

where_aAngelegtVonPersonID

condition for field aAngelegtVonPersonID: Enter a field description here

where_aGeaendert

condition for field aGeaendert: Enter a field description here

where_aKoordinatensystem

condition for field aKoordinatensystem: Enter a field description here

where_aReferenzGruppeID

condition for field aReferenzGruppeID: Enter a field description here

where_aIstStudie

condition for field aIstStudie: Enter a field description here

select

fields/expressions to select

select_aID

select field aID?

select_aName

select field aName?

select_aMassnahmenTypID

select field aMassnahmenTypID?

select_aMassnahmenEbeneID

select field aMassnahmenEbeneID?

select_aStandortID

select field aStandortID?

select_aAdresse

select field aAdresse?

select_aKoordinateX

select field aKoordinateX?

select_aKoordinateY

select field aKoordinateY?

select_aEntwaesserungssystem

select field aEntwaesserungssystem?

select_aBetreiberInstitutionID

select field aBetreiberInstitutionID?

select_aInbetriebnahme

select field aInbetriebnahme?

select_aAusserbetriebnahme

select field aAusserbetriebnahme?

select_aBetriebsweise

select field aBetriebsweise?

select_aBeschreibung

select field aBeschreibung?

select_aProjektID

select field aProjektID?

select_aFotoOrdner

select field aFotoOrdner?

select_aDokumentOrdner

select field aDokumentOrdner?

select_aAngelegtAm

select field aAngelegtAm?

select_aAngelegtVonPersonID

select field aAngelegtVonPersonID?

select_aGeaendert

select field aGeaendert?

select_aKoordinatensystem

select field aKoordinatensystem?

select_aReferenzGruppeID

select field aReferenzGruppeID?

select_aIstStudie

select field aIstStudie?

orderBy

ORDER BY clause of SQL expression

orderBy_aID

order by field aID?

orderBy_aName

order by field aName?

orderBy_aMassnahmenTypID

order by field aMassnahmenTypID?

orderBy_aMassnahmenEbeneID

order by field aMassnahmenEbeneID?

orderBy_aStandortID

order by field aStandortID?

orderBy_aAdresse

order by field aAdresse?

orderBy_aKoordinateX

order by field aKoordinateX?

orderBy_aKoordinateY

order by field aKoordinateY?

orderBy_aEntwaesserungssystem

order by field aEntwaesserungssystem?

orderBy_aBetreiberInstitutionID

order by field aBetreiberInstitutionID?

orderBy_aInbetriebnahme

order by field aInbetriebnahme?

orderBy_aAusserbetriebnahme

order by field aAusserbetriebnahme?

orderBy_aBetriebsweise

order by field aBetriebsweise?

orderBy_aBeschreibung

order by field aBeschreibung?

orderBy_aProjektID

order by field aProjektID?

orderBy_aFotoOrdner

order by field aFotoOrdner?

orderBy_aDokumentOrdner

order by field aDokumentOrdner?

orderBy_aAngelegtAm

order by field aAngelegtAm?

orderBy_aAngelegtVonPersonID

order by field aAngelegtVonPersonID?

orderBy_aGeaendert

order by field aGeaendert?

orderBy_aKoordinatensystem

order by field aKoordinatensystem?

orderBy_aReferenzGruppeID

order by field aReferenzGruppeID?

orderBy_aIstStudie

order by field aIstStudie?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable