Property talk:P3138

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

OFDb film ID
identifier for a film (movie) in the German Online-Filmdatenbank website

Associated item	Online-Filmdatenbank (Q1669874)
Applicable "stated in" value	Online-Filmdatenbank (Q1669874)
Data type	External identifier
Corresponding template	Template:OFDb (Q14411401)
Template parameter	|1= in de:template:OFDb
Domain	According to this template: film (Q11424) According to statements in the property: film (Q11424), television program (Q15416), film series (Q24856), web series (Q526877) or unfinished or abandoned film project (Q18011171) When possible, data should only be stored as statements
Allowed values	[1-9]\d{0,5}
Example	Close Encounters of the Third Kind (Q320588) → 7396 Neon Genesis Evangelion (Q662) → 1873 Der Schuh des Manitu (Q518765) → 10007
Source	http://www.ofdb.de/
Formatter URL	https://www.ofdb.de/film/$1
Tracking: usage	Category:Pages using Wikidata property P3138 (Q102355703)
Related to country	Germany (Q183) (See 347 others)
See also	OFDb person ID (P9404), IMDb ID (P345), Encyclociné ID (P12059)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Mix'n'match (Report) Database reports/Constraint violations/P3138 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 127,280 Main statement 127,172 >99.9% of uses Qualifier 3 <0.1% of uses Reference 105 <0.1% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Distinct values: this property likely contains a value that is different from all other items. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3138#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3138#Single value, SPARQL

Format “|[1-9]\d{0,5}”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P3138#Format, hourly updated report, SPARQL

Type “film (Q11424), television program (Q15416), film series (Q24856), web series (Q526877), unfinished or abandoned film project (Q18011171)”: item must contain property “instance of (P31)” with classes “film (Q11424), television program (Q15416), film series (Q24856), web series (Q526877), unfinished or abandoned film project (Q18011171)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3138#Type Q11424, Q15416, Q24856, Q526877, Q18011171, SPARQL

Conflicts with “instance of (P31): human (Q5), animal actor (Q52688389)”: this property must not be used with the listed properties and values. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3138#Conflicts with P31, hourly updated report, SPARQL

Conflicts with “instance of (P31): Wikimedia disambiguation page (Q4167410), Wikimedia category (Q4167836), Wikimedia project page (Q14204246), Wikimedia template (Q11266439)”: this property must not be used with the listed properties and values. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3138#Conflicts with P31, hourly updated report, SPARQL

Qualifiers “object named as (P1932), subject named as (P1810), language of work or name (P407), reason for deprecated rank (P2241), reason for preferred rank (P7452)”: this property should be used only with the listed qualifiers. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3138#allowed qualifiers, hourly updated report, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3138#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3138#Scope, SPARQL

Label required in languages: de: Entities using this property should have labels in one of the following languages: de (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3138#Label in 'de' language, search, SPARQL

Pattern ^(?:https?://www\.ofdb\.de/film/)?(\d+)\,.+$ will be automatically replaced to \1. Testing: TODO list

Property infos

This property is being used by: de:Vorlage:Filmdaten, de:Vorlage:OFDb, de:Vorlage:Filmdaten/1 ca:Plantilla:OFDb Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Discussion

formatter URL is not working

The formatter URL linking to ofdb.de is requesting an authorization and therefore not working. I think it has something to do with the SSL/TLS encryption. Kind regards, --Soluvo (talk) 22:22, 23 May 2017 (UTC)