Skip to contents

select records from tblindikatorwert

Source: R/kurasDbInterface.R
kuras_indikatorwert.Rd

select and filter records from tblindikatorwert

Usage

kuras_indikatorwert(
  where = NULL,
  where_iwID = NA,
  where_iwAnlageID = NA,
  where_iwIndikatorID = NA,
  where_iwReferenzGruppeID = NA,
  where_iwMittelwert = NA,
  where_iwMinWert = NA,
  where_iwMaxWert = NA,
  where_iwMedian = NA,
  where_iwStandardabweichung = NA,
  where_iwAnzahlWerte = NA,
  where_iwZeitbezugBeginn = NA,
  where_iwZeitbezugEnde = NA,
  where_iwErhebungsmethode = NA,
  select = NULL,
  select_iwID = NA,
  select_iwAnlageID = NA,
  select_iwIndikatorID = NA,
  select_iwReferenzGruppeID = NA,
  select_iwMittelwert = NA,
  select_iwMinWert = NA,
  select_iwMaxWert = NA,
  select_iwMedian = NA,
  select_iwStandardabweichung = NA,
  select_iwAnzahlWerte = NA,
  select_iwZeitbezugBeginn = NA,
  select_iwZeitbezugEnde = NA,
  select_iwErhebungsmethode = NA,
  orderBy = NULL,
  orderBy_iwID = NA,
  orderBy_iwAnlageID = NA,
  orderBy_iwIndikatorID = NA,
  orderBy_iwReferenzGruppeID = NA,
  orderBy_iwMittelwert = NA,
  orderBy_iwMinWert = NA,
  orderBy_iwMaxWert = NA,
  orderBy_iwMedian = NA,
  orderBy_iwStandardabweichung = NA,
  orderBy_iwAnzahlWerte = NA,
  orderBy_iwZeitbezugBeginn = NA,
  orderBy_iwZeitbezugEnde = NA,
  orderBy_iwErhebungsmethode = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_iwID

condition for field iwID: Enter a field description here

where_iwAnlageID

condition for field iwAnlageID: Enter a field description here

where_iwIndikatorID

condition for field iwIndikatorID: Enter a field description here

where_iwReferenzGruppeID

condition for field iwReferenzGruppeID: Enter a field description here

where_iwMittelwert

condition for field iwMittelwert: Enter a field description here

where_iwMinWert

condition for field iwMinWert: Enter a field description here

where_iwMaxWert

condition for field iwMaxWert: Enter a field description here

where_iwMedian

condition for field iwMedian: Enter a field description here

where_iwStandardabweichung

condition for field iwStandardabweichung: Enter a field description here

where_iwAnzahlWerte

condition for field iwAnzahlWerte: Enter a field description here

where_iwZeitbezugBeginn

condition for field iwZeitbezugBeginn: Enter a field description here

where_iwZeitbezugEnde

condition for field iwZeitbezugEnde: Enter a field description here

where_iwErhebungsmethode

condition for field iwErhebungsmethode: Enter a field description here

select

fields/expressions to select

select_iwID

select field iwID?

select_iwAnlageID

select field iwAnlageID?

select_iwIndikatorID

select field iwIndikatorID?

select_iwReferenzGruppeID

select field iwReferenzGruppeID?

select_iwMittelwert

select field iwMittelwert?

select_iwMinWert

select field iwMinWert?

select_iwMaxWert

select field iwMaxWert?

select_iwMedian

select field iwMedian?

select_iwStandardabweichung

select field iwStandardabweichung?

select_iwAnzahlWerte

select field iwAnzahlWerte?

select_iwZeitbezugBeginn

select field iwZeitbezugBeginn?

select_iwZeitbezugEnde

select field iwZeitbezugEnde?

select_iwErhebungsmethode

select field iwErhebungsmethode?

orderBy

ORDER BY clause of SQL expression

orderBy_iwID

order by field iwID?

orderBy_iwAnlageID

order by field iwAnlageID?

orderBy_iwIndikatorID

order by field iwIndikatorID?

orderBy_iwReferenzGruppeID

order by field iwReferenzGruppeID?

orderBy_iwMittelwert

order by field iwMittelwert?

orderBy_iwMinWert

order by field iwMinWert?

orderBy_iwMaxWert

order by field iwMaxWert?

orderBy_iwMedian

order by field iwMedian?

orderBy_iwStandardabweichung

order by field iwStandardabweichung?

orderBy_iwAnzahlWerte

order by field iwAnzahlWerte?

orderBy_iwZeitbezugBeginn

order by field iwZeitbezugBeginn?

orderBy_iwZeitbezugEnde

order by field iwZeitbezugEnde?

orderBy_iwErhebungsmethode

order by field iwErhebungsmethode?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable