Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Kafka connect - Versionsnummer #197

Open
jasminziegler opened this issue Aug 9, 2024 · 1 comment
Open

Kafka connect - Versionsnummer #197

jasminziegler opened this issue Aug 9, 2024 · 1 comment

Comments

@jasminziegler
Copy link
Contributor

No description provided.

@pcvolkmer
Copy link
Contributor

Die Versionsnummer wird bereits verwendet:

"query": "SELECT * FROM (SELECT YEAR(e.diagnosedatum) AS YEAR, versionsnummer AS VERSIONSNUMMER, lme.id AS ID, CONVERT(lme.xml_daten using utf8) AS XML_DATEN FROM lkr_meldung_export lme JOIN lkr_meldung lm ON lme.lkr_meldung = lm.id JOIN erkrankung e ON lm.erkrankung_id = e.id WHERE typ != '-1' AND versionsnummer IS NOT NULL AND lme.XML_DATEN LIKE '%ICD_Version%' AND EXTRACTVALUE(lme.xml_daten, '//ADT_GEKID/@Schema_Version') LIKE '2.%') o",

Es ist jedoch zu prüfen, ob sie auch in https://github.com/bzkf/obds-to-fhir verwendet wird, wenn benötigt.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants