|
|
+
|
CHARACTER FilterByConcatenatedValue (character, character, character, character, character)
|
Rewrites a query filter on a calculated concatenated field into filters on the underlying target fields
Notes : The method parses the query string using QueryParser, locates the expression for pcCalculatedFieldName and
then distributes the entered search value across pcTargetFields based on the number of entries in the value.
The original operator is applied to the last matched entry, preceding entries use EQ, and remaining fields
are constrained to EQ "".
@param pcQueryString The original query string
@param pcTableName The temp-table/buffer name used in the query string (e.g. "eSmartToolbarSecurityItem")
@param pcCalculatedFieldName The calculated field name to replace (without table prefix)
@param pcTargetFields Comma-separated list of target field names (without table prefix)
@param pcDelimiter The delimiter used to split the entered search value
@return A rewritten query string where the filter is applied to the target fields
*/
|
|
|
+
|
CHARACTER GetConcatenatedFieldValue (handle, character, character, logical)
|
Concatenates field values from a delimited list of source fields
Notes : Processes a comma-separated list of field names and concatenates their
values. When comma is used as a delimiter, a space is added between
the field values. For delimiters other than space or dot, a space is added
before and after the delimiter.
@param phBuffer The handle of the source buffer
@param pcSourceFields A comma-delimited list of field names to concatenate
@param pcDelimiter The delimiter to use between field values (default: ",")
@param plSkipEmpties Whether to skip empty field values in the concatenation
@return The concatenated field values with the specified delimiter
*/
|
