select records from tblindikatorwert

Source: R/kurasDbInterface.R

select and filter records from tblindikatorwert

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