☰ Menu WKA Studio Help  
     
 
  • Getting Started
    • WKA Studio Cookbook
  • WKA Studio Interfaces
    • Global Variable
      • Basic Parameters
        • Adding New Variable
        • Contains Var Name
        • Compound or Trend Var
        • Is retain value
        • Is use value across apps
        • Todays Date
        • Import vars from CSV files
        • Date Min Max option
        • Represent Date Part
        • Use for YN pattern
        • Is compound with weights
        • Clone Var Group
      • Input Options
        • Setting Simple Menu
        • Setting Dynamic Menu
      • Formatting Options
        • Show Image Option
        • Display Format Option
        • Title and Tool Tip Option
        • Is show Lang output
        • Is Capitalize Each Word
        • ID Creation Format
      • HTML Options 1
        • Prompt and Description
        • Setting Control Options
          • RadioBoxList
          • Combo-List
          • RadioBoxList 1
          • CheckBoxList
          • Combo MultiSelect
          • Range Scrollbar
          • Password
          • AutoComplete
          • Hidden
        • Removing Back Button
        • Button Caption
        • Disabling the Back Date
        • Is use to backtrack
        • Is search page
        • Max Selected Option
        • CSS1
        • Disable buttons
        • Validation Options
        • Length
        • Is control disabled
        • Is populate from DB
        • Is use virtual keyboard
        • Is skip prev button
        • Is skip next button
        • Javascript Event
        • Page Time
        • Alignment
      • HTML Options 2
        • Form Title
        • Add Image to Variable
        • JavaScript Validation
        • Multilingual Option
        • Free Script
      • Report Options
        • Report Parameters
        • Report Flags
      • Layout
    • Menu and Lists
      • Menu Parameters
        • Creating Menu
        • Menu Using Text File
        • Creating Dynamic Menu
        • Multilingual Menu
      • Menu Element Parameters
        • Adding Options
        • Changing Code
        • Adding Menu Images
        • Adding Description
        • Inference And Advice
        • Alternate Values
        • Adding Ask Variables
        • Copying Menu Options
        • Removing Menu
        • Restoring Menu
        • Is Display
        • Menu with PNG Images
    • Score and Ranges
      • Adding Range ID
      • Conversion Similarity Values
        • Numeric Range List
        • Symbolic Range List
        • Database Range List
        • Importing Text File
      • Similarity Function Parameters
    • Lookup Tables
      • Adding Lookup Table
      • Creating Dynamic Query
      • Loading Lookup Table
    • Generic Attributes
      • Creating New ID
      • Is represents var group
      • Attribute with Values
      • Language for Names
      • Scaling Factor
      • Generic Values
      • Generic Value Scales
      • Default Value
      • Language Translation
      • Scan Synonyms
      • Using UDF
      • Removing Attribute ID
    • Expert System
      • Basic Options
      • Adding Rule
      • Creating Web Page
      • Renaming Rules
      • Creating Forms
      • Other Features
      • Linked Apps
    • User Defined Function
      • Purposes
        • General
        • WhenAdded
        • WhenNeeded
        • DBFunction
      • Removing UDF
      • Restore UDF
      • Adding Description
      • Python Functions
    • Expression Evaluator
      • Executing Expressions
      • Storing Expressions
      • Updating Expressions
      • Removing Expressions
    • Form and Report Designer
      • Form Parameters
        • Add New Form
        • Form For Compound Var
        • Creating Multilingual Form
        • Multi Data Entry Form
        • Is Batch DB Operation
        • Form Header
        • Changing Prompt of Variable
        • Flags and App
        • Other Form Variables
        • Clone Form
      • Table Parameters
        • Add New Table
        • Adding Multiple Table
        • Adding Table Within Table
        • Table As Inner Table
        • Condition For Table
        • CSS For Table
        • Horizontal Layout
        • Table Options
      • Row Parameters
        • Hiding Row
        • Is Disable Only
        • Is Make Invisible
        • Is Repeat Row
        • Row Options
      • Cell Parameters
        • Removing Column
      • Cell Content Parameters
        • Adding Image
        • Adding Graph
        • Adding Menu Image
        • Variable Value Option
        • Adding JavaScript
        • Disabling Control
        • Is Skip TD Tag
        • Password Control
        • Adding Frame
        • Displaying SQL Report
        • Displaying Graph
        • Displaying FreeControl
        • FreeScript Buttons
        • Populate Value
        • Call UDF Result
        • Style1 Option
        • DB Operation Buttons
        • Element Options
        • Filter Frame
        • Expression Content Type
        • FreeControls
        • PostFuns Script
        • Image File Or URL
        • Session Variables
      • Formatting Parameters
        • Formatting a Form
        • Formatting a Cell
      • Report Designer Options
        • Report Designing
        • Button Control
        • Flags
        • Calculations
        • Report URL Parameters
      • PDF Options
        • Page Setup Options
        • PDF Parameters
        • Table Parameters
        • Cell Parameters
    • Database Connection
      • Basic Options
      • Adding Connections
        • Excel Connection
        • MySQL Connection
      • Linking from DB
      • Overwritting File
      • Remove File
    • Dynamic Queries
      • Purposes
        • DynamicField
        • DatabaseMenu
        • NumericRangeList
        • DatabaseRangeList
        • DynamicMenu
        • Lookup
      • Renaming Dynamic Query
      • Removing Dynamic Query
      • Restoring Dynamic Query
      • Test Query
      • Insert Field
        • Dynamic Menu
        • Database Menu
      • Mandatory Variables
      • Clone Dynamic Queries
      • Skip Key Variable
    • Variable Database Mapping
      • Variable DB Mapping
      • View Mapping
      • Field Content Type
        • Normal
        • UDF
        • Lookup
        • Variable and Value
        • VariableValuePair
      • Transform Range ID
      • Add Variable
      • Clone
    • Database Schema Designer
      • SQL Script Files
      • Field Mappings
        • Adding Field Mapping
        • Updating Mapped Fields
        • Using DB Functions
        • Using UDF
      • Field Schema
        • Adding New Fields
        • Moving Field
        • Renaming Field
        • Removing Field
        • Updating Field Details
        • Add for Attachment
      • Table Schema
        • Adding Table
        • Create Copy of Table
        • Constraints
        • Removing Constraints
        • Character Set and Collation
        • Is use as base table
        • Update Char Set
        • Table script
        • Create Index
      • Query Operations
        • Create View
        • Rename View
        • Updating View
        • Drop View
        • Drop Table
        • Executing DML Queries
        • Executing TCL Queries
        • ShowRoutine
      • Script File
      • Group DB Object
      • System Table
    • Query Builder
      • Retrieving Data
      • Resetting Queries
      • Executing Direct Query
      • Parsing Query
      • Storing Query in ScriptFile
      • Understanding SQL Functions
      • Showing Chart
      • Options
    • Data Import and Transfer
      • Import Data
      • Remove Data Source
      • Update Data Source
      • Insert Data Source
      • Show Export Data
    • Data Entry
      • Inserting Data in Table
      • Updating Records
      • Deleting Records from Table
    • Variable Spreadsheet Mapping
      • Testing Mapping
    • Manage App
      • Image CSS
      • Allow Signup and Access
      • Loading App
    • Manage Files
      • Viewing List of Files
      • Downloading a File
      • Deleting a File
      • Editing a File
      • Copy Platform System Files
      • Uploading Files to App Grp
      • Uploading Images to App Grp
      • Files in selected project system
    • Roles and Access Rights
      • Role ID
      • Role Access Details
      • API Key Management
      • User Management
    • Project Config
    • Project Groups
      • Uploading Zip File
      • Backup of Application
      • Downloading Zip File
      • Backup of All Files
      • Restoring all Files
      • Viewing Errors
      • Show Load Status
      • Refresh Script Variables
      • Last Updates
      • Operation Log And Clear Log
    • Manage Tenants
      • Creating Tenant
      • Creating Project
      • Login to Project
      • Manage Projects
      • Tenant Operations
  • Tutorials
    • Expert System Apps
      • Multilingual Application
      • Developing ES in Excel
      • Expert System for FAQ
      • Developing ES App
      • Developing Math App
      • Modifying ES based App
      • Confidence Factor in ES
      • ES from R Rules
      • ES from Excel Sheet
      • Adding procedural logic to ES
      • Uploading Files
      • Adding Keywords to ES
      • Modifying app for form based input
      • Saving and Loading Sessions
      • ES Apps using APIs
      • Barcode and QRcode
    • DB Apps
      • Developing DB Apps
      • Modifying DB Apps
      • Multiple data entry form
    • CBR Apps
      • CBR Apps through APIs
      • CBR App using WKA
      • CBR Apps in Feature-Value Format
      • CBR Apps using Weight Calculation Algorithm
      • Deriving Feature Weight
      • Classification and Clustering
      • Similarity Measures in WKA
    • Quiz Apps
      • Quiz App From Excel Sheets
    • Using Python
    • Sign Up
    • JQPlot Graph
    • Move Project
    • Others
      • Charts
      • CBR Configuration
      • Major interfaces and objects
      • Form Based Inputs for ES
      • ES and CBR Technology
      • Intelligent Matching
      • Extracting Rules from R
      • Simple Collaborative Filtering Algo
  • Expert Systems
    • ES Introduction
  • Working with JavaScript
    • Control functions
    • Form Functions
  • Understanding Universal Schema
    • Party tables
    • Basic tables
    • General tables
    • Item tables
    • Transaction tables
  • WKA Studio Config
    • Troubleshooting
      • Interfaces
      • Login
      • Applications
      • JavaScript
    • Training Module
      • Training Plan
        • Introduction to ES
        • Create Application
        • Chatbot Application
        • Python Function
        • Application through APIs
    • WKAS PL Reference
      • ANN Functions
        • CREATE ANN
        • GET ANN
        • RESET ANN
        • RUN ANN
        • SET ANN
      • AppUserManagement Functions
        • CREATE APP USER
        • REMOVE APP USER
        • UPDATE APP USER
      • Cases Functions
        • GET CASES
      • CBR Functions
        • CBR FILTER
        • GET CBR
        • GET SIMILARITY
        • INIT CBR
        • INIT CBR1
        • REUSE CBR
        • RUN CBR
        • RUN R4CONFIG
        • SET CBR
        • SPLIT SOLUTION
        • UNIFY SOLUTION
        • UNIQUE SOLUTION
      • Compound Functions
        • CREATE LIST
        • GET IN LIST
        • GET IN MATRIX
      • Control Functions
        • BREAK
        • CASE
        • CONTINUE
        • CONTINUE WHEN
        • ELSE
        • END FOR
        • END FOREACH
        • END IF
        • END SWITCH
        • END WHILE
        • EXIT RULE
        • EXIT WHEN
        • FOR
        • FOREACH
        • GET ENUM ID
        • GET EXPRESSION NO
        • GET ID
        • GET LOOP INDEX
        • GOTO SEGMENT
        • IF
        • IF THEN ELSE
        • IS ERROR
        • IS NULL THEN
        • SEGMENT
        • SWITCH
        • USING
        • WHILE
      • Conversion Functions
        • BIGNUMBER
        • BOOLEAN
        • C BIGNUMBER
        • C BOOLEAN
        • C DATE
        • C DBSET
        • C LIST
        • C MATRIX
        • C NUMBER
        • C REAL
        • C TEXT
        • C TREND
        • DATE
        • NUMBER
        • REAL
        • TEXT
        • TRANSFORM
      • Database Functions
        • CALL DB ROUTINE
        • DELETE FROM DB
        • EXECUTE DB TRANS
        • EXECUTE QUERY
        • FETCH CURSOR
        • GET FROM DB
        • INSERT TO DB
        • LOAD FROM DB
        • OPEN CURSOR
        • POPULATE VARS IN QRY
        • REFRESH ID VALUES
        • REFRESH SIM VALUES FROMDB
        • UPDATE RECORDS TO DB
        • UPDATE TO DB
      • Date Functions
        • ADD TO DATE
        • DATE DIFF
        • FORMAT DATE
        • GET DATE PART
        • NOW
        • TO DATE
      • Email Functions
        • SEND EMAIL
      • Error Handling Functions
        • GET ERROR MESSAGES
      • File Functions
        • LOAD DOC FROM DB
        • LOAD FROM FILE
        • SAVE DOC TO DB
        • SAVE TO FILE
      • GA Functions
        • CREATE GA
        • GET GA
        • RESET GA
        • RUN GA
        • SET GA
      • General Functions
        • APPEND
        • CALL CUSTOM FUNCTION
        • CALL EXT API
        • CALL EXT FUNCTION
        • CALL UDF
        • CLEAR
        • CLONE
        • COUNT
        • DATA TYPE
        • EVALUATE
        • EXECUTE EXP
        • IN
        • INSERT AT
        • IS BLANK
        • MERGE
        • RESET FORM VALUES
        • RETURN
        • SEND MESSAGE
      • Graph Functions
        • CREATE GRAPH
        • SET GRAPH
      • List Functions
        • FILL LIST
        • GET RANDOM SEQ
        • GET WEIGHTS
        • GW
        • INCLUDE
        • INCLUDE ANY OF
        • RELATIVE WEIGHTS
        • RELATIVE WEIGHTS MV
        • REMOVE WEIGHTS
        • RW
        • SET WEIGHTS
        • SORT
        • UNIQUE
      • Logical Functions
        • AND
        • BETWEEN
        • NOT
        • OR
      • Lookup Functions
        • COUNT IF
        • GET AT
        • GET LOOKUP VALUE
        • LOAD FROM LOOKUP
        • LOAD LOOKUP VALUE
        • REMOVE LOOKUP VALUE
        • SET AT
        • SET LOOKUP VALUE
        • SLICE
      • Math Functions
        • ABS
        • CEILING
        • EXP
        • FLOOR
        • LOG
        • LOG10
        • MAX
        • MIN
        • ROUND
        • SQR
        • SQRT
        • SUM
        • TRUNCATE
      • Matrix Functions
        • CREATE MATRIX
        • CREATE TREND
        • GET MATRIX
        • GET MATRIX ELEMENT
        • INVERSE MATRIX
        • READ MATRIX
        • RESIZE MATRIX
        • SAVE MATRIX
        • SET MATRIX
        • SET MATRIX COLUMN
        • SET MATRIX ROW
        • TRANSPOSE MATRIX
      • Menu Functions
        • GET CODE
        • GET CODE LIST
        • GET DESCRIPTION
        • GET INFERENCE
        • GET MENU
        • GET MENU CODE
        • GET MENU OPTION
        • GET MENU PARENT
        • GET OPTION
        • GET PARENT
        • GET PARENT LIST
        • MAX SCORE OF
        • PROFILE OF
        • SCORE OF
      • Object Functions
        • CREATE OBJECT
      • Python Functions
        • CALL PY FUNCTION
        • CALL PY METHOD
        • CREATE PY CINSTANCE
        • EXECUTE PY EXP
        • EXECUTE PY SCRIPT
        • GET PY VALUE
        • SET PY VALUE
      • Report Functions
        • GET REPORT
        • SHOW REPORT
      • Security Functions
        • DECRYPT
        • ENCRYPT
        • HASH
      • Session Functions
        • ADD SESSION
        • CLEAR SESSION
        • CREATE WEB LINK
        • GET EXECUTION PATH
        • GET PARAMETER
        • GET SESSION
        • LOAD ES SESSION
        • LOAD LAST VALUES
        • LOAD LAST VALUES FROM DB
        • LOAD SESSION
        • LOAD SESSION DB
        • LOAD SESSION FROM DB
        • SAVE SESSION TO DB
        • SET PARAMETER
        • TRACK EXECUTION
      • SpreadSheet Functions
        • LOAD FROM SPREADSHEET
        • UPDATE TO SPREADSHEET
      • Stat Functions
        • STAT
      • Text Functions
        • ENDS WITH
        • FORMAT
        • LEFT
        • LEN
        • LOWER CASE
        • POPULATE VAR VALUES
        • REPLACE
        • RIGHT
        • SCAN TEXT
        • SOUNDEX
        • SOUNDEX1
        • SPACE
        • SPLIT
        • SPLIT1
        • STARTS WITH
        • SUBSTRING
        • TRIM
        • UPPER CASE
      • Trend Functions
        • AMD
        • AVERAGE
        • CORRELATION
        • FILL TREND
        • FIT TREND
        • FORECAST TREND
        • GROWTH
        • HIGHEST
        • INCREASE IN
        • LOWEST
        • R SQUARE
        • STD DEV
        • TREND EQUATION
      • Variable Functions
        • ASK
        • ASK FOR
        • GET ADDED VARS
        • GET CF
        • GET LANG VALUE
        • GET VAR VALUE
        • IS NULL
        • RESET VAR VALUE
        • RESET VAR VALUE1
        • SET CF
        • SET VAR VALUE