Wiki Detay | wiki workcube

It is a process that allows the user to quickly find and select data from the database or a list of pre-determined values while typing. With Autocomplete, the data to be selected is quickly accessible to the user without tiring the database.

For Autocomplete, queries are written into the workdata folder and the search is performed using the Autocomplete_Create() function.

AutoComplete_Create() Function

Parameters

Attributes	Description
AutocompleteId	Specifies the id of the text field to be searched.
findfield	Specifies the list of fields to search from the database. Relevant fields should be sent separated by commas.
visible_field	Specifies the fields that will appear in the drop-down list during the search process. Relevant fields should be sent separated by commas. The separation process is done on the screen using the \| separator.
query	Specifies the workdata name to search for.
extra_params	Specifies the parameters to be used in Query. While numeric data such as '1,3,2' can be sent, both string and numeric data such as 1,\'2\',3' can be sent.
datafield	As a result of the search process, it is determined which fields will be retrieved from the database. Relevant fields should be sent separated by commas.
formfield	Specifies which fields in the form the values coming from the query as a result of the search process will be written to. Relevant fields should be sent separated by commas.
isNotDeleting	Added so that if autocomplete cannot find a value when a value is entered into the input, the written value will not be deleted when the div is closed. Default 0 was assigned to avoid errors. 1 is not deleted when sent.

EXAMPLE:
onFocus="AutoComplete_Create('emp_name','MEMBER_NAME','MEMBER_NAME', 'get_member_auto complete','\'3\',0,0,0,2,1,0,0,1',',EMPLOYEE_ID', 'project_emp_id','list_works','3','250');">

WORKDATA FILES

Workdata	Description
get_member_autocomplete.cfm	Retrieves all active members based on search criteria. If the select_list expression is 1, then the corporate is listed, if it is 2, the individual is listed, and if it is 3, the employees are listed.
get_project.cfm	Lists projects according to the incoming project_name parameter.
get_ship_method.cfm	Shipping methods are listed according to the incoming ship_method parameter.
get_department_location.cfm	Depots and locations are listed according to the incoming department_head parameter.
get_brand.cfm	Lists the brands according to the incoming brand_name parameter.
get_product_cat.cfm	Lists the product categories according to the incoming product_name parameter.
get_product_model.cfm	Lists product models according to the incoming model_name parameter.
get_city.cfm	Lists cities according to the incoming city_name parameter.
get_county.cfm	Lists the counties affiliated to cities according to the incoming city_id and county_name parameters.
get_country_autocomplete.cfm	Lists the countries according to the incoming country_name parameter.
get_account_code.cfm	Lists the accounting codes according to the incoming account_code parameter.
get_branch_dep.cfm	Lists the departments affiliated to the branch according to the incoming branch_id parameter.
get_branch_name.cfm	Lists branches according to the Position Code parameter.
get_branch.cfm	Lists the branches affiliated to the company according to the incoming company_id parameter.
get_addressbook.cfm	Lists e-mail addresses according to the incoming string parameter.
get_asset_cat.cfm	Lists asset categories according to the incoming assetcat_name parameter.
get_work.cfm	Lists the jobs according to the incoming work_name parameter.
get_product_autocomplete.cfm	Lists all active products that match the searched criteria.
get_station.cfm	Lists product stations according to the incoming station_name parameter.
get_emp_pos.cfm	Lists employee information according to the incoming fullname parameter.
get_budget_workgroup_autocomplete.cfm	Lists workgroups according to the incoming parameter.
get_employee_hr.cfm	Lists employee information for HR according to the incoming string parameter.
get_subscription.cfm	Lists subscriber information according to the incoming subscription parameter. When the select_list parameter is 1, it lists consumer and partner employees, when it is 2, only the system number is listed.
get_bankbranch_autocomplete.cfm	Lists bank branches according to the incoming bank_name parameter.
get_expense_center.cfm	Lists the cost center information according to the incoming expense_center_name parameter.
get_expense_item.cfm	Lists budget item information according to the incoming expense_item_name parameter.
get_assetp_space.cfm	Lists space information according to the incoming space_name parameter.
get_assetp_vehicle.cfm	Lists asset information according to the incoming assetp_name parameter.
get_assetp_autocomplete.cfm	If the select_list parameter is 1, physical assets are listed, if it is 2, vehicles and if it is 3, IT assets are listed.
get_assetp_autocomplete.cfm	Lists space information according to the incoming space_name parameter.

Feedback

erdem kucur - 19/02/2026

Did you find this content helpful?

2 0

Please Write Your Feedback!

Name*

Last Name*

Email *