ETSI IPR Reporting Solutions - Revision history

Borgesormond: /* SQL Generic Query access */

2026-02-12T16:42:12Z

SQL Generic Query access

← Older revision		Revision as of 17:42, 12 February 2026
Line 197:		Line 197:
	The system executes the query and displays the SQL result in a simple table. This SQL result can then be exported to CSV, opening directly in the browser window.		The system executes the query and displays the SQL result in a simple table. This SQL result can then be exported to CSV, opening directly in the browser window.

	This feature is available only to logged-in users. To access it, please click the ‘Sign Up’ link on the ~~something~~.org page and follow the steps to create your account.		This feature is available only to logged-in users. To access it, please click the ‘Sign Up’ link on the [https://ipr.etsi.org/ ipr.etsi.org] page and follow the steps to create your account.

Borgesormond at 14:53, 26 January 2026

2026-01-26T14:53:49Z

← Older revision		Revision as of 15:53, 26 January 2026
Line 98:		Line 98:
	'''PBPA_APP_DATE''' = the published patent's application date (i.e. the date associated with the respective patent's Application Number).		'''PBPA_APP_DATE''' = the published patent's application date (i.e. the date associated with the respective patent's Application Number).

	'''ETPR_ID''' is the unique identifier for the specific project referred to by ETPR_ACRONYM within the disclosure linked to DIPG_ID.		'''ETPR_ID''' = the unique identifier for the specific project referred to by ETPR_ACRONYM within the disclosure linked to DIPG_ID.

	'''ETPR_ACRONYM''' = acronym of a project included in the disclosure identified by DIPG_ID.		'''ETPR_ACRONYM''' = acronym of a project included in the disclosure identified by DIPG_ID.

Belchankova at 12:19, 23 September 2025

2025-09-23T12:19:26Z

← Older revision		Revision as of 13:19, 23 September 2025
Line 170:		Line 170:
	Page visualizes the daily refreshed data related to the Patent Families Declared over Mobiles Generations and Patent Families Declared without mobile Generations.		Page visualizes the daily refreshed data related to the Patent Families Declared over Mobiles Generations and Patent Families Declared without mobile Generations.

	===== ~~'''~~7.~~''' '''~~Incomplete disclosures (standard/specification missing)~~'''~~ =====		===== 7. Incomplete disclosures (standard/specification missing) =====
	Page which highlights entries missing standard or specification details, presents the data in a structured table. Users may filter the data by:		Page which highlights entries missing standard or specification details, presents the data in a structured table. Users may filter the data by:

Belchankova at 12:16, 23 September 2025

2025-09-23T12:16:32Z

← Older revision		Revision as of 13:16, 23 September 2025
Line 47:		Line 47:
	'''LICD_REC_CONDI_FLAG''' = whether the declarant is prepared to grant licenses (cf. LICD_DEC_PREP_TO_GRANT_FLAG) and specified the option "undertaking subject to reciprocate conditions". This information is filled in by the declarant, on the first page of the ISLD declaration.		'''LICD_REC_CONDI_FLAG''' = whether the declarant is prepared to grant licenses (cf. LICD_DEC_PREP_TO_GRANT_FLAG) and specified the option "undertaking subject to reciprocate conditions". This information is filled in by the declarant, on the first page of the ISLD declaration.

	==== ~~'''~~Below is an explanation on the columns which are displayed on the "ISLD-export.csv" tab:~~'''~~ ====		==== Below is an explanation on the columns which are displayed on the "ISLD-export.csv" tab: ====



	'''IPRD_ID''' = unique IPRD id number.		'''IPRD_ID''' = unique IPRD id number.
Line 180:		Line 178:
	* IPR declaration date (signature)		* IPR declaration date (signature)

	===== ~~'''~~8.~~''' '''~~Unnormalized patents – lists for review &update~~'''~~ =====		===== 8. Unnormalized patents – lists for review &update =====
	Page highlights the data related to unnormalized patents. Users may filter the data by:		Page highlights the data related to unnormalized patents. Users may filter the data by:

Belchankova at 12:11, 23 September 2025

2025-09-23T12:11:24Z

← Older revision		Revision as of 13:11, 23 September 2025
Line 48:		Line 48:

	==== '''Below is an explanation on the columns which are displayed on the "ISLD-export.csv" tab:''' ====		==== '''Below is an explanation on the columns which are displayed on the "ISLD-export.csv" tab:''' ====



Line 126:		Line 127:
	ETSI currently proposes '''8 pages''' of Power BI reports available, each showing different insights and data views.		ETSI currently proposes '''8 pages''' of Power BI reports available, each showing different insights and data views.

	===== ~~'''~~1. Full declaration data page~~'''~~ =====		===== 1. Full declaration data page =====
	Provides an overview of declaration data, featuring the most essential information related to declarations. The filters include:		Provides an overview of declaration data, featuring the most essential information related to declarations. The filters include:

Line 146:		Line 147:

	'''Patent type (basis patent/family member)''' ''Patent Type'' - type of patent in relation to the disclosure. The patent type can be "basis patent" or "family member".		'''Patent type (basis patent/family member)''' ''Patent Type'' - type of patent in relation to the disclosure. The patent type can be "basis patent" or "family member".
	===== ~~'''~~2. Key metrics – Normalized patents page~~'''~~ =====		===== 2. Key metrics – Normalized patents page =====
	Presents important figures and visualizations related to '''normalized patents''', including key numbers and summary charts.		Presents important figures and visualizations related to '''normalized patents''', including key numbers and summary charts.

Line 155:		Line 156:
	Users can '''filter the data by date''' to explore specific time periods.		Users can '''filter the data by date''' to explore specific time periods.

	===== ~~'''~~3. Key metrics – illustrative specific part (ISP) page~~'''~~ =====		===== 3. Key metrics – illustrative specific part (ISP) page =====
	Displays key data and charts about specific illustrative sections, featuring important figures and summary visuals.		Displays key data and charts about specific illustrative sections, featuring important figures and summary visuals.

Line 162:		Line 163:
	Users may filter the data by date to explore specific time periods.		Users may filter the data by date to explore specific time periods.

	===== ~~'''~~4. Normalized patents details page~~'''~~ =====		===== 4. Normalized patents details page =====
	Displays normalized patent data. Users may filter the dataset by IPR declaration date (signature) and declarant company name. The histogram provides a visual representation of number of patents by companies and normalization.		Displays normalized patent data. Users may filter the dataset by IPR declaration date (signature) and declarant company name. The histogram provides a visual representation of number of patents by companies and normalization.

Belchankova: /* 6. Declaration distribution charts */

2025-09-23T12:05:16Z

6. Declaration distribution charts

← Older revision		Revision as of 13:05, 23 September 2025
Line 169:		Line 169:

	===== 6. Declaration distribution charts =====		===== 6. Declaration distribution charts =====
	Page visualizes the daily refreshed data related to the Patent Families Declared over Mobiles Generations and Patent Families Declared without mobile Generations.		Page visualizes the daily refreshed data related to the Patent Families Declared over Mobiles Generations and Patent Families Declared without mobile Generations.

	===== '''7.''' '''Incomplete disclosures (standard/specification missing)''' =====		===== '''7.''' '''Incomplete disclosures (standard/specification missing)''' =====

Belchankova at 11:50, 23 September 2025

2025-09-23T11:50:26Z

← Older revision		Revision as of 12:50, 23 September 2025
Line 146:		Line 146:

	'''Patent type (basis patent/family member)''' ''Patent Type'' - type of patent in relation to the disclosure. The patent type can be "basis patent" or "family member".		'''Patent type (basis patent/family member)''' ''Patent Type'' - type of patent in relation to the disclosure. The patent type can be "basis patent" or "family member".


	===== '''2. Key metrics – Normalized patents page''' =====		===== '''2. Key metrics – Normalized patents page''' =====
	Presents important figures and visualizations related to '''normalized patents''', including key numbers and summary charts.		Presents important figures and visualizations related to '''normalized patents''', including key numbers and summary charts.

Belchankova at 11:50, 23 September 2025

2025-09-23T11:50:02Z

@@ Line 124: / Line 124: @@
 '''ETSI Power BI report''' is a set of interactive dashboards and charts that help the users to see and understand the reporting data. They let explore trends, compare numbers, and make better decisions using visuals instead of raw data.
-ETSI currently proposes '''9 pages''' of Power BI reports available, each showing different insights and data views.
+ETSI currently proposes '''8 pages''' of Power BI reports available, each showing different insights and data views.
 ===== '''1. Full declaration data page''' =====
-provides an overview of declaration data, featuring the most essential information related to declarations. The filters include:
+Provides an overview of declaration data, featuring the most essential information related to declarations. The filters include:
 '''IPR declaration date (signature)''' ''IPRD_Signature_Date'' - date of the IPR declaration submission to ETSI;
@@ Line 146: / Line 146: @@
 '''Patent type (basis patent/family member)''' ''Patent Type'' - type of patent in relation to the disclosure. The patent type can be "basis patent" or "family member".

Belchankova at 11:31, 23 September 2025

2025-09-23T11:31:01Z

← Older revision		Revision as of 12:31, 23 September 2025
Line 126:		Line 126:
	ETSI currently proposes '''9 pages''' of Power BI reports available, each showing different insights and data views.		ETSI currently proposes '''9 pages''' of Power BI reports available, each showing different insights and data views.

	'''1. Full declaration data page''' provides an overview of declaration data, featuring the most essential information related to declarations.		===== '''1. Full declaration data page''' =====
			provides an overview of declaration data, featuring the most essential information related to declarations. The filters include:
	The filters include:

	'''IPR declaration date (signature)''' ''IPRD_Signature_Date'' - date of the IPR declaration submission to ETSI;		'''IPR declaration date (signature)''' ''IPRD_Signature_Date'' - date of the IPR declaration submission to ETSI;

Belchankova at 11:30, 23 September 2025

2025-09-23T11:30:26Z

← Older revision		Revision as of 12:30, 23 September 2025
Line 125:		Line 125:

	ETSI currently proposes '''9 pages''' of Power BI reports available, each showing different insights and data views.		ETSI currently proposes '''9 pages''' of Power BI reports available, each showing different insights and data views.
	~~'''1. Full declaration data page''' provides an overview of declaration data, featuring the most essential information related to declarations.~~

	'''1. Full declaration data page''' provides an overview of declaration data, featuring the most essential information related to declarations.		'''1. Full declaration data page''' provides an overview of declaration data, featuring the most essential information related to declarations.