Skip to contents

select records from tblindikator

Source: R/kurasDbInterface.R
kuras_indikator.Rd

select and filter records from tblindikator

Usage

kuras_indikator(
  where = NULL,
  where_iID = NA,
  where_iEffektID = NA,
  where_iName = NA,
  where_iEinheit = NA,
  where_iBeschreibung = NA,
  where_iAngelegtAm = NA,
  where_iAngelegtVonPersonID = NA,
  where_iGeaendert = NA,
  select = NULL,
  select_iID = NA,
  select_iEffektID = NA,
  select_iName = NA,
  select_iEinheit = NA,
  select_iBeschreibung = NA,
  select_iAngelegtAm = NA,
  select_iAngelegtVonPersonID = NA,
  select_iGeaendert = NA,
  orderBy = NULL,
  orderBy_iID = NA,
  orderBy_iEffektID = NA,
  orderBy_iName = NA,
  orderBy_iEinheit = NA,
  orderBy_iBeschreibung = NA,
  orderBy_iAngelegtAm = NA,
  orderBy_iAngelegtVonPersonID = NA,
  orderBy_iGeaendert = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_iID

condition for field iID: Enter a field description here

where_iEffektID

condition for field iEffektID: Enter a field description here

where_iName

condition for field iName: Enter a field description here

where_iEinheit

condition for field iEinheit: Enter a field description here

where_iBeschreibung

condition for field iBeschreibung: Enter a field description here

where_iAngelegtAm

condition for field iAngelegtAm: Enter a field description here

where_iAngelegtVonPersonID

condition for field iAngelegtVonPersonID: Enter a field description here

where_iGeaendert

condition for field iGeaendert: Enter a field description here

select

fields/expressions to select

select_iID

select field iID?

select_iEffektID

select field iEffektID?

select_iName

select field iName?

select_iEinheit

select field iEinheit?

select_iBeschreibung

select field iBeschreibung?

select_iAngelegtAm

select field iAngelegtAm?

select_iAngelegtVonPersonID

select field iAngelegtVonPersonID?

select_iGeaendert

select field iGeaendert?

orderBy

ORDER BY clause of SQL expression

orderBy_iID

order by field iID?

orderBy_iEffektID

order by field iEffektID?

orderBy_iName

order by field iName?

orderBy_iEinheit

order by field iEinheit?

orderBy_iBeschreibung

order by field iBeschreibung?

orderBy_iAngelegtAm

order by field iAngelegtAm?

orderBy_iAngelegtVonPersonID

order by field iAngelegtVonPersonID?

orderBy_iGeaendert

order by field iGeaendert?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable