Issue with Model Lookup

Dave,

I tried this in my developer org. that is on Skuid 10.0.4. What you are trying to do works. I have included my XML that does a count of tasks by WhoId and calculates a percentage.

In looking at your post, I noticed that in your 3rd paragraph your model name is ‘TimesheetentryAgg’.

In your 5th paragraph, you show your model lookup as MODEL_LOOKUP(“timesheetEntryAgg”,“TotalPaid”).

Notice that the ‘t’ in your model lookup is NOT capitalized. That may be your problem. I would verify that your first model has a row in it and then carefully check that your model name and model field in your model lookup UI field match your first aggregate model.

Thanks,

Bill

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">
    <models>
        <model id="TotalTasks" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Task">
            <fields>
                <field id="Id" name="countIdTask" function="COUNT"/>
            </fields>
            <conditions/>
            <actions/>
            <groupby method="simple"/>
        </model>
        <model id="TasksByWhoId" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Task">
            <fields>
                <field id="Id" name="countIdWho" function="COUNT"/>
                <field id="Percentage" uionly="true" displaytype="FORMULA" label="Percent of Total" ogdisplaytype="TEXT" readonly="true" returntype="PERCENT" precision="3" scale="2">
                    <formula>{{countIdWho}}/MODEL_LOOKUP("TotalTasks","countIdTask")*100</formula>
                </field>
            </fields>
            <conditions/>
            <actions/>
            <groupby method="simple">
                <field id="WhoId" name="whoId"/>
                <field id="Who.Name" name="whoName"/>
            </groupby>
        </model>
    </models>
    <components>
        <pagetitle model="TotalTasks" uniqueid="sk-3wyOpP-175">
            <maintitle>Total Tasks:  {{$Model.TotalTasks.data.0.countIdTask}}</maintitle>
            <actions/>
        </pagetitle>
        <skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" alwaysresetpagination="false" createrecords="false" model="TasksByWhoId" buttonposition="" mode="readonly" allowcolumnreordering="true" responsive="true" uniqueid="sk-3wyj7V-226">
            <fields>
                <field id="Who.Name" name="whoName" hideable="true" uniqueid="fi-3wykkT-236"/>
                <field id="Id" name="countIdWho" hideable="true" uniqueid="fi-3wykkT-237" valuehalign="" type="">
                    <label>Number of Tasks</label>
                </field>
                <field id="Percentage" hideable="true" uniqueid="fi-3wz8Vf-402" decimalplaces="" valuehalign="" type=""/>
            </fields>
            <rowactions/>
            <massactions usefirstitemasdefault="true"/>
            <views>
                <view type="standard"/>
            </views>
        </skootable>
    </components>
    <resources>
        <labels/>
        <javascript/>
        <css/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>

Hi Bill,

Thank you for your help.

Unfortunately the typo was in post only… i wrote it in a hurry , sorry

I looked at your example, ty for providing it and it seems liek u said i’m doing things correctly.

So still cannot figure out issue 😦

So here’s SS from every step , maybe it will help?

I’m not very good at working with console, but trying to lookup model to see if UI field has value , but do not see it at all there (is it normal?)

Thank you!

I found the culprit!

Instead of just looking at the builder page, I decided to test your page Bill, once i made some changes on it to work on my org

and realized it did not return results as well…

You mentioned u tested it on 10.0.0.4 , so tested it on my sandbox on which i was testing latest version and it worked!

My Production org is still under 8.15.14 … not sure why it’s not working on this version, but in case someone has same issue, here’s the answer

Don’t put off too long updating skuid like me 😃 (i try to not update too often as it takes me a lot of time to test all of our pages and other items that uses skuid to make sure no crucial bug and all working as it should , hope SF allows rollbacks soon!)

Does anyone know if this is a new feature that came in after 8.15 version?

Thx