2

This question only for users, who have knowledge about Idea object in salesforce For user who don't know about Idea object, I can't help .

how to get status and category value based on zone name in idea object salesforce

enter image description here

Requirement I have vf page. there I have three picklist

  • Zone
  • Category
  • Status

But I am not getting filtered value when I am selecting A zone name from Zone picklist. It gives us all category and Status values.

But in standard sf page Idea detail page, It do these filtering. I want to do the same.

I have tried getting dependent field value using MetaData Api as well. but no luck because Zone(CommunityId-Apiname) is not dependent field of Status and Category field in Idea object, but behave in that manner(Magically).

ZoneId is label name and api name is CommunityId, is reference field in Idea obejct

Status and Category are picklist type of field and can have different-2 value depends upon Zone selection.

ZoneId is not controller field but behave like controller field for Status and Category field. This all are standard field(Category, Status, CommunityId(label as Zone)) and standard object(Idea)

In the end I would say,Zone is behaving as RecordType.

Now Based on selected Zone, Status and Category values in picklist will be visible first step to create idea, Select a zone

Idea object Fields

Zone Object detail pageZone Object detail page

Here you can choose which status and cateogry to be shown for each zone

  • Hello @Ankuli I am confused about what you are trying to accomplish? Could you list the requirement. What is the end result you are trying to get? – Blair Kristin May 15 '15 at 12:32
  • sure. I have editing the question again. – Ankuli May 15 '15 at 14:39
  • What do you have so far? – dphil May 15 '15 at 15:02
  • @dphil sorry, I didn't get you. I have tried with xml page structure and meta data api. but no luck till now. – Ankuli May 15 '15 at 15:28
2

Let me answer my question. It is possible using meta data describe pagelayout method.

<apex:outputPanel id="zoneFilter" layout="none">                          
    <h2 class="zoneLabel">Zone </h2> 
    <select title="Choose a Zone" style="width:22%;"  onchange="$('#zoneHidden input:first-child').val(this.value); changeDependentList(this.options[this.selectedIndex].innerHTML);">
            <option value="{!strZoneId}">{!strZoneName}</option>
                <apex:repeat id="repZone" value="{!lstZone}" var="objZone"  >                  
                    <apex:outputPanel id="optionZone" rendered="{!LOWER(objZone['label']) != LOWER(strZoneName)}" layout="none">
                        <option value="{!objZone['value']}">{!objZone['label']}</option>
                    </apex:outputPanel>
                </apex:repeat>
            </option>
    </select> 
    <span id="zoneHidden"><apex:inputHidden value="{!strZoneId}" /></span>         
</apex:outputPanel>

<apex:outputPanel id="categoryFilter" layout="none">  
    <h2>Category </h2>
    <select title="Choose a Categories" id="category" style="width:22%;"  onchange="$('#categoryHidden input:first-child').val(this.value);">

    </select>  
    <span id="categoryHidden"><apex:inputHidden value="{!strCategoryName}" /></span>  
</apex:outputPanel>              

<apex:outputPanel id="statusFilter" layout="none">           
    <h2 class="statusLabel">Status </h2>      
    <select title="Choose a Status"  id="status" style="width:22%;" onchange="$('#statusHidden input:first-child').val(this.value);"  >

    </select>  
    <span id="statusHidden"><apex:inputHidden value="{!strStatusName}" /></span>
</apex:outputPanel>  

<script>

    recordTypeMap = new Array();
    var recordTypeToStatus = [];
    var recordTypeToCategory = [];
    onloadPage();           

    function onloadPage()
    {
        sforce.connection.sessionId = '{!$Api.Session_ID}';
        // here in array we can send Record type Ids but it was giving some time wrong result , so blank array give result for all available //RecordType detail
        //result =  sforce.connection.describeLayout('Idea', new Array('099394343400034'));
        result =  sforce.connection.describeLayout('Idea', new Array());

        recordTypeName = new Array();
        recordTypeMap = result.recordTypeMappings;

        recordTypeMap.forEach(function(obj){
            recordTypeName.push(obj.name.substring(0,obj.name.indexOf(':')).toUpperCase());
        });

        recordTypeName.pop();
        recordTypeName.push('ALL');

        for(i=0;i<recordTypeMap.length;i++)
            recordTypeToStatus.push({'name':recordTypeName[i],'status': getName(recordTypeMap[i].picklistsForRecordType[1])});

        for(i=0;i<recordTypeMap.length;i++)
            recordTypeToCategory.push({'name':recordTypeName[i],'categories': getName(recordTypeMap[i].picklistsForRecordType[0])});

        changeDependentList('{!strZoneName}');

    }

    function getName(MainList)
    {
        var modiflist = new Array();
        if(MainList.picklistValues.length == undefined)
            modiflist.push(MainList.picklistValues.label);
        else
        {
            MainList.picklistValues.forEach(function(obj){
                modiflist.push(obj.label);
            });
        }
        return modiflist;
    }

    function changeDependentList(zoneName)
    {
        console.log(recordTypeName);
        console.log(zoneName.toUpperCase());

        indexToChange = recordTypeName.indexOf(zoneName.toUpperCase());

        if(indexToChange != -1){

            var statusList = recordTypeToStatus[indexToChange];

            console.log($('#statusHidden input:first-child').val());
            var currentStatus = $('#statusHidden input:first-child').val();
            console.log(statusList.status);

            $('#status').empty(); //removing old childs
            var $ele1 = $('#status');



            if(statusList.status.indexOf(currentStatus) == -1)  
            {
                $ele1.append($('<option value="All">All</option>'));
            }
            else
                $ele1.append($('<option value='+currentStatus+'>'+currentStatus+'</option>'));


            statusList.status.forEach(function(statusToAdd){

                $ele1                          
                   .append($("<option></option>")
                    .attr("value", statusToAdd)
                    .text(statusToAdd)
                   );
            });


            var categoryList = recordTypeToCategory[indexToChange];

            $('#category{!id}').empty(); //removing old childs
            var $ele2 = $('#category');
            $ele2.append($('<option value="All">All</option>'));

            categoryList.categories.forEach(function(statusToAdd){
                $ele2                          
                   .append($("<option></option>")
                    .attr("value", statusToAdd)
                    .text(statusToAdd)
                   );
            });
        }

    }


</script>  

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.