Tuesday, May 10, 2022
Tip of the Day: Added Condition for PROPERTY TABLE Command Searches
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.4.20421 or higher
Sections......: Forms
Keywords......: Search, PROPERTY, Table, Equals, Contains
Did you know that form searches performed with
the PROPERTY command may now use exact criteria?
By default, the search functionality uses
CONTAINS as the condition. If a search is
performed for the value "10", the result will
return anything that has 10 in it, such as 710, A10, 100, 1010, etc.
Syntax:
PROPERTY TABLE FormTableName SEARCH->FormColumnName-> VarName
The added EQUAL condition allows searches to
always retrieve the exact record desired.
To search using EQUALS (exact search), add a
equal character and enclose the search criteria
in double quotes; "=(" and ")" .
PROPERTY TABLE 'ContactCallNotes' 'SEARCH->CallNotes->=(SearchText)'
The EQUALS criteria also provides more efficient
usage, where with proper indexing the retrieval is faster.
Notes:
. The parameter is supported for the PROPERTY command only.
. The search method uses CONTAINS (partial
search) by default to locate any text, which matches the provided criteria.
. To search using EQUALS (exact search), add a
equal character and enclose the search criteria
in double quotes; "=(" and ")" .
Example 01:
--Where the following command is used within a "On DB Grid Cell Click" EEP
--and a Variable Edit field "contains" the search criteria.
--GETPROPERTY DBGrid_Customer CurrentColumnName vColumnName
SET VAR vSearchString TEXT = NULL
SET VAR vSearchString = +
('PROPERTY TABLE Customer SEARCH->'+.vColumnName+'->'+.vSearchValue)
&vSearchString
RETURN
Example 02:
--Where the following command is used within a "On DB Grid Cell Click" EEP
--and a Variable Edit field "equals" the search criteria.
--GETPROPERTY DBGrid_Customer CurrentColumnName vColumnName
SET VAR vSearchString TEXT = NULL
SET VAR vSearchString = +
('PROPERTY TABLE Customer SEARCH->'+.vColumnName+'->=('+.vSearchValue+')')
&vSearchString
RETURN
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.com
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0MEovc-1nYS7U3y9q-00G4bJ%40mrelay.perfora.net.
