Hi Jaiti, this might be easier if you use a model on Opportunities. That way you can use a model condition for the Stage, you can use filter easily and you are still able to display all the Account information though the Opportunity. I created a simple page with standard objects and fields, hope this is helpful for you:

<skuidpage personalizationmode="server" showsidebar="false" useviewportmeta="true" showheader="false">

    <models>

        <model id="Opps" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Opportunity">

            <fields>

                <field id="RecordTypeId"/>

                <field id="AccountId"/>

                <field id="Account&#46;Name"/>

                <field id="StageName"/>

                <field id="Amount"/>

                <field id="Account&#46;Phone"/>

                <field id="Account&#46;CreatedDate"/>

            </fields>

            <conditions>

                <condition type="fieldvalue" value="Discovery" field="StageName" operator="=" enclosevalueinquotes="true"/>

                <condition type="fieldvalue" field="Amount" operator="gte" inactive="true" enclosevalueinquotes="false" name="__autofilter__nstart__Amount" state="filterableoff" value=""/>

                <condition type="fieldvalue" field="Amount" operator="lte" inactive="true" enclosevalueinquotes="false" name="__autofilter__nend__Amount" state="filterableoff" value=""/>

            </conditions>

            <actions/>

        </model>

    </models>

    <components>

        <pagetitle model="Opps" uniqueid="sk-3qFi-529">

            <actions/>

            <maintitle>Model on Opportunity, Model condition "Stage = Discovery", Filter on Amount</maintitle>

        </pagetitle>

        <skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="Opps" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-3qEJ-328">

            <fields>

                <field id="Account&#46;Name" hideable="true" uniqueid="fi-3qG5-743"/>

                <field id="Account&#46;Phone" hideable="true" uniqueid="fi-3qG7-753"/>

                <field id="Account&#46;CreatedDate" hideable="true" uniqueid="fi-3qG8-762"/>

                <field id="StageName" uniqueid="fi-3qEJ-332"/>

                <field id="Amount" uniqueid="fi-3qEJ-333"/>

            </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="numericrange" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="auto" labelmode="auto" filtermethod="server" conditionfield="Amount" filteroffoptionlabel="All amounts"/>

            </filters>

        </skootable>

    </components>

    <resources>

        <labels/>

        <javascript/>

        <css/>

        <actionsequences uniqueid="sk-3qE0-225"/>

    </resources>

    <styles>

        <styleitem type="background" bgtype="none"/>

    </styles>

</skuidpage>

I also tried to use the model on Accounts. After you added “Opportunities” as Child Relationship field, you can apply conditions on it, e.g. “StageName = Discovery” and “Amount > 1000”.

So you will get a list of all Accounts, but you will only see filtered Opportunities. Is that the expected result? Please try the sample page below:

<skuidpage personalizationmode="server" showsidebar="false" useviewportmeta="true" showheader="false">

<models>

    <model id="Accounts" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account">

        <fields>

            <field id="RecordTypeId"></field>

            <field id="Opportunities" type="childRelationship" limit="20">

                <fields>

                    <field id="Amount"></field>

                    <field id="StageName"></field>

                    <field id="Name"></field>

                </fields>

                <conditions>

                    <condition enclosevalueinquotes="true" operator="=" type="fieldvalue" field="StageName" value="Discovery"></condition>

                    <condition enclosevalueinquotes="false" operator="gt" type="fieldvalue" field="Amount" value="1000"></condition>

                </conditions>

            </field>

            <field id="Name"></field>

            <field id="Phone"></field>

            <field id="CreatedDate"></field>

        </fields>

        <conditions></conditions>

        <actions></actions>

    </model>

</models>

<components>

    <skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="Accounts" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-3qJW-344" heading='Model on Account, Child relationship condition "StageName = Discovery" and "Amount > 1000"'>

        <fields>

            <field id="Name" uniqueid="fi-3qJW-347"></field>

            <field id="Phone" uniqueid="fi-3qJW-348"></field>

            <field id="CreatedDate" uniqueid="fi-3qJW-349"></field>

            <field id="Opportunities" type="CHILDREL" limit="100" uniqueid="fi-3qJW-346" allowhtml="true">

                <label>Opportunities</label>

                <template><b>Name: {{Name}}</b>

Stage: {{StageName}}

Amount: {{Amount}}

Thanks a lot Luzie.  I was able create a field on Oppty and filter. 

Great, thank you for the feedback!