select records from tblanlageoderstudie — kuras_anlageoderstudie • kwb.kuras.db

select and filter records from tblanlageoderstudie

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`