Print Values (SQL Placeholder)

From GeoMedia Smart Client
Jump to: navigation, search
Edit Print Layout General Mediasize Projectview Print Values
Print Values SQL Placeholder Image




Blue.pngIf you define an sql placeholder for INFOTEXT for one project for example, then the Assigned values will always remain the same, if you get the INFOTEXT print value.




The example shows you how you get the count of parcels within the printing map extract.

Printlayout define printey.png

Blue.pngHow to set the database connection see here.




You can also define your Placeholder (as static Placeholder or Sql Placeholder) with the SESSION. variable (for example (SESSION.ACTIVEFEATURE)). The following table shows you, which values are available. For more details see (here).

Values Description
ACTIVEFEATURE ID of the active feature
BOTTOM The southernmost ordinate of the selected printing area
BOUNDS The MBR of the selected printing area
CENTER The centered coordinate of the selected printing area
CENTERX The central abscissa of the selected printing area
CENTERY The central ordinate of the selected printing area
DATE Current date
LEFT The westernmost abscissa of the selected printing area
LEFTBOTTOMX The abscissa of the lower-left coordinate of the selected printing area
LEFTBOTTOMY The ordinate of the lower-left coordinate of the selected printing area
LEFTTOPX The abscissa of the upper-left coordinate of the selected printing area
LEFTTOPY The ordinate of the upper-left coordinate of the selected printing area
PROJECT The name of the project
RIGHT The easternmost abscissa of the selected printing area
RIGHTBOTTOMX The abscissa of the lower-right coordinate of the selected printing area
RIGHTBOTTOMY The ordinate of the lower-right coordinate of the selected printing area
RIGHTTOPX The abscissa of the upper-right coordinate of the selected printing area
RIGHTTOPY The ordinate of the upper-right coordinate of the selected printing area
ROTATION The user-defined rotation of the print-out
SCALE The current mapscale
SELECTIONSET The ID's of the selected objects, separated by a comma
TIME The current time
TOP The northernmost ordinate of the selected printing area
USERNAME The name of the current user
VISIBLEFEATURES The ID's of the visible features, separated by a comma



Language: English  • slovenčina