Home : LINFO
Q10675 - INFO: LINFO

LINFO returns Location information such as Description, Address, etc for the specified Location.

SYNTAX:

LINFO(Location, Field)

Location: The Location Name or LocId (the internal key field) to retrieve field information for.  Can be a string (i.e. “Influent”),a cell reference (i.e. C2) that contains a string, a numeric id (1), or a cell reference that contains a number. 

Field: Which field to retrieve from the location table.  Valid settings include:

AUDITUSER 
OWNER
AUDITTIMESTAMP 
NOTES
LOCID 
LOCIDTYPE
LOCATION
LOCATION_PATH or PATH - The full location path separated by \. 
CHILDREN_LIST - A comma seperated list of the LOCIDs of the Children (all levels) of the specfied location.
PARENTID - LOCID of Location's Parent.
AREAID
DESCRIPTION 
ACRES
RECORDER 
CROP
SITEADDRESS 
APPSEASONFROM
SITESTATE 
APPSEASONTO
SITECITY 
SITEZIP 
SITECOUNTRY 
SITECONTACT 
SITEEMAIL
SITEPHONE
SOILSERIES
SOILTEXTURE
SOILDRAINAGE
WATERTABLE
LEGALDESC
MAILADDRESS
PERMITNUMBER 
PERMITSTARTDATE 
PERMITENDDATE
MAILSTATE
MAILCITY
MAILZIP
MAILCOUNTRY
MAILCONTACT
MAILEMAIL
MAILPHONE
NAICS_SIC1 
NAICS_SIC2 
UD1 
UD2 
UD3 
UD4 
UD5
UD6
UD7
UD8
UD9
UD10
LOCATION_I.fieldname - The Location Additional Info field specified by fieldname. 

EXAMPLES:

LINFO("INFLUENT","PERMITNUMBER") returns the permitnumber for the location Influent

LINFO(17, "UD2") returns the LOCATION.UD2 field for location id 17. 

LINFO(17,"LOCATION_I.POPULATION_SERVED") returns the LOCATION_I.Population_Served (Additional info field) value for location id 17. 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/27/2008 5:41 PM.
Last Modified on 8/31/2016 2:12 PM.
Last Modified by Scott Dorner.
Article has been viewed 2150 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article