Open carlosmbe opened 1 year ago
maxpatiiuk
commented
1 year ago The issue is not specific to the stats page. Can you please export the query and attach the export json file in here? To export a query, in the list of queries, click on the pencil icon and then "Export" This way, even if we get back to this issue a year later, we would have easy way to reproduce the issue (or make sure that it's fixed).
carlosmbe
commented
1 year ago As requested here is the JSON File for the GPI Query
{
"id": 81,
"contextname": "CollectionObject",
"contexttableid": 1,
"countonly": null,
"formatauditrecids": null,
"isfavorite": true,
"name": "GPI",
"ordinal": 32767,
"remarks": null,
"searchsynonymy": null,
"selectdistinct": false,
"smushed": null,
"sqlstr": null,
"timestampcreated": "2014-10-20T12:40:38",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": null,
"specifyuser": "/api/specify/specifyuser/1/",
"reports": "/api/specify/spreport/?query=81",
"resource_uri": "/api/specify/spquery/81/",
"fields": [
{
"id": 828,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "catalogNumber",
"contexttableident": 1,
"endvalue": null,
"fieldname": "catalogNumber",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 0,
"sorttype": 0,
"startvalue": "",
"stringid": "1.collectionobject.catalogNumber",
"tablelist": "1",
"timestampcreated": "2014-10-20T12:32:09",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=828",
"resource_uri": "/api/specify/spqueryfield/828/"
},
{
"id": 817,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "timestampModified",
"contexttableident": 1,
"endvalue": null,
"fieldname": "timestampModified",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 1,
"sorttype": 0,
"startvalue": "",
"stringid": "1.collectionobject.timestampModified",
"tablelist": "1",
"timestampcreated": "2014-10-20T12:32:19",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=817",
"resource_uri": "/api/specify/spqueryfield/817/"
},
{
"id": 837,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "determinedDate (Day)",
"contexttableident": 9,
"endvalue": null,
"fieldname": "determinedDate",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 2,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.determinedDateNumericDay",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:32:55",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=837",
"resource_uri": "/api/specify/spqueryfield/837/"
},
{
"id": 831,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "determinedDate (Month)",
"contexttableident": 9,
"endvalue": null,
"fieldname": "determinedDate",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 3,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.determinedDateNumericMonth",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:33:02",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=831",
"resource_uri": "/api/specify/spqueryfield/831/"
},
{
"id": 821,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "determinedDate (Year)",
"contexttableident": 9,
"endvalue": null,
"fieldname": "determinedDate",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 4,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.determinedDateNumericYear",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:33:03",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=821",
"resource_uri": "/api/specify/spqueryfield/821/"
},
{
"id": 829,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Determiner",
"contexttableident": 5,
"endvalue": null,
"fieldname": "determiner",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": false,
"isrelfld": true,
"operend": null,
"operstart": 11,
"position": 5,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,5-determiner.agent.determiner",
"tablelist": "1,9-determinations,5-determiner",
"timestampcreated": "2014-10-20T12:33:13",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=829",
"resource_uri": "/api/specify/spqueryfield/829/"
},
{
"id": 842,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "text2",
"contexttableident": 9,
"endvalue": null,
"fieldname": "text2",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 6,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.text2",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:33:16",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=842",
"resource_uri": "/api/specify/spqueryfield/842/"
},
{
"id": 820,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "qualifier",
"contexttableident": 9,
"endvalue": null,
"fieldname": "qualifier",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 7,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.qualifier",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:34:35",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=820",
"resource_uri": "/api/specify/spqueryfield/820/"
},
{
"id": 844,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "yesNo1",
"contexttableident": 9,
"endvalue": null,
"fieldname": "yesNo1",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 8,
"position": 8,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.yesNo1",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:33:20",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=844",
"resource_uri": "/api/specify/spqueryfield/844/"
},
{
"id": 841,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Family",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Family",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 9,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Family",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:33:53",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=841",
"resource_uri": "/api/specify/spqueryfield/841/"
},
{
"id": 822,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Genus",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Genus",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 10,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Genus",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:33:58",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=822",
"resource_uri": "/api/specify/spqueryfield/822/"
},
{
"id": 849,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Species",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Species",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 11,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Species",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:34:56",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=849",
"resource_uri": "/api/specify/spqueryfield/849/"
},
{
"id": 839,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Species Author",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Species Author",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 12,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Species Author",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:34:57",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=839",
"resource_uri": "/api/specify/spqueryfield/839/"
},
{
"id": 843,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Subforma",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Subforma",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 13,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Subforma",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:35:02",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=843",
"resource_uri": "/api/specify/spqueryfield/843/"
},
{
"id": 826,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Subforma Author",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Subforma Author",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 14,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Subforma Author",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:35:03",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=826",
"resource_uri": "/api/specify/spqueryfield/826/"
},
{
"id": 818,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Subspecies",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Subspecies",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 15,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Subspecies",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:35:17",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=818",
"resource_uri": "/api/specify/spqueryfield/818/"
},
{
"id": 823,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Subspecies Author",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Subspecies Author",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 16,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Subspecies Author",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:35:18",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=823",
"resource_uri": "/api/specify/spqueryfield/823/"
},
{
"id": 845,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Subvariety",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Subvariety",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 17,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Subvariety",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:36:38",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=845",
"resource_uri": "/api/specify/spqueryfield/845/"
},
{
"id": 830,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Subvariety Author",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Subvariety Author",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 18,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Subvariety Author",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:36:38",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=830",
"resource_uri": "/api/specify/spqueryfield/830/"
},
{
"id": 836,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Variety",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Variety",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 19,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Variety",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:36:43",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=836",
"resource_uri": "/api/specify/spqueryfield/836/"
},
{
"id": 833,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Variety Author",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Variety Author",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 20,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.Variety Author",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:36:43",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=833",
"resource_uri": "/api/specify/spqueryfield/833/"
},
{
"id": 840,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Cultivar",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Cultivar",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 21,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.cultivar",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:37:33",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=840",
"resource_uri": "/api/specify/spqueryfield/840/"
},
{
"id": 835,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Cultivar Author",
"contexttableident": 4,
"endvalue": null,
"fieldname": "Cultivar Author",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 22,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations,4.taxon.cultivar Author",
"tablelist": "1,9-determinations,4",
"timestampcreated": "2014-10-20T12:37:34",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=835",
"resource_uri": "/api/specify/spqueryfield/835/"
},
{
"id": 832,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "remarks",
"contexttableident": 9,
"endvalue": null,
"fieldname": "remarks",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 23,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.remarks",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:38:36",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=832",
"resource_uri": "/api/specify/spqueryfield/832/"
},
{
"id": 827,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "typeStatusName",
"contexttableident": 9,
"endvalue": null,
"fieldname": "typeStatusName",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 24,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.typeStatusName",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:38:43",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=827",
"resource_uri": "/api/specify/spqueryfield/827/"
},
{
"id": 825,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "confidence",
"contexttableident": 9,
"endvalue": null,
"fieldname": "confidence",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 25,
"sorttype": 0,
"startvalue": "",
"stringid": "1,9-determinations.determination.confidence",
"tablelist": "1,9-determinations",
"timestampcreated": "2014-10-20T12:38:45",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=825",
"resource_uri": "/api/specify/spqueryfield/825/"
},
{
"id": 848,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "Collectors",
"contexttableident": 30,
"endvalue": null,
"fieldname": "collectors",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": false,
"isrelfld": true,
"operend": null,
"operstart": 11,
"position": 26,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10,30-collectors.collector.collectors",
"tablelist": "1,10,30-collectors",
"timestampcreated": "2014-10-20T12:39:05",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=848",
"resource_uri": "/api/specify/spqueryfield/848/"
},
{
"id": 834,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "stationFieldNumber",
"contexttableident": 10,
"endvalue": null,
"fieldname": "stationFieldNumber",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 27,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10.collectingevent.stationFieldNumber",
"tablelist": "1,10",
"timestampcreated": "2014-10-20T12:39:11",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=834",
"resource_uri": "/api/specify/spqueryfield/834/"
},
{
"id": 838,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "remarks",
"contexttableident": 10,
"endvalue": null,
"fieldname": "remarks",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 28,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10.collectingevent.remarks",
"tablelist": "1,10",
"timestampcreated": "2014-10-20T12:39:16",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=838",
"resource_uri": "/api/specify/spqueryfield/838/"
},
{
"id": 846,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "startDate (Day)",
"contexttableident": 10,
"endvalue": null,
"fieldname": "startDate",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 29,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10.collectingevent.startDateNumericDay",
"tablelist": "1,10",
"timestampcreated": "2014-10-20T12:40:11",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=846",
"resource_uri": "/api/specify/spqueryfield/846/"
},
{
"id": 824,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "startDate (Month)",
"contexttableident": 10,
"endvalue": null,
"fieldname": "startDate",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 30,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10.collectingevent.startDateNumericMonth",
"tablelist": "1,10",
"timestampcreated": "2014-10-20T12:40:12",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=824",
"resource_uri": "/api/specify/spqueryfield/824/"
},
{
"id": 847,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "startDate (Year)",
"contexttableident": 10,
"endvalue": null,
"fieldname": "startDate",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 1,
"position": 31,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10.collectingevent.startDateNumericYear",
"tablelist": "1,10",
"timestampcreated": "2014-10-20T12:40:12",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=847",
"resource_uri": "/api/specify/spqueryfield/847/"
},
{
"id": 819,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "verbatimDate",
"contexttableident": 10,
"endvalue": null,
"fieldname": "verbatimDate",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 32,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10.collectingevent.verbatimDate",
"tablelist": "1,10",
"timestampcreated": "2014-10-20T12:40:14",
"timestampmodified": "2014-10-20T14:00:04",
"version": 3,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=819",
"resource_uri": "/api/specify/spqueryfield/819/"
},
{
"id": 856,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "text1",
"contexttableident": 2,
"endvalue": null,
"fieldname": "text1",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 33,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10,2.locality.text1",
"tablelist": "1,10,2",
"timestampcreated": "2014-10-20T12:44:59",
"timestampmodified": "2014-10-20T14:00:04",
"version": 2,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=856",
"resource_uri": "/api/specify/spqueryfield/856/"
},
{
"id": 854,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "localityName",
"contexttableident": 2,
"endvalue": null,
"fieldname": "localityName",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 34,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10,2.locality.localityName",
"tablelist": "1,10,2",
"timestampcreated": "2014-10-20T12:45:16",
"timestampmodified": "2014-10-20T14:00:04",
"version": 2,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=854",
"resource_uri": "/api/specify/spqueryfield/854/"
},
{
"id": 855,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "verbatimElevation",
"contexttableident": 2,
"endvalue": null,
"fieldname": "verbatimElevation",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 35,
"sorttype": 0,
"startvalue": "",
"stringid": "1,10,2.locality.verbatimElevation",
"tablelist": "1,10,2",
"timestampcreated": "2014-10-20T12:45:26",
"timestampmodified": "2014-10-20T14:00:04",
"version": 2,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=855",
"resource_uri": "/api/specify/spqueryfield/855/"
},
{
"id": 857,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "text4",
"contexttableident": 93,
"endvalue": null,
"fieldname": "text4",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 36,
"sorttype": 0,
"startvalue": "",
"stringid": "1,93.collectionobjectattribute.text4",
"tablelist": "1,93",
"timestampcreated": "2014-10-20T12:45:43",
"timestampmodified": "2014-10-20T14:00:04",
"version": 2,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=857",
"resource_uri": "/api/specify/spqueryfield/857/"
},
{
"id": 852,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "text2",
"contexttableident": 93,
"endvalue": null,
"fieldname": "text2",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 37,
"sorttype": 0,
"startvalue": "",
"stringid": "1,93.collectionobjectattribute.text2",
"tablelist": "1,93",
"timestampcreated": "2014-10-20T12:45:45",
"timestampmodified": "2014-10-20T14:00:04",
"version": 2,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=852",
"resource_uri": "/api/specify/spqueryfield/852/"
},
{
"id": 853,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "remarks",
"contexttableident": 93,
"endvalue": null,
"fieldname": "remarks",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 38,
"sorttype": 0,
"startvalue": "",
"stringid": "1,93.collectionobjectattribute.remarks",
"tablelist": "1,93",
"timestampcreated": "2014-10-20T12:45:49",
"timestampmodified": "2014-10-20T14:00:04",
"version": 2,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=853",
"resource_uri": "/api/specify/spqueryfield/853/"
},
{
"id": 858,
"allownulls": false,
"alwaysfilter": null,
"columnalias": "projectNumber",
"contexttableident": 1,
"endvalue": null,
"fieldname": "projectNumber",
"formatname": null,
"isdisplay": true,
"isnot": false,
"isprompt": true,
"isrelfld": false,
"operend": null,
"operstart": 11,
"position": 39,
"sorttype": 0,
"startvalue": "Mellon",
"stringid": "1.collectionobject.projectNumber",
"tablelist": "1",
"timestampcreated": "2014-10-20T12:46:06",
"timestampmodified": "2014-10-20T14:00:04",
"version": 1,
"createdbyagent": "/api/specify/agent/100314/",
"modifiedbyagent": "/api/specify/agent/100314/",
"query": "/api/specify/spquery/81/",
"mappings": "/api/specify/spexportschemaitemmapping/?queryfield=858",
"resource_uri": "/api/specify/spqueryfield/858/"
}
]
}The query references a cultivar rank name but the tree contains a cultivarsp rank name instead:
@carlosmbe when you say you created a query in sp6, did you create it in the same database, or did you export it from one database and use the query in a different database? or did you edit the taxon tree definition?
Possibly related to https://github.com/specify/specify7/issues/3337
carlosmbe
commented
1 year ago @maxpatiiuk It is a legacy query that was created a while back(9 Years ago). Most likely created in SP6 as when I tested it there it worked fine.
maxpatiiuk
commented
1 year ago Hmm, very interesting that it works correctly in sp6. Does sp6 show you an error dialog like this (https://github.com/specify/specify7/issues/3337#issuecomment-1508911797) or does it just work?
carlosmbe
commented
1 year ago @maxpatiiuk Two things: Firstly, made an edit to my comment earlier. This issue could be a duplicate of #3340. However, I did not use the same query as last time.
That brings me to the second point, I no longer see the original GPI in Specify 6. Most likely #3349
I assume Specify handles it automatically(Unless someone else did it and I'm not aware) because GPI (2) was created when I logged into 7 and was usable in SP6.
GPI (2) was not present in the Database when I first wrote this issue. I have a copy of the database from the time and it is not there.
maxpatiiuk
commented
1 year ago This issue is more generic than that and is about handling of non-existent tree ranks (and sp6 does a better job of it by showing a dialog to the user, rather than just crashing like sp7)
carlosmbe
commented
1 year ago Visited the Database for the first time in a while today. New GPI (2) was created automatically.
emenslin
commented
2 months ago Can recreate the original issue in edge (7.9.6), not sure about the other issues in the comments as I had to import the query into a different db
Describe the bug As found out through the investigation of #3340 that some queries created and saved in Specify 6 can have fields that 7 treats as unmapped. When one of these queries is imported into the stats page. It just produces a stat called "Error"
This normally wouldn't be an issue as 7 doesn't let you save a query with unmapped fields.
To Reproduce Steps to reproduce the behavior:
DAO_TestDatabase and log in ashacole. Enter theHerbarium CollectionGPIquery to any statExpected behavior A more intuitive description of the error. Or refusal to allow queries with unmapped fields
Screenshots If applicable, add screenshots to help explain your problem.
Desktop: OS: Mac OSx Ventura Browser: Chrome Specify 7 Version: 7.8.10-prerelease
Database Name:
DAO_TestReported By @carlosmbe