Skip to main content
 
 
 
IN THIS SECTION
3 posts
envecon2022
Last seen: 11/16/2022 - 02:33
Joined: 10/28/2022 - 10:11
Problem Building Query
Russ
Last seen: 03/21/2024 - 09:05
Joined: 11/14/2017 - 22:15
null fields

It looks like something is wrong in the database, most likely with the recent data load.  This query q={"patent_number":"8674214"}&f=["cpc_category","cpc_group_id","cpc_section_id","cpc_subgroup_id","cpc_subsection_id","cpc_sequence"] used to work but now returns null cpc_group_ids etc,

{
    "patents": [
        {
            "cpcs": [
                {
                    "cpc_category": null,
                    "cpc_group_id": null,
                    "cpc_section_id": "H",
                    "cpc_subgroup_id": null,
                    "cpc_subsection_id": "H01",
                    "cpc_sequence": null
                },
                {
                    "cpc_category": null,
                    "cpc_group_id": null,
                    "cpc_section_id": "Y",
                    "cpc_subgroup_id": null,
                    "cpc_subsection_id": "Y02",
                    "cpc_sequence": null
                }
            ]
        }
    ],
    "count": 1,
    "total_patent_count": 1
}
PVTeam
Role: moderator
Last seen: 04/26/2024 - 10:39
Joined: 10/17/2017 - 10:47
Hello, we have resolved this…

Hello, we have resolved this issue of missing data generated from the last data load. Thank you Russ and Ina for bringing this issue to our attention. 

Thank you,

PVTeam