Fuzzy query--View write SQL

"1" cip_admin_domain (option field a)---> Inside configuration (Option field a) property, Defalut_value set initial value (such as: Create a new project, the project status after creation is "pending approval")

Cip_admin_codes (option field a)

Note: Two fields in the table, and, front page code "option" field--"must be consistent,

"2" multi-conditional value function, in SQL

Select

field A, field B

(

Case

When (codes. Field 1 = ' option English alias 1 ') Then ' Chinese name 1 '

When (codes. Field 2 = ' option English alias 2 ') Then ' Chinese name 2 '

When (codes. Field 3 = ' option English alias 3 ') Then ' Chinese name 3 '

End

) as field a

From table where condition

Case:

--Simple case function case sex when         ' 1 ' then ' Male ' when         ' 2 ' then ' women ' else ' other ' END
   ----need to be aware of, the case function returns only the first qualifying value, and the remaining case section is automatically ignored.

--case search function Case if sex = ' 1 ' Then ' man ' when         sex = ' 2 ' Then ' women ' else ' other ' END

"3" Select field A, field B,

' Cod '. ' Code_name ' as ' field alias ',----list displayed in Chinese
' Cod '. ' Code_type ' as ' field name ',-----The front page is an English alias (codes type)

From table name

Left JOIN ' cip_admin_codes ' to ' Cod ' on (
(
(
' m '. ' Project_scale ' = ' cod '. ' Code_type '
)
and (
' Cod '. ' domain_id ' = ' Project_scale '
)
)
)

Note: Front page, field list--"must be an alias.

Fuzzy query--View write SQL