[SalesForce] How to get Controller list in page java script

Calculator__c objCalculator  = [Select id, name, (select id,
fee_amount__c, cost_Amount__c, Type__c, from
Non_Labor_Cost_Details__r) From Calculator__c p where id =: PId];

When I try to use this object in Javascript like this:

{!objPricingCalculator.Non_Labor_Cost_Details__r}

It returns only list of Ids (comma separated). It's not returning
fee_amount__c, cost_Amount__c and Type__c values.

Is there any way through which I can also extract fee_amount__c, cost_Amount__c and Type__c along with Id.

I don't want to use Javascript Remoting as I will have to change code flow for this.

Best Answer

//Apex class

 public class sample{

 public Account gethello(){

      Account acc=[Select Id,(Select id,Name from Contacts) from Account where Id =acc.id];
     return acc;

   }
}

Visualforce code with Javascript

<apex:page controller="sample">

<script>

<apex:repeat var="a" value="{!hello.Contacts}">
   alert('hello'+'{!a.Name}');
 </apex:repeat>

 </script>

 </apex:page>

This is the starting point.Now you can declare your own function in javascript something like this in script

function Contact(){
      /* Note the field names are case-sensitive! */
      this.Id = null; /* set a value here if you need to update or delete */
      this.Name = null;
  }

After this you can use push function of javascript to form an object array using some samples from below URL.

http://www.w3schools.com/jsref/jsref_push.asp

Related Solutions

[SalesForce] Javascript Remoting (Return cached result without re-query)

There are a couple of things.

In Apex, init() methods are not called by default. Any code you want to run during the instantiation of an Object must go in the constructor, see Using Constructors. Since JavaScript Remoting requires your methods to be Static, setting Instance Variables will not do you any good.
Your static method, "findAccounts" is trying to reference an instance variable, "accounts". I got a compile error when initially trying to save your class. If you want to reference the "accounts" variable from within another static method, make sure to define this as a static list.
Since init() is never getting called, the list of accounts will be null. If you call this init() method within the findAccounts method, then the data will be populated. Note, that you must change init() to be a static method then, as well. As referenced above, it's generally not a best practice to query all objects into memory, as you will soon hit governor limits for the total number of records retrieved by SOQL queries of 50k query rows.

If you put all that together, this should get you at least a working example.

global class MyClass
{
    public static List <Account> accounts = new List <Account>();

    public static void init()
    {
        accounts = [SELECT Id, Name FROM Account]; 
    }

    @RemoteAction
    global static Account findAccount(String accountName)
    {
        init();
        for(Account acc : accounts)
        {
             if(acc.Name == accountName)
                 return acc;
        }

        return new Account();
    }
}

Note, that this will infact requery the database everytime findAccounts is called. A design pattern I like to use, and have seen a lot looks something like the following:

public static List <Account> accounts;
public static void setAccounts()
{
    if (accounts == null){
        accounts = new List<Account>();
        accounts = [SELECT Id, Name FROM Account]; 
    }
}

This will ensure that the query is only run once within the lifespan of the request.

You also may want to utilize a Map<String, Account> accountNameToAccountMap see Apex Maps, so that you can avoid iterating through the list every single time. But, I'll leave that as an exercise.

[SalesForce] Correct syntax to pass the parameter to a method via JavaScript (JavaScript remoting doesn’t have PageReference context)

Remote action can be called with following syntax.

<script type="text/javascript">
    "fnInitComplete": function(oSettings) { 

        var recordid='{!$currentPage.parameters.id}';
        alert(recordid);
        Visualforce.remoting.Manager.invokeAction(
            '{!$RemoteAction.ChartController.getDatatable}',
            recordid, 
            function(result, event){
                if (event.status) {

                    //your success code

                } else if (event.type === 'exception') {
                    //Your exception handling
                } else {

                }
            }, 
            {escape: true}
        );
    }
    </script>

Best Answer

Related Solutions

[SalesForce] Javascript Remoting (Return cached result without re-query)

[SalesForce] Correct syntax to pass the parameter to a method via JavaScript (JavaScript remoting doesn’t have PageReference context)

Related Topic