Workcube Wiki

Autocomplete and Ready to Use Workdata

It is a function that allows the user to access the data quickly without the need to open a popup.

It is a process that allows the user to quickly find and select data from the database or from a list of predetermined values as they type. With Autocomplete, the user can quickly access the data to be selected without tiring the database.

For Autocomplete, queries are written in the workdata folder and the search is performed by using it with the Autocomplete_Create() function.

AutoComplete_Create() Function

Parametreler

Attributes
Clarification
AutocompleteId
Specifies the id of the text field to be searched.
findfield
Specifies the list of fields to be searched 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. Separation is done with the | separator on the screen.
query
Specifies the workdata name to search.
extra_params
Specifies the parameters to use in the Query. While numeric data such as '1,3,2' can be sent, both string and bear data such as 1,\'2\',3' can be sent.
datafield
As a result of the search process, it is determined which fields to be retrieved from the database. Relevant fields should be sent separated by commas.
formfield
It specifies which fields in the form the values from the query will be written as a result of the search process. Relevant fields should be sent separated by commas.
isNotDeleting
Added so that if the input cannot find autocomplete when a value is entered, the value is not deleted when the div is closed. Default 0 is assigned to prevent error. It is not deleted when 1 is sent.


For Example :


WORKDATA FILES

Workdata
Clarification
get_member_autocomplete.cfm
Returns all active members based on search criteria. If the select_list expression is 1, it is corporate, if 2 is individual, if it is 3, employees will be listed.
get_project.cfm
It lists the projects according to the incoming project_name parameter.
get_ship_method.cfm
Shipment methods are listed according to the incoming ship_method parameter.
get_department_location.cfm
Stores and locations are listed according to the incoming department_head parameter.
get_brand.cfm
It lists the brands according to the incoming brand_name parameter.
get_product_cat.cfm
It lists the product categories according to the incoming product_name parameter.
get_product_model.cfm
It lists the product models according to the incoming model_name parameter.
get_city.cfm
Lists the cities according to the incoming city_name parameter.
get_county.cfm
It lists the counties connected to the cities according to the incoming city_id and county_name parameters.
get_country_autocomplete.cfm
It 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
It lists the departments connected to the branch according to the incoming branch_id parameter.
get_branch_name.cfm
Lists the branches according to the Position Code parameter.
get_branch.cfm
It lists the branches connected 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
It lists the asset categories according to the incoming assetcat_name parameter.
get_work.cfm
It lists the jobs according to the incoming work_name parameter.
get_product_autocomplete.cfm
Lists all active products according to the search criteria.
get_station.cfm
Lists the product stations according to the incoming station_name parameter.
get_emp_pos.cfm
Lists the employee information according to the incoming fullname parameter.
get_budget_workgroup_autocomplete.cfm
It lists the workgroups according to the incoming parameter.
get_employee_hr.cfm
Lists the employee information for HR according to the incoming string parameter.
get_subscription.cfm
Lists the subscriber information according to the incoming subscription parameter. When select_list parameter is 1, it lists the consumer and partner employees, when it is 2, only the system number is listed.
get_bankbranch_autocomplete.cfm
It lists the bank branches according to the incoming bank_name parameter.
get_expense_center.cfm
It lists the expense center information according to the incoming expense_center_name parameter.
get_expense_item.cfm
It lists the budget item information according to the expense_item_name parameter.
get_assetp_space.cfm
It lists the space information according to the incoming space_name parameter.
get_assetp_vehicle.cfm
Lists the 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 2, vehicles and 3, IT assets are listed.
get_assetp_autocomplete.cfm
It lists the space information according to the incoming space_name parameter.

Feedback

Did you find this content helpful?