Hello folks,

I am writing a dynamic query and comparing a formula(Ineger) field called Age_of_Call_in_Days_abv__c in my object, but getting bellow error.
"System.QueryException: value of filter criterion for field 'Age_of_Call_in_Days_abv__c' must be of type double and should not be enclosed in quotes"

Below codes which am writing 

String orgName = 'Agri';
String profileId='00eF0000000yQWE';
Double minAge = 7.0;
Double maxAge = 30.0;
String query = 'Select Id, Name, Call_Type_vod__c,Account_vod__c, Age_of_Call_in_Days__c, Late_Submission_Approval_Status_abv__c,  from Forma__c'
                            + ' where Organization_abv__c !=\'' + orgName +'\''+
                        ' AND owner.ProfileId =\'' + profileId + '\''+
                        ' AND Age_of_Call_in_Days__c>=\''+ minAge + '\''+
                        ' AND Age_of_Call_in_Days__c<=\''+ maxAge + '\'' + ' LIMIT 2';


Please help me.

Hi Friends,
i am using a custom Web to Lead form, where am tring to add a value into State field of Lead object. i am trying to achieve this with two approaches  below but am unable to save it.

First Approach - 
<label class="enroll__form--desc" for="State">Estado</label>
<select class="form-control enroll__form-height enroll__form-input" id="State" name="State"  placeholder="Estado"/> 

Second Approach - 
<label class="enroll__form--desc" for="State">Estado</label>
<select class="form-control enroll__form-height enroll__form-input" id="State" name="lead.State"  placeholder="Estado"/> 

Please help me 
.
Thanks in advanced

Hello Professionals,
i was using <Style> tag in to lightning component for showing a banner pic but it is supporing the component which has API Version 39 not for the above. Please help me how i can add a banner pic into style bundle of lighting component. 
Below is the code which are not working for component which have API Version 40 or above.

<style type="text/css">
        .banner__content {
            background-image: url({!v.contentBanner.Thumbnail__c});
        }
        
        .news h2{
            color: #f58e92;
        }
        
        canvas{
            -moz-user-select: none;
            -webkit-user-select: none;
            -ms-user-select: none;
        }
        
        .modal ul{
            padding: 10px 10px 10px 28px;
        }
    </style>

Please help me.
Thanks in Advanced

 i have a custom picklist field documentType__c(documents name are - BirthCertificate, passport, CAE, NDI) , it is controlling by another picklist field named is ProgramType__c(program name are - US, India,UK , UAE). 
How to get documentType field value based on the particular ProgramType .

Thanksa
Thanks in Advanced.

I made a community page and add some lightning components. Then is got below errors.

1- Uncaught ReferenceError: scrollToBeFixed is not defined throws at https://latamdev-latamprod-community--live.cs52.force.com/BrazilRisaPatient/s/components/c/ABVRisaPhysicianAboutHumanizar.js:18:17

2- Custom Script Eval error in 'ltng:require' [[object Event]]

Please help me 
Thanks in Advanced .

Hi Guys,
I just open a modal on button click but its not opening.

My codes are below.

<button class="btn btn-btn-size1 btn-purple m-t-25" data-toggle="modal" data-target="#modalEnroll" >
                                    <span class="text-upper black text-center">
                                        Cadastrar Paciente no<br></br>          programa Humanizar
                                    </span>
                                </button>

controller.js

openModalNewPatient : function(component, event, helper) {
     
        $('#modalEnroll').modal('show');
    }
here modalEnroll is the modal id, which i want to open.

Please help me.
Thanks in advanced.

Hi All,

I have login page, from there i want to swich on forget password page but it landing on same login page.

My original URL is https://latamdev-latamprod-community.cs52.force.com/BrazilRisaPatient/s/esqueci-senha  and after click on the link to open this url its added extra text in this url and landed login page
https://latamdev-latamprod-community.cs52.force.com/BrazilRisaPhysician1/s/login/?startURL=%2FBrazilRisaPhysician1%2Fs%2Fesqueci-senha&ec=302

component code:
<aura:component >    
    <aura:attribute name="options" type="List" default="[
                                                        {'label': 'Mobile', 'value': 'Mobile'},
                                                        {'label': 'Laptop', 'value': 'Laptop'},
                                                        {'label': 'Hardware', 'value': 'Hardware'},
                                                        {'label': 'Software', 'value': 'Software'},
                                                        {'label': 'TV', 'value': 'TV'},
                                                        {'label': 'Cars', 'value': 'Cars'}
                                                        ]"/>
    <aura:attribute name="select" type="List" default="option1"/>
    
    <aura:attribute name="addItems" type="List"/>
    <aura:attribute name="selectedAddItems" type="List"/>
    <div class="flex-container">
        <div class="border">
            <lightning:checkboxGroup name="unSelected"
                                     label="Unselected Items"
                                     options="{! v.options }"
                                     value="{! v.select }"
                                     onchange="{! c.handleChange1 }"/>
        </div>
        
        <lightning:button label="Add" onclick="{!c.addValue}"/>
        
        <lightning:button label="Remove" onclick="{!c.removeValue}"/>
        
        <div>
            <lightning:checkboxGroup name="selected"
                                     label="Selected Items"
                                     options="{!v.addItems}"
                                     value="{!v.selectedAddItems}"
                                     onchange="{!c.handleChange2}"/>
        </div>
    </div>
</aura:component>

controller code:
({
    // var itemarray:[];
    handleChange1: function (cmp, event)
    {
     // This will contain the string of the "value" attribute of the selected option
     var selectedOptionValue = event.getParam("value");
     //var shw = 
     //alert('selected value list'+selectedOptionValue.indexOf());
     
    },
    
    addValue : function(component, event, helper) 
    {
     // get all value from the list
     
     var clearitems = component.get("v.options");
     
     // get all selected value from the list
     var gtckboxValue = component.get("v.select");
     //alert('selected value list'+gtckboxValue.length);
     var itemsArray=[];
    
     var j=0;
     for(var i=0 ; i< gtckboxValue.length; i++){
         j++;
         itemsArray.push({
             label: gtckboxValue[i],
             value: gtckboxValue[i]
         });
         clearitems.splice(i,1);
         
         // component.set("v.options",clearitems);
         // component.set("v.addItems",itemsArray);
         /*var index = gtckboxValue.indexOf(i);
            alert('index of selected items'+index);
            if(index > -1){
                gtckboxValue.splice(index, 1);
            }*/
         
     }    
     component.set("v.addItems",itemsArray);
     //clearitems.splice(j,1);
     component.set("v.options",clearitems);
    },
    handleChange2: function (cmp, event) {
        // This will contain the string of the "value" attribute of the selected option
        var selectedOptionValue = event.getParam("value");
        alert('adffdji'+selectedOptionValue);
        
    },
    
    removeValue : function(component, event, helper) {
        var gtckboxValue = component.get("v.select");
        
    }
})
Lightning Application code:
<aura:application extends="force:slds">
    <c:MyCustom_List/>
</aura:application>

Thanks in advanced .

hello professionals,
I am getting such type of error when i trying to convert XML To TEXT
Apex class code
--------------------------
public class Convert_XML_2Strin {
    public String xmlString {set;get;}
    public String result    {set;get;}
    public void convertXML(){
        Dom.Document doc=new Dom.Document();
        doc.load(xmlString);
        Dom.XMLNode root= doc.getRootElement();
        result=result+root.getName();
        List<Dom.XMLNOde> childs =root.getChildElements();
        if(childs.size()>0){
            for(Dom.XMLNode c :childs){
                result=result+'\n'+c.getName()+':'+c.getText();
            }
        }
    }
}

Visual force CODE
-------------------------
<apex:page controller="Convert_XML_2Strin">
    <apex:form id="fm">
        <apex:panelGrid columns="3">
             <apex:inputTextArea rows="10" cols="40" value="{!xmlString}" />
             <apex:panelGrid columns="1">
                 <br/>
                 <br/>
                 <br/>
                  <apex:commandButton value="Convert" action="{!convertXML}" reRender="fm"/>
             </apex:panelGrid>
           
            <apex:inputTextArea rows="10" cols="40" value="{!result}" />
        </apex:panelGrid>
       
    </apex:form>
</apex:page>

Hello folks,

I am writing a dynamic query and comparing a formula(Ineger) field called Age_of_Call_in_Days_abv__c in my object, but getting bellow error.
"System.QueryException: value of filter criterion for field 'Age_of_Call_in_Days_abv__c' must be of type double and should not be enclosed in quotes"

Below codes which am writing 

String orgName = 'Agri';
String profileId='00eF0000000yQWE';
Double minAge = 7.0;
Double maxAge = 30.0;
String query = 'Select Id, Name, Call_Type_vod__c,Account_vod__c, Age_of_Call_in_Days__c, Late_Submission_Approval_Status_abv__c,  from Forma__c'
                            + ' where Organization_abv__c !=\'' + orgName +'\''+
                        ' AND owner.ProfileId =\'' + profileId + '\''+
                        ' AND Age_of_Call_in_Days__c>=\''+ minAge + '\''+
                        ' AND Age_of_Call_in_Days__c<=\''+ maxAge + '\'' + ' LIMIT 2';


Please help me.

Hi Friends,
i am using a custom Web to Lead form, where am tring to add a value into State field of Lead object. i am trying to achieve this with two approaches  below but am unable to save it.

First Approach - 
<label class="enroll__form--desc" for="State">Estado</label>
<select class="form-control enroll__form-height enroll__form-input" id="State" name="State"  placeholder="Estado"/> 

Second Approach - 
<label class="enroll__form--desc" for="State">Estado</label>
<select class="form-control enroll__form-height enroll__form-input" id="State" name="lead.State"  placeholder="Estado"/> 

Please help me 
.
Thanks in advanced