populateFromQueryWithPrefix

Populates an Object using only specific columns from a query. Useful for performing a query with joins that needs to populate multiple objects.

Returns

• This function returns any

Arguments

The structure to populate the object with.

Key	Type	Required	Default	Description
target	any	Yes	---	This can be an instantiated bean object or a bean instantiation path as a string. If you pass an instantiation path and the bean has an 'init' method. It will be executed. This method follows the bean contract (set{property_name}). Example: setUsername(), setfname()
qry	query	yes	---	The query to populate the bean object with
rowNumber	Numeric	No	1	The query row number to use for population
scope	string	No		Use scope injection instead of setters population. Ex: scope=variables.instance.
trustedSetter	boolean	No	false	If set to true, the setter method will be called even if it does not exist in the bean
include	string	No		A list of keys to include in the population
exclude	string	No		A list of keys to exclude in the population
prefix	string	Yes	---	The prefix used to filter, Example: 'user_' would apply to the following columns: 'user_id' and 'user_name' but not 'address_id'.
ignoreEmpty	boolean	No	false	Ignore empty values on populations, great for ORM population
nullEmptyInclude	string	No		A list of keys to NULL when empty
nullEmptyExclude	string	No		A list of keys to NOT NULL when empty
composeRelationships	boolean	No	false	Automatically attempt to compose relationships from memento