Package 'kwb.kuras.db'

Anzahl an Indikatoren pro Effekt

Description

Anzahl an Indikatoren pro Effekt

Usage

anzahlIndikatorenProEffekt(
  indikatoren = kuras_indikator(),
  effekte = kuras_effekt()
)

Arguments

indikatoren	data frame as returned by kuras_indikator
effekte	data frame as returned by kuras_effekt

Value

data frame mit Spalten eID (Effekt-ID), eName (Effekt-Name), x (Anzahl Indikatoren fuer den Effekt).

---

Anzahl an Werten pro Indikator

Description

Anzahl an Werten pro Indikator

Usage

anzahlWerteProIndikator(
  effekte = kuras_effekt(),
  indikatoren = kuras_indikator(),
  indikatorwerte = kuras_indikatorwert()
)

Arguments

effekte	data frame as returned by kuras_effekt
indikatoren	data frame as returned by kuras_indikator
indikatorwerte	data frame as returned by kuras_indikatorwert

Value

data frame mit Spalten iID (Indikator-ID), iEffektID (Effekt-ID),iName (Indikator-Name), x (Anzahl Werte fuer den Indikator).

---

Beispiel-Auswertung 1

Description

Beispielauswertung 1: Anzahl Indikatoren je Effekt und Anzahl Literaturwerte je Indikator

Usage

beispielAuswertung.1()

---

select records from tblanlageeigenschaft

Description

select and filter records from tblanlageeigenschaft

Usage

kuras_anlageeigenschaft(
  where = NULL,
  where_aeID = NA,
  where_aeName = NA,
  where_aeEinheit = NA,
  where_aeBeschreibung = NA,
  select = NULL,
  select_aeID = NA,
  select_aeName = NA,
  select_aeEinheit = NA,
  select_aeBeschreibung = NA,
  orderBy = NULL,
  orderBy_aeID = NA,
  orderBy_aeName = NA,
  orderBy_aeEinheit = NA,
  orderBy_aeBeschreibung = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_aeID	condition for field aeID: Enter a field description here
where_aeName	condition for field aeName: Enter a field description here
where_aeEinheit	condition for field aeEinheit: Enter a field description here
where_aeBeschreibung	condition for field aeBeschreibung: Enter a field description here
select	fields/expressions to select
select_aeID	select field aeID?
select_aeName	select field aeName?
select_aeEinheit	select field aeEinheit?
select_aeBeschreibung	select field aeBeschreibung?
orderBy	ORDER BY clause of SQL expression
orderBy_aeID	order by field aeID?
orderBy_aeName	order by field aeName?
orderBy_aeEinheit	order by field aeEinheit?
orderBy_aeBeschreibung	order by field aeBeschreibung?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblanlageeigenschaftswert

Description

select and filter records from tblanlageeigenschaftswert

Usage

kuras_anlageeigenschaftswert(
  where = NULL,
  where_awID = NA,
  where_awAnlageID = NA,
  where_awAnlageEigenschaftID = NA,
  where_awZahlwert = NA,
  where_awBeschreibung = NA,
  select = NULL,
  select_awID = NA,
  select_awAnlageID = NA,
  select_awAnlageEigenschaftID = NA,
  select_awZahlwert = NA,
  select_awBeschreibung = NA,
  orderBy = NULL,
  orderBy_awID = NA,
  orderBy_awAnlageID = NA,
  orderBy_awAnlageEigenschaftID = NA,
  orderBy_awZahlwert = NA,
  orderBy_awBeschreibung = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_awID	condition for field awID: Enter a field description here
where_awAnlageID	condition for field awAnlageID: Enter a field description here
where_awAnlageEigenschaftID	condition for field awAnlageEigenschaftID: Enter a field description here
where_awZahlwert	condition for field awZahlwert: Enter a field description here
where_awBeschreibung	condition for field awBeschreibung: Enter a field description here
select	fields/expressions to select
select_awID	select field awID?
select_awAnlageID	select field awAnlageID?
select_awAnlageEigenschaftID	select field awAnlageEigenschaftID?
select_awZahlwert	select field awZahlwert?
select_awBeschreibung	select field awBeschreibung?
orderBy	ORDER BY clause of SQL expression
orderBy_awID	order by field awID?
orderBy_awAnlageID	order by field awAnlageID?
orderBy_awAnlageEigenschaftID	order by field awAnlageEigenschaftID?
orderBy_awZahlwert	order by field awZahlwert?
orderBy_awBeschreibung	order by field awBeschreibung?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblanlageoderstudie

Description

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

---

KURAS Auswertung

Description

KURAS Auswertung

Usage

kuras_auswertung(
  effekte = kuras_effekt(stringsAsFactors = FALSE),
  indikatoren = kuras_indikator(stringsAsFactors = FALSE),
  indikatorwerte = kuras_indikatorwert(stringsAsFactors = FALSE)
)

Arguments

effekte	data frame as returned by kuras_effekt
indikatoren	data frame as returned by kuras_indikator
indikatorwerte	data frame as returned by kuras_indikatorwert

---

select records from tbleffekt

Description

select and filter records from tbleffekt

Usage

kuras_effekt(
  where = NULL,
  where_eID = NA,
  where_eName = NA,
  where_eBeschreibung = NA,
  select = NULL,
  select_eID = NA,
  select_eName = NA,
  select_eBeschreibung = NA,
  orderBy = NULL,
  orderBy_eID = NA,
  orderBy_eName = NA,
  orderBy_eBeschreibung = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_eID	condition for field eID: Enter a field description here
where_eName	condition for field eName: Enter a field description here
where_eBeschreibung	condition for field eBeschreibung: Enter a field description here
select	fields/expressions to select
select_eID	select field eID?
select_eName	select field eName?
select_eBeschreibung	select field eBeschreibung?
orderBy	ORDER BY clause of SQL expression
orderBy_eID	order by field eID?
orderBy_eName	order by field eName?
orderBy_eBeschreibung	order by field eBeschreibung?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblindikator

Description

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

---

select records from tblindikatorwert

Description

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

---

select records from tblinstitution

Description

select and filter records from tblinstitution

Usage

kuras_institution(
  where = NULL,
  where_inID = NA,
  where_inName = NA,
  where_inKurzname = NA,
  where_inAdresse = NA,
  where_inBeschreibung = NA,
  select = NULL,
  select_inID = NA,
  select_inName = NA,
  select_inKurzname = NA,
  select_inAdresse = NA,
  select_inBeschreibung = NA,
  orderBy = NULL,
  orderBy_inID = NA,
  orderBy_inName = NA,
  orderBy_inKurzname = NA,
  orderBy_inAdresse = NA,
  orderBy_inBeschreibung = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_inID	condition for field inID: Enter a field description here
where_inName	condition for field inName: Enter a field description here
where_inKurzname	condition for field inKurzname: Enter a field description here
where_inAdresse	condition for field inAdresse: Enter a field description here
where_inBeschreibung	condition for field inBeschreibung: Enter a field description here
select	fields/expressions to select
select_inID	select field inID?
select_inName	select field inName?
select_inKurzname	select field inKurzname?
select_inAdresse	select field inAdresse?
select_inBeschreibung	select field inBeschreibung?
orderBy	ORDER BY clause of SQL expression
orderBy_inID	order by field inID?
orderBy_inName	order by field inName?
orderBy_inKurzname	order by field inKurzname?
orderBy_inAdresse	order by field inAdresse?
orderBy_inBeschreibung	order by field inBeschreibung?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblkommentar

Description

select and filter records from tblkommentar

Usage

kuras_kommentar(
  where = NULL,
  where_kID = NA,
  where_kPersonID = NA,
  where_kDatum = NA,
  where_kBezugstabelle = NA,
  where_kDatensatzID = NA,
  where_kKommentar = NA,
  select = NULL,
  select_kID = NA,
  select_kPersonID = NA,
  select_kDatum = NA,
  select_kBezugstabelle = NA,
  select_kDatensatzID = NA,
  select_kKommentar = NA,
  orderBy = NULL,
  orderBy_kID = NA,
  orderBy_kPersonID = NA,
  orderBy_kDatum = NA,
  orderBy_kBezugstabelle = NA,
  orderBy_kDatensatzID = NA,
  orderBy_kKommentar = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_kID	condition for field kID: Enter a field description here
where_kPersonID	condition for field kPersonID: Enter a field description here
where_kDatum	condition for field kDatum: Enter a field description here
where_kBezugstabelle	condition for field kBezugstabelle: Enter a field description here
where_kDatensatzID	condition for field kDatensatzID: Enter a field description here
where_kKommentar	condition for field kKommentar: Enter a field description here
select	fields/expressions to select
select_kID	select field kID?
select_kPersonID	select field kPersonID?
select_kDatum	select field kDatum?
select_kBezugstabelle	select field kBezugstabelle?
select_kDatensatzID	select field kDatensatzID?
select_kKommentar	select field kKommentar?
orderBy	ORDER BY clause of SQL expression
orderBy_kID	order by field kID?
orderBy_kPersonID	order by field kPersonID?
orderBy_kDatum	order by field kDatum?
orderBy_kBezugstabelle	order by field kBezugstabelle?
orderBy_kDatensatzID	order by field kDatensatzID?
orderBy_kKommentar	order by field kKommentar?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblkoordinatensystem

Description

select and filter records from tblkoordinatensystem

Usage

kuras_koordinatensystem(
  where = NULL,
  where_koID = NA,
  where_koName = NA,
  select = NULL,
  select_koID = NA,
  select_koName = NA,
  orderBy = NULL,
  orderBy_koID = NA,
  orderBy_koName = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_koID	condition for field koID: Enter a field description here
where_koName	condition for field koName: Enter a field description here
select	fields/expressions to select
select_koID	select field koID?
select_koName	select field koName?
orderBy	ORDER BY clause of SQL expression
orderBy_koID	order by field koID?
orderBy_koName	order by field koName?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblmassnahmeebene

Description

select and filter records from tblmassnahmeebene

Usage

kuras_massnahmeebene(
  where = NULL,
  where_meID = NA,
  where_meName = NA,
  where_meBeschreibung = NA,
  select = NULL,
  select_meID = NA,
  select_meName = NA,
  select_meBeschreibung = NA,
  orderBy = NULL,
  orderBy_meID = NA,
  orderBy_meName = NA,
  orderBy_meBeschreibung = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_meID	condition for field meID: Enter a field description here
where_meName	condition for field meName: Enter a field description here
where_meBeschreibung	condition for field meBeschreibung: Enter a field description here
select	fields/expressions to select
select_meID	select field meID?
select_meName	select field meName?
select_meBeschreibung	select field meBeschreibung?
orderBy	ORDER BY clause of SQL expression
orderBy_meID	order by field meID?
orderBy_meName	order by field meName?
orderBy_meBeschreibung	order by field meBeschreibung?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblmassnahmenkategorie

Description

select and filter records from tblmassnahmenkategorie

Usage

kuras_massnahmenkategorie(
  where = NULL,
  where_mkID = NA,
  where_mkName = NA,
  select = NULL,
  select_mkID = NA,
  select_mkName = NA,
  orderBy = NULL,
  orderBy_mkID = NA,
  orderBy_mkName = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_mkID	condition for field mkID: Enter a field description here
where_mkName	condition for field mkName: Enter a field description here
select	fields/expressions to select
select_mkID	select field mkID?
select_mkName	select field mkName?
orderBy	ORDER BY clause of SQL expression
orderBy_mkID	order by field mkID?
orderBy_mkName	order by field mkName?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblmassnahmetyp

Description

select and filter records from tblmassnahmetyp

Usage

kuras_massnahmetyp(
  where = NULL,
  where_mID = NA,
  where_mName = NA,
  where_mBeschreibung = NA,
  where_mMassnahmenKategorieID = NA,
  select = NULL,
  select_mID = NA,
  select_mName = NA,
  select_mBeschreibung = NA,
  select_mMassnahmenKategorieID = NA,
  orderBy = NULL,
  orderBy_mID = NA,
  orderBy_mName = NA,
  orderBy_mBeschreibung = NA,
  orderBy_mMassnahmenKategorieID = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_mID	condition for field mID: Enter a field description here
where_mName	condition for field mName: Enter a field description here
where_mBeschreibung	condition for field mBeschreibung: Enter a field description here
where_mMassnahmenKategorieID	condition for field mMassnahmenKategorieID: Enter a field description here
select	fields/expressions to select
select_mID	select field mID?
select_mName	select field mName?
select_mBeschreibung	select field mBeschreibung?
select_mMassnahmenKategorieID	select field mMassnahmenKategorieID?
orderBy	ORDER BY clause of SQL expression
orderBy_mID	order by field mID?
orderBy_mName	order by field mName?
orderBy_mBeschreibung	order by field mBeschreibung?
orderBy_mMassnahmenKategorieID	order by field mMassnahmenKategorieID?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblperson

Description

select and filter records from tblperson

Usage

kuras_person(
  where = NULL,
  where_pnID = NA,
  where_pnInitialien = NA,
  where_pnVorname = NA,
  where_pnNachname = NA,
  where_pnInstitutionID = NA,
  where_pnAdresse = NA,
  where_pnTelefon = NA,
  select = NULL,
  select_pnID = NA,
  select_pnInitialien = NA,
  select_pnVorname = NA,
  select_pnNachname = NA,
  select_pnInstitutionID = NA,
  select_pnAdresse = NA,
  select_pnTelefon = NA,
  orderBy = NULL,
  orderBy_pnID = NA,
  orderBy_pnInitialien = NA,
  orderBy_pnVorname = NA,
  orderBy_pnNachname = NA,
  orderBy_pnInstitutionID = NA,
  orderBy_pnAdresse = NA,
  orderBy_pnTelefon = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_pnID	condition for field pnID: Enter a field description here
where_pnInitialien	condition for field pnInitialien: Enter a field description here
where_pnVorname	condition for field pnVorname: Enter a field description here
where_pnNachname	condition for field pnNachname: Enter a field description here
where_pnInstitutionID	condition for field pnInstitutionID: Enter a field description here
where_pnAdresse	condition for field pnAdresse: Enter a field description here
where_pnTelefon	condition for field pnTelefon: Enter a field description here
select	fields/expressions to select
select_pnID	select field pnID?
select_pnInitialien	select field pnInitialien?
select_pnVorname	select field pnVorname?
select_pnNachname	select field pnNachname?
select_pnInstitutionID	select field pnInstitutionID?
select_pnAdresse	select field pnAdresse?
select_pnTelefon	select field pnTelefon?
orderBy	ORDER BY clause of SQL expression
orderBy_pnID	order by field pnID?
orderBy_pnInitialien	order by field pnInitialien?
orderBy_pnVorname	order by field pnVorname?
orderBy_pnNachname	order by field pnNachname?
orderBy_pnInstitutionID	order by field pnInstitutionID?
orderBy_pnAdresse	order by field pnAdresse?
orderBy_pnTelefon	order by field pnTelefon?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblprojekt

Description

select and filter records from tblprojekt

Usage

kuras_projekt(
  where = NULL,
  where_pID = NA,
  where_pName = NA,
  where_pBeginn = NA,
  where_pEnde = NA,
  where_pDurchfuehrungInstitutionID = NA,
  where_pAuftraggeberInstitutionID = NA,
  where_pBeschreibung = NA,
  where_pProjektblattnummer = NA,
  select = NULL,
  select_pID = NA,
  select_pName = NA,
  select_pBeginn = NA,
  select_pEnde = NA,
  select_pDurchfuehrungInstitutionID = NA,
  select_pAuftraggeberInstitutionID = NA,
  select_pBeschreibung = NA,
  select_pProjektblattnummer = NA,
  orderBy = NULL,
  orderBy_pID = NA,
  orderBy_pName = NA,
  orderBy_pBeginn = NA,
  orderBy_pEnde = NA,
  orderBy_pDurchfuehrungInstitutionID = NA,
  orderBy_pAuftraggeberInstitutionID = NA,
  orderBy_pBeschreibung = NA,
  orderBy_pProjektblattnummer = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_pID	condition for field pID: Enter a field description here
where_pName	condition for field pName: Enter a field description here
where_pBeginn	condition for field pBeginn: Enter a field description here
where_pEnde	condition for field pEnde: Enter a field description here
where_pDurchfuehrungInstitutionID	condition for field pDurchfuehrungInstitutionID: Enter a field description here
where_pAuftraggeberInstitutionID	condition for field pAuftraggeberInstitutionID: Enter a field description here
where_pBeschreibung	condition for field pBeschreibung: Enter a field description here
where_pProjektblattnummer	condition for field pProjektblattnummer: Enter a field description here
select	fields/expressions to select
select_pID	select field pID?
select_pName	select field pName?
select_pBeginn	select field pBeginn?
select_pEnde	select field pEnde?
select_pDurchfuehrungInstitutionID	select field pDurchfuehrungInstitutionID?
select_pAuftraggeberInstitutionID	select field pAuftraggeberInstitutionID?
select_pBeschreibung	select field pBeschreibung?
select_pProjektblattnummer	select field pProjektblattnummer?
orderBy	ORDER BY clause of SQL expression
orderBy_pID	order by field pID?
orderBy_pName	order by field pName?
orderBy_pBeginn	order by field pBeginn?
orderBy_pEnde	order by field pEnde?
orderBy_pDurchfuehrungInstitutionID	order by field pDurchfuehrungInstitutionID?
orderBy_pAuftraggeberInstitutionID	order by field pAuftraggeberInstitutionID?
orderBy_pBeschreibung	order by field pBeschreibung?
orderBy_pProjektblattnummer	order by field pProjektblattnummer?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblreferenz

Description

select and filter records from tblreferenz

Usage

kuras_referenz(
  where = NULL,
  where_rID = NA,
  where_rNachname = NA,
  where_rVorname = NA,
  where_rJahr = NA,
  where_rArt = NA,
  where_rTitel = NA,
  where_rTitelMedium = NA,
  where_rZusatz = NA,
  where_rBeschreibung = NA,
  where_rQualitaet = NA,
  select = NULL,
  select_rID = NA,
  select_rNachname = NA,
  select_rVorname = NA,
  select_rJahr = NA,
  select_rArt = NA,
  select_rTitel = NA,
  select_rTitelMedium = NA,
  select_rZusatz = NA,
  select_rBeschreibung = NA,
  select_rQualitaet = NA,
  orderBy = NULL,
  orderBy_rID = NA,
  orderBy_rNachname = NA,
  orderBy_rVorname = NA,
  orderBy_rJahr = NA,
  orderBy_rArt = NA,
  orderBy_rTitel = NA,
  orderBy_rTitelMedium = NA,
  orderBy_rZusatz = NA,
  orderBy_rBeschreibung = NA,
  orderBy_rQualitaet = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_rID	condition for field rID: Enter a field description here
where_rNachname	condition for field rNachname: Enter a field description here
where_rVorname	condition for field rVorname: Enter a field description here
where_rJahr	condition for field rJahr: Enter a field description here
where_rArt	condition for field rArt: Enter a field description here
where_rTitel	condition for field rTitel: Enter a field description here
where_rTitelMedium	condition for field rTitelMedium: Enter a field description here
where_rZusatz	condition for field rZusatz: Enter a field description here
where_rBeschreibung	condition for field rBeschreibung: Enter a field description here
where_rQualitaet	condition for field rQualitaet: Enter a field description here
select	fields/expressions to select
select_rID	select field rID?
select_rNachname	select field rNachname?
select_rVorname	select field rVorname?
select_rJahr	select field rJahr?
select_rArt	select field rArt?
select_rTitel	select field rTitel?
select_rTitelMedium	select field rTitelMedium?
select_rZusatz	select field rZusatz?
select_rBeschreibung	select field rBeschreibung?
select_rQualitaet	select field rQualitaet?
orderBy	ORDER BY clause of SQL expression
orderBy_rID	order by field rID?
orderBy_rNachname	order by field rNachname?
orderBy_rVorname	order by field rVorname?
orderBy_rJahr	order by field rJahr?
orderBy_rArt	order by field rArt?
orderBy_rTitel	order by field rTitel?
orderBy_rTitelMedium	order by field rTitelMedium?
orderBy_rZusatz	order by field rZusatz?
orderBy_rBeschreibung	order by field rBeschreibung?
orderBy_rQualitaet	order by field rQualitaet?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblreferenzgruppe

Description

select and filter records from tblreferenzgruppe

Usage

kuras_referenzgruppe(
  where = NULL,
  where_rgID = NA,
  select = NULL,
  select_rgID = NA,
  orderBy = NULL,
  orderBy_rgID = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_rgID	condition for field rgID: Enter a field description here
select	fields/expressions to select
select_rgID	select field rgID?
orderBy	ORDER BY clause of SQL expression
orderBy_rgID	order by field rgID?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblreferenzgruppereferenz

Description

select and filter records from tblreferenzgruppereferenz

Usage

kuras_referenzgruppereferenz(
  where = NULL,
  where_rrID = NA,
  where_rrReferenzGruppeID = NA,
  where_rrReferenzID = NA,
  select = NULL,
  select_rrID = NA,
  select_rrReferenzGruppeID = NA,
  select_rrReferenzID = NA,
  orderBy = NULL,
  orderBy_rrID = NA,
  orderBy_rrReferenzGruppeID = NA,
  orderBy_rrReferenzID = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_rrID	condition for field rrID: Enter a field description here
where_rrReferenzGruppeID	condition for field rrReferenzGruppeID: Enter a field description here
where_rrReferenzID	condition for field rrReferenzID: Enter a field description here
select	fields/expressions to select
select_rrID	select field rrID?
select_rrReferenzGruppeID	select field rrReferenzGruppeID?
select_rrReferenzID	select field rrReferenzID?
orderBy	ORDER BY clause of SQL expression
orderBy_rrID	order by field rrID?
orderBy_rrReferenzGruppeID	order by field rrReferenzGruppeID?
orderBy_rrReferenzID	order by field rrReferenzID?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

select records from tblstandort

Description

select and filter records from tblstandort

Usage

kuras_standort(
  where = NULL,
  where_oID = NA,
  where_oName = NA,
  where_oOrt = NA,
  select = NULL,
  select_oID = NA,
  select_oName = NA,
  select_oOrt = NA,
  orderBy = NULL,
  orderBy_oID = NA,
  orderBy_oName = NA,
  orderBy_oOrt = NA,
  db = "KURAS",
  ...
)

Arguments

where	WHERE condition
where_oID	condition for field oID: Enter a field description here
where_oName	condition for field oName: Enter a field description here
where_oOrt	condition for field oOrt: Enter a field description here
select	fields/expressions to select
select_oID	select field oID?
select_oName	select field oName?
select_oOrt	select field oOrt?
orderBy	ORDER BY clause of SQL expression
orderBy_oID	order by field oID?
orderBy_oName	order by field oName?
orderBy_oOrt	order by field oOrt?
db	name of ODBC data source, default: "KURAS"
...	additional arguments passed to kwb.db::selectFromTable

---

Write References to file in RIS (Research Information Systems) Format

Description

Write References to file in RIS (Research Information Systems) Format

Usage

kurasReferencesToRIS(references)

Arguments

references

data frame with columns rNachname, rVorname, rTitel, Medium, rZusatz, rJahr, rBeschreibung

Value

path to the file created in the tempdir() folder

Examples

## Not run: 
# Get all entries from KURAS table "tblReferenz"
references <- kuras_referenz()
  
# Generate RIS-file in temporary folder
file <- kurasReferencesToRIS(references)

# Open the file in the Windows Explorer
# kwb.utils::hsOpenWindowsExplorer(file)

## End(Not run)

---