Skip to content
Snippets Groups Projects
displayValueProcess.js 560 B
import("system.logging");
import("system.vars");
import("Keyword_lib");
import("system.result");
import("system.db");
import("system.vars");
import("system.neon");
import("Sql_lib");

var salutation = vars.get("$field.SALUTATION");

var cond = SqlCondition.begin()

var sex = db.cell(cond.andPrepareVars("SALUTATION.SALUTATION", "$field.SALUTATION").buildSql("select SEX from SALUTATION", "1=2"))

    
if (sex)
{
    var keyword = KeywordUtils.getViewValue("PersonGender", sex);
    
    logging.log(keyword)
    result.string(keyword)
}