skuid table filter show picklist values from record type that users does not have access to

Praveen,

What I do is build an aggregate model on Opportunities that groups by the field that I want to filter. I setup a filterable condition on the field and then use the aggregate model to provide the ‘pick list’ values for the filter.

Here is a sample page that demonstrates this using the Stage field on Opportunities.

Thanks,

Bill

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" useviewportmeta="true" showsidebar="true" showheader="true" tabtooverride="Opportunity">
    <models>
        <model id="OppStages" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Opportunity" type="aggregate">
            <fields/>
            <conditions/>
            <actions/>
            <groupby method="simple">
                <field id="StageName" name="stageName"/>
            </groupby>
        </model>
        <model id="Opportunity" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Opportunity">
            <fields>
                <field id="Name"/>
                <field id="CreatedDate"/>
                <field id="StageName"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="StageName" operator="=" state="filterableoff" inactive="true" name="StageName"/>
            </conditions>
            <actions/>
        </model>
    </models>
    <components>
        <pagetitle model="Opportunity" uniqueid="sk-2A_j-199">
            <maintitle>
                <template>{{Model.labelPlural}}</template>
            </maintitle>
            <subtitle>
                <template>Home</template>
            </subtitle>
            <actions>
                <action type="savecancel" uniqueid="sk-2A_j-197"/>
            </actions>
        </pagetitle>
        <skootable showconditions="true" showsavecancel="false" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" createrecords="true" model="Opportunity" mode="read" allowcolumnreordering="true" uniqueid="sk-2A_j-213">
            <fields>
                <field id="Name" hideable="true" allowordering="true" uniqueid="fi-2A_c-930"/>
                <field id="StageName" hideable="true" uniqueid="fi-2A_j-255"/>
                <field id="CreatedDate" hideable="true" allowordering="true" uniqueid="fi-2A_c-931"/>
            </fields>
            <rowactions>
                <action type="edit"/>
                <action type="delete"/>
            </rowactions>
            <massactions usefirstitemasdefault="true">
                <action type="massupdate"/>
                <action type="massdelete"/>
            </massactions>
            <views>
                <view type="standard"/>
            </views>
            <filters>
                <filter type="select" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" filtermethod="server" labelmode="no" condition="StageName" filteroffoptionlabel="All Stages">
                    <sources>
                        <source type="model" effectsbehavior="justdefault" model="OppStages">
                            <labeltemplate>{{{stageName}}}</labeltemplate>
                            <valuetemplate>{{stageName}}</valuetemplate>
                        </source>
                    </sources>
                </filter>
            </filters>
        </skootable>
    </components>
    <resources>
        <labels/>
        <css/>
        <javascript/>
        <actionsequences uniqueid="sk-2A_j-252"/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>

Thank you Bill for responding on this.

We were using same solution but it was impacting performance of our pages, so we want to use standard approach. Moreover aggregate models do not support multi select picklist.

Praveen,

The aggregate model does slow things a bit.  If you don’t have a lot of changes to your pick list fields, you can set the options manually on the filter.

You can also manually edit the XML of the filter to enable the multiselect option.

Just change this:  <filter type=“select”

To this:  <filter type=“multiselect”

Thanks,

Bill

Thank you Bill.

Praveen and Bill, in the latest release of Skuid (11.1.x) Multi-select filters now support manually-created sources or a model as a source for the filtering options. (See release notes here.)

Praveen, does this give you a way to employ Bill’s suggestion declaratively?

Mark,

Thanks for pointing that out.  I am glad that it is now ‘declarative’.

Best!

Bill

I have implemented it using aggregate model, now running into a different issue. We are skuid version 11.0.2