Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Friday, May 11, 2018 9:47:53 AM(UTC)
Rank: Member


Groups: Registered
Posts: 17


I am looking to include some additional options in the list which displays for the 'Location/Sample Data' when creating Chemistry Output Tables.

In the help (http://www.ESdat.net/ESdathelp/index.html?customising_geology_columns.htm) it says:

The fields listed here are all the Sample, Chemistry, and other fields at the Sample level or higher which are included in the chemistry output queries.  You can select and re-order as you need.  Additional fields can be added to the query/view by an admin user by modifying the query/view in Access or SSMS.

I have not been able to find the view where this list can be modified. Could you please tell me where it is?

Thank you!


Warwick Wood  
#2 Posted : Tuesday, May 15, 2018 3:21:29 PM(UTC)
Warwick Wood
Rank: Administration


Groups: Registered, Administrators
Posts: 406
Location: Byron Bay

Was thanked: 8 time(s) in 8 post(s)

Hi Evelyn,

The link given is to alter the fields in the Geology import templates.  Is that the link you intended to give?

In terms of creating custom views for the chemistry views so you can return additional fields.  The Chemistry Views are as at http://www.ESdat.net/ESdathelp/index.html?outputs.htm.  They can't be modified in ESdat, they can only be modified in SSMS (SQL Server Management Studio) if you are using the Server version (which Hemmera are).  You would need to contact your database admin to add additional fields.



Similar Topics
Lab Dups in Chemistry Output Tables (ESDAT)
by tomb64 9/27/2012 5:40:43 PM(UTC)
Adding Additional Location/Sample Data to Chemistry Output Tables (ESDAT)
by EWatson 9/8/2012 12:26:41 AM(UTC)
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.