I have a visualforce email template and tried to get substring from <apex:outputField value="{!relatedTo.test}">. !relatedTo.test is a picklist type field If I use <apex:outputText value="{!LEFT(related.test,3)}"> which just get the api name not value And I also try to use formula field to handle this, but TEXT(test) also get api name. Is there any good command? Thanks.
public class Benef_list {
public String be_last_name;
public String be_first_name;
public String be_pid;
public String be_relationship;
}
public class Policy_list {
public String po_ins_company_code;
public String po_policy_id_str;
public String po_rate;
public List<Insured_list> insured_list;
}
//Request Model
public class RequestModel
{
public String token;
public String od_order_id_str;
public String od_status;
public String od_product_code;
public String od_rate;
public String od_deliver_status;
public String od_archive_policy_doc;
public String od_contract_status;
public String od_source;
public List<String> od_b2b_invalid_data;
public String ap_first_name;
public String ap_last_name;
public String ap_mobile;
public String ap_pid;
public String ap_birthday;
public String ap_email;
public String ap_address_city_id;
public String ap_address_area_id;
public String ap_address;
public String ap_update_info;
public String tr_transport;
public String tr_country_code;
public String tr_city_id;
public String tr_purpose;
public String tr_start_date;
public String tr_start_hour;
public String tr_start_min;
public String tr_end_date;
public String tr_end_hour;
public String tr_end_min;
public String tr_period_days;
public String pay_order_id;
public List<Policy_list> policy_list;
}
public class Item_list {
public String it_is_primary;
public String it_ins_item_code;
public String it_ins_company_code;
public String it_amount_code;
public String it_amount_name;
public String it_amount;
public String it_rate;
public String it_item_name;
}
public class Insured_list {
public String in_relationship;
public String in_last_name;
public String in_first_name;
public String in_pid;
public String in_birthday;
public String in_rate;
public String pa_package_type;
public String pa_package_name;
public String in_taian_package;
public List<Item_list> item_list;
public List<Benef_list> benef_list;
}
It can receive the data successfully, but the question is occurred on inserting or updating data. In SFDC, I created 3 objects: Order, OrderItem, TravelCom. Order is the parent of OrderItem, and OrderItem is the parent of TravelCom.
List<Order__c> orderList = [SELECT Id, Name, Account__c,
(SELECT Id, Name, Order__c, relationship__c,
FROM OrderItems__r),
(SELECT Id, Name ,Order__c, OrderItem__c,
FROM TravelCom__r)
FROM Order__c
WHERE RecordTypeId = :orderRTList[0].Id
AND Name = :tmpRequestModel.od_order_id_str];
The API can create these 3 objects well and insert the responding value on Order, OrderItem but TravelCom is always null. This is what I wrote.
