What is the relationship between profiles and the SCHEM/LCHEM queries in SQL...

Welcome Guest! To enable all features please Login or Register.

Notification

Error

What is the relationship between profiles and the SCHEM/LCHEM queries in SQL from backend?

Options

Previous Topic Next Topic

JKW		#1 Posted : Monday, January 14, 2013 8:26:23 PM(UTC)
Rank: Advanced Member Reputation: Groups: Registered Posts: 79		We are looking to connect GIS applications to the backend of ESdat. The issue is that some analytes only report under particular profiles (where the output units are defined) The ESdat frontend resolves itself by the selection of the profile. However if the backend is connected to - how do the profiles interact with the SChem/ LChem queries? It looks like its defaulting to Profile 1? JKW


User Profile View All Posts by User View Thanks


	Wanna join the discussion?! Login to your ESdat Forums forum account or Register a new forum account.

Warwick Wood		#2 Posted : Monday, January 14, 2013 8:52:11 PM(UTC)
Rank: Administration Reputation: Groups: Registered, Administrators Posts: 498 Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)		The SQL Server version of ESdat allows different "Profiles" of output units to be defined. The profile is stored against each users UserName, which is referenced in the output views: thus it doesn't matter if you are accessing the view directly by some other application, the view will still return data for the Profile selected for that user (Typically their Windows Login). The view will also only return data for the Site(s) that the User has selected to use in ESdat. Warwick
		WWW

User Profile View All Posts by User View Thanks

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.