Filter interaction issues

Dgojsic commented 4 weeks ago

To reproduce: Consider this project, which has a theme assinged and is an interreg project: https://kohesio.ec.europa.eu/en/projects/Q4299624 When filtering for the appropriate theme "Network infrastructure in transport and energy" and setting the Programme type to "Interreg" no projects at all are found

Issue 2 not directly related to interred, but related so keeping it in the same issue. When Austria is selected and one of the major programmes is selected (2014AT16RFOP001 - Investments in Growth and Employment - AT - ERDF) no priority axis options show up in the filter, even though these projects have priority axis assigned. This displays correctly for example in CZ when Programme 2014CZ05M2OP001 - Research Development and Education - CZ - ESF/ERDF is selected, options for priority axis filtering show up correct

madewild commented 2 weeks ago

Sorry I missed that one. Trying to identify if it's a frontend or backend problem...

https://kohesio.ec.europa.eu/api/projects?offset=0&limit=15&theme=https://linkedopendata.eu/entity/Q236695&policyObjective=https://linkedopendata.eu/entity/Q2577335&interreg=true&language=en seems to return nothing, @DiaZork can you check if it's normal?

madewild commented 2 weeks ago

@DiaZork for the second case it's also empty: https://kohesio.ec.europa.eu/api/queries/priority_axis?country=https://linkedopendata.eu/entity/Q16&program=https://linkedopendata.eu/entity/Q2463050&language=en

DiaZork commented 2 weeks ago

Okay so for the first case the problem I see is that the policy objective is not attach to this project but the theme is. But when you select the theme it's going to put the policy objective in so making the request fail.

I think in the past the policy objective was materialized in the index ? So that when you had :

project -> theme -> policy It would create the triple
project -> policy But it seems it's not the case anymore. There is no project that have policy objective attach. So the solution for this is we re materialized this triples in the index or we change the queries that retrieved this info (which will take longer to resolve)

For the second thing, I notice there is a whitelisted program that is in place. I think it was setup for good reason when we set it up first but this specific program is not in so it return nothing and this is the issue. So i think we need to remove this "whitelist" and that will fix this

ec-doris / kohesio-frontend

Filter interaction issues #999