Skip to content
Snippets Groups Projects
displayValueProcess.js 787 B
Newer Older
Sebastian Listl's avatar
Sebastian Listl committed
import { result, vars } from "@aditosoftware/jdito-types";
import { Contact, ContactTitleRenderer } from "Contact_lib";
Sebastian Listl's avatar
Sebastian Listl committed
import { newSelect } from "SqlBuilder_lib";

var contactId = vars.get("$field.prefferredApprover");
if(contactId)
{
    var contact = new Contact();
    [contact.salutation, contact.title, contact.firstname, contact.middlename, contact.lastname] 
    = newSelect("PERSON.SALUTATION, PERSON.TITLE, PERSON.FIRSTNAME, PERSON.MIDDLENAME, PERSON.LASTNAME", "Data_alias")
Sebastian Listl's avatar
Sebastian Listl committed
            .from("CONTACT")
            .leftJoin("PERSON", "PERSON.PERSONID = CONTACT.PERSON_ID")
            .whereIfSet("CONTACT.CONTACTID", contactId)
            .arrayRow(true);
    result.string(new ContactTitleRenderer(contact,  ContactTitleRenderer.OPTIONS.NoOption)
        .asString());