• Home
• org.ehrbase.openehr
• service
• 0.27.2
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

penehr.service.0.27.2.source-code.aql_wrappers.sql Maven / Gradle / Ivy

CREATE OR REPLACE FUNCTION aql_value_dv_coded_text(object_struct json, field_name text) RETURNS text AS $$

BEGIN
	raw_archetype := split_part(raw_archetype,'and name/value=', 1);
	raw_archetype := replace(raw_archetype, '-', '_');
	raw_archetype := replace(raw_archetype, '.', '_');
	raw_archetype := trim(trailing ' ' from raw_archetype);

	return raw_archetype;
END

$$ LANGUAGE plpgsql;