-
Type:
Bug (Testing)
-
Status: Closed
-
Priority:
Major
-
Fix Version/s: GW Prod Release 1.0
Hi Denby,
There are some problems with the output from the group selection and download. I uploaded a list (attached) and didn't receive all the data in the spreadsheet (also attached).
This was missing or wrong:
1. Water level tab.Measurement point (mAHD) and Natural surface (mAHD) values not the latest values from the HYDRLMP table. See 58112 for eg. This has 194.04 and 193.4 respectively as values and the latest ones are 194.13 and 193.51.
2. Field chemistry tab. Vol Water purged (890) and EC (820) values not coming across.
a)Vol water purged - why is this variable empty now? Where is this now stored?
b)Does EC (820) it have something to do with not picking up on variables with .##'s? I've added a list of variables with . in them which I did a count of in SQL Server
SELECT distinct([VARIABLE]), COUNT([VARIABLE]) as "count of variable"
FROM [hydstra].[dbo].[HYDMEAS]
where VARIABLE like '%.%'
group by VARIABLE
order by VARIABLE
3. Lab Chem Tab. "Paramater names" and "units of measure" values - not all coming through, just blank spaces.
Thanks,
Emma
Thanks,
Emma
There are some problems with the output from the group selection and download. I uploaded a list (attached) and didn't receive all the data in the spreadsheet (also attached).
This was missing or wrong:
1. Water level tab.Measurement point (mAHD) and Natural surface (mAHD) values not the latest values from the HYDRLMP table. See 58112 for eg. This has 194.04 and 193.4 respectively as values and the latest ones are 194.13 and 193.51.
2. Field chemistry tab. Vol Water purged (890) and EC (820) values not coming across.
a)Vol water purged - why is this variable empty now? Where is this now stored?
b)Does EC (820) it have something to do with not picking up on variables with .##'s? I've added a list of variables with . in them which I did a count of in SQL Server
SELECT distinct([VARIABLE]), COUNT([VARIABLE]) as "count of variable"
FROM [hydstra].[dbo].[HYDMEAS]
where VARIABLE like '%.%'
group by VARIABLE
order by VARIABLE
3. Lab Chem Tab. "Paramater names" and "units of measure" values - not all coming through, just blank spaces.
Thanks,
Emma
Thanks,
Emma