Closed alanwilter closed 3 years ago
Have you check the API returned result? I think it should not return two Gene columns initially... I can manually fix this in frontend as a patch, but we have already a lot of patch already.
Ok, let me check the backend side, but this will change anyway. So don't do anything for now. Thanks!
@pontikos I got to the bottom of this issue. It's a problem with public.user_config
table. It's a bit messy and for page
individuals
, config
column has duplicated entries for gene_symbol
in json.
I don't know if views/save_configuration.py
ever got to work, it was @priesgo work at first.
Since all new users
get their config
from Admin
, then I will fix for Admin
for the moment.
Fixed applied in dev_db
:
-- 1
update public.user_config set config = '[{"preview": [["Sorry", "You are not authorised to see this individual"]], "metadata": {"data": [{"gender": "U", "features": [{"href": "HP:0000001", "display": "All"}], "external_id": "", "consanguinity": "unknown", "candidate_genes": [{"display": ""}]}], "colNames": [{"key": "external_id", "name": "External id", "default": "true"}, {"key": "sex", "name": "Gender", "default": "true"}, {"key": "simplified_observed_features", "name": "Features", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/hpo/"}, {"key": "consanguinity", "name": "Consanguinity", "default": "true"}, {"key": "genes", "href": "/gene/", "name": "Candidate Genes", "type": "links", "default": "true"}]}, "rare_homs": {"data": [], "colNames": [{"key": "gene_symbol", "name": "Gene", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/gene/", "description": "Gene Symbol"}, {"key": "variant_id", "name": "Variant Id", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/variant/", "description": "Variant Identifier"}, {"key": "CHROM", "name": "Chromosome", "default": false, "description": "Chromosome on which variant falls."}, {"key": "POS", "name": "Position", "order": "asc", "default": false, "description": "position"}, {"key": "REF", "name": "Ref", "default": true, "description": "reference allele"}, {"key": "ALT", "name": "Alt", "default": true, "description": "alt allele"}, {"key": "ID", "name": "Rsid", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/variant/", "description": ""}, {"key": "AF", "name": "AF", "default": true, "description": "Internal allele frequency"}, {"key": "AC", "name": "AC", "default": true, "description": "Internal allele count"}, {"key": "AN", "name": "AN", "default": true, "description": "Internal total allele number (including WT)"}, {"key": "HET_COUNT", "name": "HET COUNT", "default": true, "description": "Number of individuals that are heterozygous in our dataset"}, {"key": "HOM_COUNT", "name": "HOM COUNT", "default": true, "description": "Number of individuals that are homozygous in our dataset"}, {"key": "WT_COUNT", "name": "WT COUNT", "default": true, "description": "Number of individuals that are wildtype in our dataset"}, {"key": "HET", "name": "HET", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/individual/", "description": "Het individuals (only 5 are displayedgo to variant page to see all of them)"}, {"key": "HOM", "name": "HOM", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/individual/", "description": "Hom individuals (only 5 are displayed go to variant page to see all of them)"}, {"key": "DP", "name": "DP", "default": true, "description": "Depth of sequencing"}, {"key": "FS", "name": "FS", "default": true, "description": "Fisher Strand"}, {"key": "MLEAC", "name": "MLEAC", "default": true, "description": "MLEAC"}, {"key": "MLEAF", "name": "MLEAF", "default": true, "description": "MLEAF"}, {"key": "MQ", "name": "MQ", "default": true, "description": "MQ"}, {"key": "af_jirdc", "name": "AF jirdc", "default": true, "description": "Japanese inherited retinal disease consortium allele frequency"}, {"key": "af_krgdb", "name": "AF krgdb", "default": true, "description": "Korean Genome Database allele frequency"}, {"key": "af_hgvd", "name": "AF hgvd", "default": true, "description": "HGVD"}, {"key": "af_tommo", "name": "AF tommo", "default": true, "description": "Tommo"}, {"key": "af_converge", "name": "AF converge", "default": true, "description": "Chinese consortium"}, {"key": "af_kaviar", "name": "AF kaviar", "default": true, "description": ""}, {"key": "af_gnomad_genomes", "name": "AF gnomad genomes", "default": true, "description": ""}, {"key": "cadd", "name": "Cadd", "default": true, "description": ""}, {"key": "most_severe_consequence", "name": "Most Severe Consequence", "default": true, "description": "most severe consequence of variant on different transcripts"}, {"key": "impact", "name": "Impact", "default": true, "description": ""}, {"key": "feature_id", "name": "Feature_id", "default": true, "description": ""}, {"key": "feature_type", "name": "Feature_type", "default": true, "description": ""}, {"key": "FILTER", "name": "Filter", "default": true, "description": "variant filter"}, {"key": "hgvsc", "name": "Hgvs_c", "default": true, "description": "HGVS cDNA"}, {"key": "hgvsp", "name": "Hgvs_p", "default": true, "description": "HGVS protein"}, {"key": "dann", "name": "DANN", "default": true, "description": "DANN score"}, {"key": "cadd_phred", "name": "CADD", "default": true, "description": "CADD phred score"}]}, "rare_variants": {"data": [], "colNames": [{"key": "gene_symbol", "name": "Gene", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/gene/", "description": "Gene Symbol"}, {"key": "variant_id", "name": "Variant Id", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/variant/", "description": "Variant Identifier"}, {"key": "CHROM", "name": "Chromosome", "default": false, "description": "Chromosome on which variant falls."}, {"key": "POS", "name": "Position", "order": "asc", "default": false, "description": "position"}, {"key": "REF", "name": "Ref", "default": false, "description": "reference allele"}, {"key": "ALT", "name": "Alt", "default": false, "description": "alt allele"}, {"key": "ID", "name": "Rsid", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/variant/", "description": ""}, {"key": "AF", "name": "AF", "default": true, "description": "Internal allele frequency"}, {"key": "AC", "name": "AC", "default": true, "description": "Internal allele count"}, {"key": "AN", "name": "AN", "default": true, "description": "Internal total allele number (including WT)"}, {"key": "HET", "name": "HET", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/individual/", "description": "Het individuals"}, {"key": "HOM", "name": "HOM", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/individual/", "description": "Hom individuals"}, {"key": "DP", "name": "DP", "default": true, "description": "Depth of sequencing"}, {"key": "FS", "name": "FS", "default": false, "description": "Fisher Strand"}, {"key": "MLEAC", "name": "MLEAC", "default": false, "description": "MLEAC"}, {"key": "MLEAF", "name": "MLEAF", "default": false, "description": "MLEAF"}, {"key": "MQ", "name": "MQ", "default": false, "description": "MQ"}, {"key": "af_jirdc", "name": "AF jirdc", "default": true, "description": "Japanese inherited retinal disease consortium allele frequency"}, {"key": "af_krgdb", "name": "AF krgdb", "default": true, "description": "Korean Genome Database allele frequency"}, {"key": "af_hgvd", "name": "AF hgvd", "default": true, "description": "HGVD"}, {"key": "af_tommo", "name": "AF tommo", "default": true, "description": "Tommo"}, {"key": "af_converge", "name": "AF converge", "default": true, "description": "Chinese consortium"}, {"key": "af_kaviar", "name": "AF kaviar", "default": true, "description": ""}, {"key": "af_gnomad_genomes", "name": "AF gnomad genomes", "default": true, "description": ""}, {"key": "cadd", "name": "Cadd", "default": true, "description": ""}, {"key": "most_severe_consequence", "name": "Most Severe Consequence", "default": true, "description": "most severe consequence of variant on different transcripts"}, {"key": "impact", "name": "Impact", "default": false, "description": ""}, {"key": "feature_id", "name": "Feature_id", "default": false, "description": ""}, {"key": "feature_type", "name": "Feature_type", "default": false, "description": ""}, {"key": "FILTER", "name": "Filter", "default": true, "description": "variant filter"}, {"key": "hgvsc", "name": "Hgvs_c", "default": true, "description": "HGVS cDNA"}, {"key": "hgvsp", "name": "Hgvs_p", "default": true, "description": "HGVS protein"}, {"key": "dann", "name": "DANN", "default": true, "description": "DANN score"}, {"key": "cadd_phred", "name": "CADD", "default": true, "description": "CADD phred score"}]}, "rare_comp_hets": {"data": [], "colNames": [{"key": "gene_symbol", "name": "Gene", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/gene/", "description": "Gene Symbol"}, {"key": "variant_id", "name": "Variant Id", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/variant/", "description": "Variant Identifier"}, {"key": "CHROM", "name": "Chromosome", "default": "false", "description": "Chromosome on which variant falls."}, {"key": "POS", "name": "Position", "order": "asc", "default": "false", "description": "position"}, {"key": "REF", "name": "Ref", "default": "false", "description": "reference allele"}, {"key": "ALT", "name": "Alt", "default": "false", "description": "alt allele"}, {"key": "ID", "name": "Rsid", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/variant/", "description": ""}, {"key": "AF", "name": "AF", "default": "true", "description": "Internal allele frequency"}, {"key": "AC", "name": "AC", "default": "true", "description": "Internal allele count"}, {"key": "AN", "name": "AN", "default": "false", "description": "Internal total allele number (including WT)"}, {"key": "HET_COUNT", "name": "HET COUNT", "default": "true", "description": "Number of individuals that are heterozygous in our dataset"}, {"key": "HOM_COUNT", "name": "HOM COUNT", "default": "true", "description": "Number of individuals that are homozygous in our dataset"}, {"key": "WT_COUNT", "name": "WT COUNT", "default": "false", "description": "Number of individuals that are wildtype in our dataset"}, {"key": "HET", "name": "HET", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/individual/", "description": "Het individuals (only 5 are displayedgo to variant page to see all of them)"}, {"key": "HOM", "name": "HOM", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/individual/", "description": "Hom individuals (only 5 are displayed go to variant page to see all of them)"}, {"key": "DP", "name": "DP", "default": "false", "description": "Depth of sequencing"}, {"key": "FS", "name": "FS", "default": "false", "description": "Fisher Strand"}, {"key": "MLEAC", "name": "MLEAC", "default": "false", "description": "MLEAC"}, {"key": "MLEAF", "name": "MLEAF", "default": "false", "description": "MLEAF"}, {"key": "MQ", "name": "MQ", "default": "false", "description": "MQ"}, {"key": "af_jirdc", "name": "AF jirdc", "default": "true", "description": "Japanese inherited retinal disease consortium allele frequency"}, {"key": "af_krgdb", "name": "AF krgdb", "default": "true", "description": "Korean Genome Database allele frequency"}, {"key": "af_hgvd", "name": "AF hgvd", "default": "true", "description": "HGVD"}, {"key": "af_tommo", "name": "AF tommo", "default": "true", "description": "Tommo"}, {"key": "af_converge", "name": "AF converge", "default": "true", "description": "Chinese consortium"}, {"key": "af_kaviar", "name": "AF kaviar", "default": "true", "description": ""}, {"key": "af_gnomad_genomes", "name": "AF gnomad genomes", "default": "true", "description": ""}, {"key": "cadd", "name": "Cadd", "default": "true", "description": ""}, {"key": "most_severe_consequence", "name": "Most Severe Consequence", "default": "true", "description": "most severe consequence of variant on different transcripts"}, {"key": "impact", "name": "Impact", "default": "false", "description": ""}, {"key": "feature_id", "name": "Feature_id", "default": "false", "description": ""}, {"key": "feature_type", "name": "Feature_type", "default": "false", "description": ""}, {"key": "FILTER", "name": "Filter", "default": "true", "description": "variant filter"}, {"key": "hgvsc", "name": "Hgvs_c", "default": "true", "description": "HGVS cDNA"}, {"key": "hgvsp", "name": "Hgvs_p", "default": "true", "description": "HGVS protein"}, {"key": "dann", "name": "DANN", "default": "true", "description": "DANN score"}, {"key": "cadd_phred", "name": "CADD", "default": "true", "description": "CADD phred score"}]}}]'
where (user_name,"language", page) = ('Admin', 'en', 'individual') ;
-- 2
update public.user_config set config = '[{"preview": [["Sorry", "You are not authorised to see this individual"]], "metadata": {"data": [{"gender": "U", "features": [{"href": "HP:0000001", "display": "All"}], "consanguinity": "unknown", "candidate_genes": [{"display": ""}]}], "colNames": [{"key": "sex", "name": "性別", "default": "true"}, {"key": "simplified_observed_features", "name": "患者の特徴", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/hpo/"}, {"key": "consanguinity", "name": "同族性", "default": "true"}, {"key": "genes", "href": "/gene/", "name": "Candidate Genes", "type": "links", "default": "true"}]}, "rare_homs": {"data": [], "colNames": [{"key": "gene_symbol", "name": "Gene", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/gene/", "description": "Gene Symbol"}, {"key": "CHROM", "name": "Chromosome", "default": "true", "description": "Chromosome on which variant falls."}, {"key": "POS", "name": "Position", "order": "asc", "default": "true", "description": "position"}, {"key": "REF", "name": "Ref", "default": "true", "description": "reference allele"}, {"key": "ALT", "name": "Alt", "default": "true", "description": "alt allele"}, {"key": "ID", "name": "Rsid", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/variant/", "description": ""}, {"key": "AF", "name": "AF", "default": "true", "description": "Internal allele frequency"}, {"key": "AC", "name": "AC", "default": "true", "description": "Internal allele count"}, {"key": "AN", "name": "AN", "default": "false", "description": "Internal total allele number (including WT)"}, {"key": "HET_COUNT", "name": "HET COUNT", "default": "true", "description": "Number of individuals that are heterozygous in our dataset"}, {"key": "HOM_COUNT", "name": "HOM COUNT", "default": "true", "description": "Number of individuals that are homozygous in our dataset"}, {"key": "WT_COUNT", "name": "WT COUNT", "default": "false", "description": "Number of individuals that are wildtype in our dataset"}, {"key": "HET", "name": "HET", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/individual/", "description": "Het individuals (only 5 are displayedgo to variant page to see all of them)"}, {"key": "HOM", "name": "HOM", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/individual/", "description": "Hom individuals (only 5 are displayed go to variant page to see all of them)"}, {"key": "DP", "name": "DP", "default": "false", "description": "Depth of sequencing"}, {"key": "FS", "name": "FS", "default": "false", "description": "Fisher Strand"}, {"key": "MLEAC", "name": "MLEAC", "default": "false", "description": "MLEAC"}, {"key": "MLEAF", "name": "MLEAF", "default": "false", "description": "MLEAF"}, {"key": "MQ", "name": "MQ", "default": "false", "description": "MQ"}, {"key": "af_jirdc", "name": "AF jirdc", "default": "true", "description": "Japanese inherited retinal disease consortium allele frequency"}, {"key": "af_krgdb", "name": "AF krgdb", "default": "true", "description": "Korean Genome Database allele frequency"}, {"key": "af_hgvd", "name": "AF hgvd", "default": "true", "description": "HGVD"}, {"key": "af_tommo", "name": "AF tommo", "default": "true", "description": "Tommo"}, {"key": "af_converge", "name": "AF converge", "default": "true", "description": "Chinese consortium"}, {"key": "af_kaviar", "name": "AF kaviar", "default": "true", "description": ""}, {"key": "af_gnomad_genomes", "name": "AF gnomad genomes", "default": "true", "description": ""}, {"key": "cadd", "name": "Cadd", "default": "true", "description": ""}, {"key": "most_severe_consequence", "name": "Most Severe Consequence", "default": "true", "description": "most severe consequence of variant on different transcripts"}, {"key": "impact", "name": "Impact", "default": "false", "description": ""}, {"key": "feature_id", "name": "Feature_id", "default": "false", "description": ""}, {"key": "feature_type", "name": "Feature_type", "default": "false", "description": ""}, {"key": "FILTER", "name": "Filter", "default": "true", "description": "variant filter"}, {"key": "hgvsc", "name": "Hgvs_c", "default": "true", "description": "HGVS cDNA"}, {"key": "hgvsp", "name": "Hgvs_p", "default": "true", "description": "HGVS protein"}, {"key": "dann", "name": "DANN", "default": "true", "description": "DANN score"}, {"key": "cadd_phred", "name": "CADD", "default": "true", "description": "CADD phred score"}]}, "rare_variants": {"data": [], "colNames": [{"key": "gene_symbol", "name": "Gene", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/gene/", "description": "Gene Symbol"},{"key": "variant_id", "name": "Variant Id", "type": "links", "class": "preview_onhover", "default": true, "base_href": "/variant/", "description": "Variant Identifier"},{"key": "CHROM", "name": "Chromosome", "default": "false", "description": "Chromosome on which variant falls."}, {"key": "POS", "name": "Position", "order": "asc", "default": "true", "description": "position"}, {"key": "REF", "name": "Ref", "default": "true", "description": "reference allele"}, {"key": "ALT", "name": "Alt", "default": "true", "description": "alt allele"}, {"key": "ID", "name": "Rsid", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/variant/", "description": ""}, {"key": "AF", "name": "AF", "default": "true", "description": "Internal allele frequency"}, {"key": "AC", "name": "AC", "default": "true", "description": "Internal allele count"}, {"key": "AN", "name": "AN", "default": "false", "description": "Internal total allele number (including WT)"}, {"key": "HET", "name": "HET", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/individual/", "description": "Het individuals"}, {"key": "HOM", "name": "HOM", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/individual/", "description": "Hom individuals"}, {"key": "DP", "name": "DP", "default": "false", "description": "Depth of sequencing"}, {"key": "FS", "name": "FS", "default": "false", "description": "Fisher Strand"}, {"key": "MLEAC", "name": "MLEAC", "default": "false", "description": "MLEAC"}, {"key": "MLEAF", "name": "MLEAF", "default": "false", "description": "MLEAF"}, {"key": "MQ", "name": "MQ", "default": "false", "description": "MQ"}, {"key": "af_jirdc", "name": "AF jirdc", "default": "true", "description": "Japanese inherited retinal disease consortium allele frequency"}, {"key": "af_krgdb", "name": "AF krgdb", "default": "true", "description": "Korean Genome Database allele frequency"}, {"key": "af_hgvd", "name": "AF hgvd", "default": "true", "description": "HGVD"}, {"key": "af_tommo", "name": "AF tommo", "default": "true", "description": "Tommo"}, {"key": "af_converge", "name": "AF converge", "default": "true", "description": "Chinese consortium"}, {"key": "af_kaviar", "name": "AF kaviar", "default": "true", "description": ""}, {"key": "af_gnomad_genomes", "name": "AF gnomad genomes", "default": "true", "description": ""}, {"key": "cadd", "name": "Cadd", "default": "true", "description": ""}, {"key": "most_severe_consequence", "name": "Most Severe Consequence", "default": "true", "description": "most severe consequence of variant on different transcripts"}, {"key": "impact", "name": "Impact", "default": "false", "description": ""}, {"key": "feature_id", "name": "Feature_id", "default": "false", "description": ""}, {"key": "feature_type", "name": "Feature_type", "default": "false", "description": ""}, {"key": "FILTER", "name": "Filter", "default": "true", "description": "variant filter"}, {"key": "hgvsc", "name": "Hgvs_c", "default": "true", "description": "HGVS cDNA"}, {"key": "hgvsp", "name": "Hgvs_p", "default": "true", "description": "HGVS protein"}, {"key": "dann", "name": "DANN", "default": "true", "description": "DANN score"}, {"key": "cadd_phred", "name": "CADD", "default": "true", "description": "CADD phred score"}]}, "rare_comp_hets": {"data": [], "colNames": [{"key": "gene_symbol", "name": "Gene", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/gene/", "description": "Gene Symbol"}, {"key": "CHROM", "name": "Chromosome", "default": "true", "description": "Chromosome on which variant falls."}, {"key": "POS", "name": "Position", "order": "asc", "default": "true", "description": "position"}, {"key": "REF", "name": "Ref", "default": "true", "description": "reference allele"}, {"key": "ALT", "name": "Alt", "default": "true", "description": "alt allele"}, {"key": "ID", "name": "Rsid", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/variant/", "description": ""}, {"key": "AF", "name": "AF", "default": "true", "description": "Internal allele frequency"}, {"key": "AC", "name": "AC", "default": "true", "description": "Internal allele count"}, {"key": "AN", "name": "AN", "default": "false", "description": "Internal total allele number (including WT)"}, {"key": "HET_COUNT", "name": "HET COUNT", "default": "true", "description": "Number of individuals that are heterozygous in our dataset"}, {"key": "HOM_COUNT", "name": "HOM COUNT", "default": "true", "description": "Number of individuals that are homozygous in our dataset"}, {"key": "WT_COUNT", "name": "WT COUNT", "default": "false", "description": "Number of individuals that are wildtype in our dataset"}, {"key": "HET", "name": "HET", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/individual/", "description": "Het individuals (only 5 are displayedgo to variant page to see all of them)"}, {"key": "HOM", "name": "HOM", "type": "links", "class": "preview_onhover", "default": "true", "base_href": "/individual/", "description": "Hom individuals (only 5 are displayed go to variant page to see all of them)"}, {"key": "DP", "name": "DP", "default": "false", "description": "Depth of sequencing"}, {"key": "FS", "name": "FS", "default": "false", "description": "Fisher Strand"}, {"key": "MLEAC", "name": "MLEAC", "default": "false", "description": "MLEAC"}, {"key": "MLEAF", "name": "MLEAF", "default": "false", "description": "MLEAF"}, {"key": "MQ", "name": "MQ", "default": "false", "description": "MQ"}, {"key": "af_jirdc", "name": "AF jirdc", "default": "true", "description": "Japanese inherited retinal disease consortium allele frequency"}, {"key": "af_krgdb", "name": "AF krgdb", "default": "true", "description": "Korean Genome Database allele frequency"}, {"key": "af_hgvd", "name": "AF hgvd", "default": "true", "description": "HGVD"}, {"key": "af_tommo", "name": "AF tommo", "default": "true", "description": "Tommo"}, {"key": "af_converge", "name": "AF converge", "default": "true", "description": "Chinese consortium"}, {"key": "af_kaviar", "name": "AF kaviar", "default": "true", "description": ""}, {"key": "af_gnomad_genomes", "name": "AF gnomad genomes", "default": "true", "description": ""}, {"key": "cadd", "name": "Cadd", "default": "true", "description": ""}, {"key": "most_severe_consequence", "name": "Most Severe Consequence", "default": "true", "description": "most severe consequence of variant on different transcripts"}, {"key": "impact", "name": "Impact", "default": "false", "description": ""}, {"key": "feature_id", "name": "Feature_id", "default": "false", "description": ""}, {"key": "feature_type", "name": "Feature_type", "default": "false", "description": ""}, {"key": "FILTER", "name": "Filter", "default": "true", "description": "variant filter"}, {"key": "hgvsc", "name": "Hgvs_c", "default": "true", "description": "HGVS cDNA"}, {"key": "hgvsp", "name": "Hgvs_p", "default": "true", "description": "HGVS protein"}, {"key": "dann", "name": "DANN", "default": "true", "description": "DANN score"}, {"key": "cadd_phred", "name": "CADD", "default": "true", "description": "CADD phred score"}]}}]'
where user_name = 'Admin' and page = 'individual' and ("language" = 'cn' or "language" = 'ja');
It's only there, the other tabs seem OK. E.g. https://dev-live.phenopolis.org/individual/PH00008256 See fig.