OpenPV - Spontaneous Form Creation Part 1 - Revision history

Khoppenworth at 02:00, 23 June 2024

2024-06-23T02:00:58Z

Khoppenworth at 01:53, 23 June 2024

2024-06-23T01:53:33Z

Khoppenworth at 18:25, 23 May 2024

2024-05-23T18:25:31Z

← Older revision		Revision as of 18:25, 23 May 2024
Line 1:		Line 1:
	The following script will create a standard Spontaneous Reporting form in OpenRIMS-PV.<blockquote>/**************************************************		The following script will create a standard Spontaneous Reporting form in OpenRIMS-PV.<blockquote>/**************************************************/

	DATASET		/DATASET/

	**************************************************/		/**************************************************/

	INSERT INTO dataset (DatasetName, active, initialiseprocess, RulesProcess, help, created, lastupdated, contexttype_id, createdby_id, updatedby_Id, issystem)		INSERT INTO dataset (DatasetName, active, initialiseprocess, RulesProcess, help, created, lastupdated, contexttype_id, createdby_id, updatedby_Id, issystem)
Line 11:		Line 11:
	set @dsid = (SELECT @@IDENTITY);		set @dsid = (SELECT @@IDENTITY);

	/**************************************************		/**************************************************/

	CATEGORY Patient Information/		/CATEGORY Patient Information/

	**************************************************/		/**************************************************/

	INSERT INTO datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)		INSERT INTO datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)

Khoppenworth at 18:24, 23 May 2024

2024-05-23T18:24:51Z

← Older revision		Revision as of 18:24, 23 May 2024
Line 13:		Line 13:
	/**************************************************		/**************************************************

	CATEGORY Patient Information		CATEGORY Patient Information/

	**************************************************/		**************************************************/

Khoppenworth at 18:23, 23 May 2024

2024-05-23T18:23:30Z

Show changes

Khoppenworth: Created page with "Coming Back Soon!"

2023-07-20T20:31:03Z

Created page with "Coming Back Soon!"

New page

Coming Back Soon!

← Older revision		Revision as of 01:53, 23 June 2024
Line 271:		Line 271:
	set @dceid = (SELECT @@IDENTITY);		set @dceid = (SELECT @@IDENTITY);

	/**************************************************		/**************************************************/

	CATEGORY Product Information		/CATEGORY Product Information/

	**************************************************/		/**************************************************/

	INSERT into datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)		INSERT into datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)
Line 723:		Line 723:
	VALUES ('Product rechallenge', @fid, @deid, <nowiki>''</nowiki>, <nowiki>''</nowiki>, 0, 15, 'Was there a rechallenge to the usage of the product?', <nowiki>''</nowiki>);		VALUES ('Product rechallenge', @fid, @deid, <nowiki>''</nowiki>, <nowiki>''</nowiki>, 0, 15, 'Was there a rechallenge to the usage of the product?', <nowiki>''</nowiki>);

	/**************************************************		/**************************************************/

	CATEGORY Reaction and Treatment		/CATEGORY Reaction and Treatment/

	**************************************************/		/**************************************************/

	INSERT into datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)		INSERT into datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)
Line 983:		Line 983:
	set @dceid = (SELECT @@IDENTITY);		set @dceid = (SELECT @@IDENTITY);

	/**************************************************		/**************************************************/

	CATEGORY Test Results		/CATEGORY Test Results/

	**************************************************/		/**************************************************/

	INSERT into datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)		INSERT into datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)
Line 1,107:		Line 1,107:
	VALUES ('More Information', @fid, @deid, <nowiki>''</nowiki>, <nowiki>''</nowiki>, 0, 7, 'Any additional information', <nowiki>''</nowiki>);		VALUES ('More Information', @fid, @deid, <nowiki>''</nowiki>, <nowiki>''</nowiki>, 0, 7, 'Any additional information', <nowiki>''</nowiki>);

	/**************************************************		/**************************************************/

	CATEGORY Reporter Information		/CATEGORY Reporter Information/

	**************************************************/		/**************************************************/

	INSERT into datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)		INSERT into datasetcategory (datasetcategoryname, categoryorder, dataset_id, friendlyname, help)
Line 1,279:		Line 1,279:
	set @dceid = (SELECT @@IDENTITY);		set @dceid = (SELECT @@IDENTITY);

	/**************************************************		/**************************************************/

	SET ORDERING		/SET ORDERING/

	**************************************************/		/**************************************************/

	SELECT ds.DatasetName, dc.DatasetCategoryName, de.ElementName FROM Dataset ds		SELECT ds.DatasetName, dc.DatasetCategoryName, de.ElementName FROM Dataset ds