soerepro: metadata extraction on parameter types and parameters returns nothing

[Olivier Maury]

At soerepro/extraction/metadata,

choosing "Parameter types Parameter types, parameters by compartments." returns nothing, whereas there is data in the tables.

[Nautile bleu (nautilebleu)]

When I test on my personal computer, I get data so can you provide a more recent release of the DB so I can check what's wrong?

[Nautile bleu (nautilebleu)]

Bonjour à vous 2,

Olivier s'est lâché dites-moi !

Si je ne me suis pas trompé, sur les 88 mails (!!), seuls 3 ne concernent pas la fermeture d'un bug : celui-ci et le pb avec la touche MAJ sur les produits. Ce dernier point est corrigé à la révision r1395.

J'ai également fermé l'item #953058 soeretypo: Remove "liste des valeurs de minéralisation"

Je ne suis pas sûr de comprendre le sens du bug https://bugs.launchpad.net/datum/+bug/953049. Le code de la méthode est disponible dans la partie inférieure du widget ?

Bon début de semaine,

Goulwen

Le 16 mars 2012 à 14:50, Olivier Maury a écrit :

> Public bug reported:
>
> At soerepro/extraction/metadata,
>
> choosing "Parameter types Parameter types, parameters by compartments."
> returns nothing, whereas there is data in the tables.
>
> ** Affects: datum
> Importance: Critical
> Assignee: Nautile bleu (nautilebleu)
> Status: New
>
> --
> You received this bug notification because you are a bug assignee.
> https://bugs.launchpad.net/bugs/956978
>
> Title:
> soerepro: metadata extraction on parameter types and parameters
> returns nothing
>
> Status in Datum:
> New
>
> Bug description:
> At soerepro/extraction/metadata,
>
> choosing "Parameter types Parameter types, parameters by
> compartments." returns nothing, whereas there is data in the tables.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/datum/+bug/956978/+subscriptions

[Nautile bleu (nautilebleu)]

My tests show that no data are returned because the table "ligne" is empty. This table is used in the query to link "validation_parametre" to "groupe_analyse", which is used to get related tables "laboratoire", "type_prelevement", "matrice", "dispositif", "plateforme", "observatoire", "unite" and "methode" , which contains the real data we want to display.

So, is it normal that the "ligne" is empty? If yes, I quickly look about an alternative path to link all those tables, but as there a lot of combinaisons, can you give me a hint about how you want to organize data in this new schema?