I want to display child records of a particular object whose parentid are in this text field.How can

I have text field with series of IDs separated by comma. I want to display child records of a particular object whose parentids are in this text field.How can I do it in skuid?

You’ll have to use a snippet or maybe “hack” the xml.

Hi pat, How to use snippet and where can we write this snippet?

I would use Welcome to Skuid Docs — Skuid v15.1.6 Documentation and then add the snippet to the page.

Here’s a potential solution expanding on Pat’s response:

  • Parse that text field and populate a ui-only model with the list of ids from that field
  • Point your “Field from another model” model condition to that ui-only model to get the child records. Don’t forget to use “in”, not “equals to”, since you want to return the match for all records in the ui-model

Here’s XML showing how to use a snippet to convert a text field to records in an ui-only model:

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" showheader="true">
<model id="SourceModel" limit="20" query="true" createrowifnonefound="true" datasource="Ui-Only" processonclient="true">
 <field id="list_of_things" displaytype="TEXT" length="255" label="List of Things" defaultvaluetype="fieldvalue" defaultValue="pumpkin,cinnamon,cider,nutmeg,vanilla,apple,chai"/>
<model id="UiModel" limit="20" query="true" createrowifnonefound="false" datasource="Ui-Only" processonclient="true">
 <field id="name" displaytype="TEXT" length="255" label="Name"/>
<basicfieldeditor showheader="true" showsavecancel="false" showerrorsinline="true" model="SourceModel" uniqueid="sk-2o1G-1548" mode="read">
 <column width="100%" uniqueid="sk-2o1G-1544">
 <section title="Section A" uniqueid="sk-2o1G-1545" collapsible="no">
 <field uniqueid="sk-2o32-1882" id="list_of_things"/>
<wrapper uniqueid="sk-2o3P-2001">
 <buttonset model="SourceModel" uniqueid="sk-2o3B-1906" position="center">
 <button type="multi" label="Parse Text Field to Ui Model below" uniqueid="sk-2o3C-1911">
 <action type="custom" snippet="parseTextFieldToUiModel"/>
 <renderconditions logictype="and"/>
 <styleitem type="background"/>
 <styleitem type="border" padding="bottom,top,">
 <styleitem property="padding-top" value="24px"/>
 <styleitem property="padding-bottom" value="24px"/>
 <styleitem property="box-sizing" value="border-box"/>
 <styleitem type="size"/>
<skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="client" searchbox="true" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="UiModel" buttonposition="" mode="edit" allowcolumnreordering="true" responsive="true" uniqueid="sk-2o0i-1376">
 <field id="name" uniqueid="fi-2o0i-1377"/>
 <action type="edit"/>
 <action type="delete"/>
 <massactions usefirstitemasdefault="true">
 <action type="massupdate"/>
 <action type="massdelete"/>
 <view type="standard"/>
<jsitem location="inlinesnippet" name="parseTextFieldToUiModel" cachelocation="false" url="">var $ = skuid.$;
var list_of_things = skuid.model.getModel('SourceModel').getFirstRow().list_of_things.split(',');
var UiModel = skuid.model.getModel('UiModel');
list_of_things.forEach(function(thing) {
 additionalConditions: [
 { field: 'name', value: thing}
 ], doAppend: true
 <actionsequences uniqueid="sk-2n_z-599"/>
 <styleitem type="background" bgtype="none"/>