ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions
  • Effect of the function
  • Use conditions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Enables input in the the search area in the column title of the Table or Treeview Table control.
  • WINDEV In WINDEV:
  • Android In Android:
This function has the same effect as when the user clicks the search icon. It can start a search or implement a filter on the control.
To cancel a filter started by TableInputSearch, simply use TableDisableFilter.
Remark: This function is ignored if the specified Table control uses a non-proportional scrollbar ("Proportional scrollbar" unchecked in the "Details" tab of the control description window). For more details on the magnifier, see Characteristics of columns in a Table control.
Example
// Switches the column COL_Date of the TABLE_TABLE1 control to edit mode
TableInputSearch(TABLE_TABLE1.COL_DATE)
// Switches the COL_Name column to edit mode
TableInputSearch(COL_NAME)
Syntax
TableInputSearch(<Column> [, <Type of filter or search> [, <Initial value>]])
<Column>: Control name
Name of column that will be switched to search mode. The function has no effect if this operation cannot be performed on this column (non-key column for example).
The name of the column can be given directly or in the following format: <Table control>.<Column>.
Java The column used must be a "Searchable" column ("General" tab of the column description).
<Type of filter or search>: Optional Integer constant
Type of filter to apply or type of search to perform:
filterContainsDisplays the rows whose value for the specified column "Contains" the characters specified in <Initial value>.
filterDifferentDisplays the rows whose value for the specified column "differs" from the characters specified in <Initial value>.
filterDoesNotContainDisplays the rows whose value for the specified column "does not contain" the characters specified in <Initial value>.
filterDoesNotEndWithDisplays the rows whose value for the specified column "does not end with" the characters specified in <Initial value>
filterDoesNotStartWithDisplays the rows whose value for the specified column "Does not start with" the characters specified in <Initial value>.
filterEndsWithDisplays the rows whose value for the specified column "ends with" the characters specified in <Initial value>.
filterEqualDisplays the rows whose value for the specified column "is equal" to the characters specified in <Initial value>.
filterGreaterDisplays the rows whose value for the specified column "is greater" than the characters specified in <Initial value>.
filterGreaterOrEqualDisplays the rows whose value for the specified column "is greater than or equal to" the characters specified in <Initial value>.
filterLessDisplays the rows whose value for the specified column "is less" than the characters specified in <Initial value>.
filterLessOrEqualDisplays the rows whose value for the specified column "is less than or equal to" the characters specified in <Initial value>.
filterStartsWithDisplays the rows whose value for the specified column "Starts with" the characters specified in <Initial value>.
searchDefault
(Default value)
Sorts the table according to the specified column and switches the column to search mode.
searchStartsWithSorts the table according to the specified column, switches the column to search mode and fills the edit control of the column with the characters specified in <Initial value>. Displays the rows from the ones for which the value of the specified column "starts with" the characters specified in <Initial value>.

AndroidiPhone/iPadJava This parameter is not available.
<Initial value>: Optional character string
Initial value that must be specified in the input area of search mode.
AndroidiPhone/iPadJava This parameter is not available.
Remarks

Effect of the function

This function will have no effect if the switch to search mode cannot be performed. For example, the search mode will not be enabled:
  • If the column was not defined as column with search (description window of the control).
  • If the column is not associated with a key item.

Use conditions

This function is available on:
  • a Table or TreeView Table control based on a data file.
  • a Table or TreeView Table control populated programmatically.
  • WEBDEV - Browser code a Table control in "Browser" mode.
WEBDEV - Browser code The TreeView Table control is not available.
Component: wd300obj.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
exemplo pesquisa
https://windevdesenvolvimento.blogspot.com/2021/05/dicas-3323-windev-webdev-mobile.html

https://youtu.be/-kWcysbzyQU

// procedure abre_pesquisa()
SWITCH COMBO_ordem
CASE 1
TableInputSearch(COL_Cliente_wdID)
CASE 2
TableInputSearch(COL_Nome)
CASE 3
TableInputSearch(COL_Email)
OTHER CASE
END
amarildo
06 May 2021
Small note
the TableInputSearch(MyTable.MyColumn, ...) function opens the search-field above the column but doesn't show the cursor.

TableInputSearch(MyTable.MyColumn,SearchDefault)
ReturnToCapture(MyTable.MyColumn)

will cure that and enable users to input a search value without having to click the search field first.
Guenter
12 Jul. 2017

Last update: 06/20/2022

Send a report | Local help