...
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT * FROM cdws.f_family_simple( xml.f_ucid2id('US-5000000-A') ); ucid | family_id ------------------+----------- AR-242634-A1 | 26932266 CA-1335430-C | 26932266 EP-0431047-A1 | 26932266 HU-T60328-A | 26932266 JP-H05502366-A | 26932266 KR-900702042-A | 26932266 WO-1990002193-A1 | 26932266 SELECT * FROM cdws.f_family_extended( xml.f_ucid2id('US-5551212-A') ); publication_id | ucid | level ----------------+----------------+------- 71329085 | US-5551212-A | 0 302369 | AT-96388-T | 1 1220699 | AU-636238-B2 | 1 2293384 | AU-8174591-A | 1 5137694 | CA-2050271-A1 | 1 5137693 | CA-2050271-C | 1 14883151 | DE-4027762-C1 | 1 17156127 | DE-59100535-D1 | 1 93003830 | DK-0477487-T3 | 1 21052692 | EP-0477487-A1 | 1 21052691 | EP-0477487-B1 | 1 25818932 | ES-2046827-T3 | 1 128970015 | JP-H054613-A | 1 131336800 | JP-H0825524-B2 | 1 59117993 | NO-913030-D0 | 1 177975213 | NO-913030-L | 1 62462393 | TR-25401-A | 1 159577685 | ZA-9106183-B | 1 |
A second optional argument in the cdws.f_family_extended
function, v_include_apps Boolean
, can be used to include application filing data from the patent office. The default setting of this argument is false
in order to maintain consistency with the EPO. In some cases, however, application filing data is not included in the priority claims data. Setting this argument to true
will include the application filing data, as in the following example.
Code Block | ||
---|---|---|
| ||
SELECT ucid
FROM cdws.f_family_extended(xml.f_ucid2id('AU-2012201497-B2'), true ) as f
WHERE f.ucid = 'WO-2008136115-A1';
ucid
------------------
WO-2008136115-A1
(1 row) |
Additional Functions
In addition to the above, there are other functions in the supplemental patch worth exploring, namely:
...
- family-id - DocDB-assigned simple family integer identifier
- ucid – unique character identifier (publication)
- published – publication date
- anucid – unique character identifier (application)
- filed – application filing date
- title – title of document
- ifi_status – IFI integrated content Snapshot document status
- ifi_anticipated_expiration - IFI anticipated expiration date
- ifi_adjusted_expiration - IFI adjusted expiration date
- epo_legal_status_xml – XML representation of EPO legal status
...