Localisation Set

Table

Database	Table	Entity	On Key 5 Conversions	On Key 5 Tables	Other Entities stored in same Table
Transaction	gen.localisation_set	Localisation Set	ConvertLocalisationKey ConvertLocalisationTranslation	stdPhrases stdPhraseTranslations

Columns

Property	Db Table	Db Column	Db DataType	Nullable	Primary Key	Joins
CreatedByUserId	gen.localisation_set	created_by_user_id	bigint	False
CreatedByUserCode	uam.user	code	character varying(50)	False		gen.localisation_set.created_by_user_id = uam.user.user_id
CreatedByUserFullName	uam.user	full_name	character varying(200)	False		gen.localisation_set.created_by_user_id = uam.user.user_id
CreatedOn	gen.localisation_set	created_on	timestamp without time zone	False
ModifiedByUserId	gen.localisation_set	modified_by_user_id	bigint	False
ModifiedByUserCode	uam.user	code	character varying(50)	False		gen.localisation_set.modified_by_user_id = uam.user.user_id
ModifiedByUserFullName	uam.user	full_name	character varying(200)	False		gen.localisation_set.modified_by_user_id = uam.user.user_id
ModifiedOn	gen.localisation_set	modified_on	timestamp without time zone	False
Version	gen.localisation_set	version	integer	False
Id	gen.localisation_set	localisation_set_id	bigint	False	True
Description	gen.localisation_set	description	character varying(100)	False
IsSystem	gen.localisation_set	is_system	boolean	False
Name	gen.localisation_set	name	character varying(50)	False
Notes	gen.localisation_set	notes	text	True
Type	gen.localisation_set	type	system.localisation_set_type	False

Enumerations

Mapping 1

Property	Property Type	Db Column	Db Column Type	Db Column Values
Type	LocalisationSetType	type	system.localisation_set_type	Phrases UI ValueLists Messages

Queries

The list of example Localisation Set queries can be interpreted using the following legend:

Legend	Description
Primary Table Alias	The alias for the gen.localisation_set table in the query
Include References	Include (true) or exclude (false) all lookup table joins in the query
Include Permissions	Include (true) or exclude (false) the permission table join in the query to enforce or skip row-level security based on the permissions for the user

Query 1

Primary Table Alias	Include References	Include Permissions
_ls	False	False

SELECT
    _ls.created_by_user_id AS "CreatedByUserId",
    _ls.created_on AS "CreatedOn",
    _ls.modified_by_user_id AS "ModifiedByUserId",
    _ls.modified_on AS "ModifiedOn",
    _ls.version AS "Version",
    _ls.localisation_set_id AS "Id",
    _ls.description AS "Description",
    _ls.is_system AS "IsSystem",
    _ls.name AS "Name",
    _ls.notes AS "Notes",
    _ls.type AS "Type"
FROM
    gen.localisation_set _ls

Query 2

Primary Table Alias	Include References	Include Permissions
_ls	True	False

SELECT
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _ls.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _ls.modified_on AS "ModifiedOn",
    _ls.version AS "Version",
    _ls.localisation_set_id AS "Id",
    _ls.description AS "Description",
    _ls.is_system AS "IsSystem",
    _ls.name AS "Name",
    _ls.notes AS "Notes",
    _ls.type AS "Type"
FROM
    gen.localisation_set _ls
    JOIN uam.user _u ON _ls.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _ls.modified_by_user_id = _u1.user_id