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