Dear Community,  I would like to retrieve the number of oppositions in all the IPC-4 digit classes. I don't know if there is a way to avoid explicitly listing in the query all the IPC-4 digit, but make it automatic. If not, how could I structure my query? I don't mind if a single patent that pertain...

Dear Eliminatehair, I do not have a practical solution yet. I mediated the problem by searching each patent (one by one :cry: ) on the EP register in order to find the outcome date. It is okay if you have a small sample, otherwise it is a bit time consuming. Hope this can help you. My best wishes El...

Dear Community, I have a question for you. In which patstat table and with which connections among tables can I find the date of the opposition's outcome? I know that from table REG101_appln I can retrive the outcome of the opposition in the variable status , but I'm having trouble in deriving the d...

Thank you so much for your precious help.
Best regarsds,
Elisa

Dear users,
did you know which is the table in PATSTAT with data on the outcome of patent oppositions? I am interested in knowing if certain oppositions have been sentenced as amendmend, rather than patent withdrawn or rejection of the opposition.
Thank you so much for your precious help
Elisa

Dear all, I am still working on my research on opposition and I need to retrive all the opposition filed for cosmetic patents, without time restriction. I have two issue: 1- I want to see as a single opposition (i.e. in a single row) the ones filled by more than one applicant, with a kind of "s...

Dear all, I am currently trying to retrive all the patent opposition occured in a specific IPC class. I am not sure about the results I obtain also because i fear data are incomplete. Specifically, I am trying to see the opposition received by patent filed for cosmetics (IPC=A61Q); i don't mind if i...

Thank you so much for your reply. Another question, in order to simplify and speed my work. What I should do if I want different rows for different weights? Do I need to run the query every time changing the weight or can I insert a sort of "for" cycle: for example "for n.weight =0.25...

Dear Community, I am trying to figure out the trend of patent applications for a certain NACE category through the years, from 1970 to 2020. I would like to see the number of patent applications for NACE 21.00 (pharmaceuticals), and I want to count 1 for each patent, regardless of the number of coun...

Thank you so much for your help!!