Did anyone has done salesforce - splunk integration. Please provide me any link or documentation.

Soql dynamic query every times returns and showing exception....
 

public static list<Idea> getData(String status , String item , String search, String off)
    {
      	Integer offset = integer.valueOf(off);
         String srchstr = '%' + search + '%';
         string query =  'SELECT  Id, Title,  Categories , Body,NumComments,CreatedBy.firstname, status, voteTotal from idea where communityid =: zoneId';

         if(item !='All')
        {
             query +=' AND Categories =\'' +item+ '\'';     
         }  
        if(status !='All')
        {        
             query +=' AND Status=\'' +status+'\'' ;
        } 
      if(search != null)
       {
          query += ' AND Title like \'' +srchstr+ '\'';
       }

          query += 'Limit 2 offset' + offset;
        
            System.debug(query);
            return Database.query(query); 
      

     }

System.QueryException: unexpected token: offset4
 

HI
I am getting an error in this condition..
Pls help me out..

AND(OR(ISPICKVAL( school_institution_type__c ,'Elementary School'),
ISPICKVAL( school_institution_type__c ,'Middle/Jr. High School'),
ISPICKVAL( school_institution_type__c ,'High School'),ISPICKVAL
(school_institution_type__c ,'District')),
OR(State == 'AK',State == 'MT',State == 'WA',State =='OR')
,ISPICKVAL(Division__c ,'Secondary Education') 
,OR(NOT  CONTAINS ((ISPICKVAL(Territory__c , OR'Admissions')),
ISPICKVAL(Territory__c , 'FSE'),
ISPICKVAL(Territory__c , 'iThenticate'),
ISPICKVAL(Territory__c , 'Profit'),
ISPICKVAL(Territory__c , 'SA')),$Label.Lead_Workflow_flag =='true'))

 

i am getting rutime exception in this code...

public with sharing class SearchTask {
Public String FirstName {Get;Set;}
Public String LastName {Get;Set;}
Public String Email {Get;Set;}
Public String Query;
    public Void Searchtask(ApexPages.StandardController controller)
    {}
        public void Search(){
        List<contact> ConList = New List<Contact>();
        
        String ThisQuery ='Select FirstName, Lastname , Email From Contact Where FirstName=:FirstName , LastName=:LastName , Email=:Email';
        ConList = Database.Query(ThisQuery);
       }
   
   }

Hi,
I'm bulding an Approval process, for that I'm preparing an email (Text) template to include VisualForce page link so that approvars opens that page and submit. I can get the Salesforce Base URL from apex but I have no clue how to get it form email template.
See the following template that I have gotten from APEX.

<a href='https://'+ System.URL.getSalesforceBaseUrl().getHost() +  
             '/apex/GUGocardPhotoApprovalPage?ContactId='+contactID'>Click here </a>

 

Soql dynamic query every times returns and showing exception....
 

public static list<Idea> getData(String status , String item , String search, String off)
    {
      	Integer offset = integer.valueOf(off);
         String srchstr = '%' + search + '%';
         string query =  'SELECT  Id, Title,  Categories , Body,NumComments,CreatedBy.firstname, status, voteTotal from idea where communityid =: zoneId';

         if(item !='All')
        {
             query +=' AND Categories =\'' +item+ '\'';     
         }  
        if(status !='All')
        {        
             query +=' AND Status=\'' +status+'\'' ;
        } 
      if(search != null)
       {
          query += ' AND Title like \'' +srchstr+ '\'';
       }

          query += 'Limit 2 offset' + offset;
        
            System.debug(query);
            return Database.query(query); 
      

     }

System.QueryException: unexpected token: offset4
 

i am getting rutime exception in this code...

public with sharing class SearchTask {
Public String FirstName {Get;Set;}
Public String LastName {Get;Set;}
Public String Email {Get;Set;}
Public String Query;
    public Void Searchtask(ApexPages.StandardController controller)
    {}
        public void Search(){
        List<contact> ConList = New List<Contact>();
        
        String ThisQuery ='Select FirstName, Lastname , Email From Contact Where FirstName=:FirstName , LastName=:LastName , Email=:Email';
        ConList = Database.Query(ThisQuery);
       }
   
   }