populating repeating section in a UX component

[cpampas]

i am a bit confused on how I should do this:

I have a ux with a repeating section
the main part of the ux is bound to a table (tblDocs), with the primaryKey (DocID)
the repeating section is bound to a table (tblDeliveryNotes), with primary key (NoteID)
the linking field is SuplierID, comon to both tables


i' d like that on the change event of an unbound dropdownBox (myDropDown) in the main part of the UX to choose value of a suplierID , to populate the repeating section with all the records in tblDeliveryNotes where the field suplierID = suplierID in the control myDropdown.
After the repeating section is populated, I should be able to edit records, but no need for adding new ones.

I have tryed the javaScriptActions : "populate controls from a table", and "lookup fill in" , but iam afraid that i could be going the wrong way
any thoughts or a video I could watch related with this ?


thanks

image.png

[danh]

Re: populating repeating section in a UX component

That's very easy to do with xbasic in an ajaxCallback. I do it all the time.

This should get you started. Just modify and call this from the onChange event of your unbound "MyDropdown" control.

function getDeliveryNotes as c (e as p)
dim vjs as c
dim cn as SQL::Connection
dim flg as l = cn.open("::Name::conn")
dim args as SQL::Arguments
args.Set("whatSupplierID",e.dataSubmitted.myDropDown)
sqlStmt = "SELECT [U][your field names here][/U] FROM tblDeliveryNotes WHERE SupplierID = :whatSupplierID"

if (flg .and. cn.Execute(sqlStmt,args)) then
     dim rs as SQL::ResultSet = cn.ResultSet
     dim cnt as n = 0
     while rs.NextRow()
          cnt = cnt + 1
          row = convert_type(cnt,"C")
          eval("j.[U]RSFIELDNAME[/U]_a5instance" + row) = rs.Data("[U]TBLFIELDNAME[/U]")
          '....add the rest of the repeating section fields...
     end while

     'JavaScript to return
     vjs = "{dialog.Object}._setRepeatingSectionRowCount('[U]CONTAINER_RS[/U]'," + cnt + ",true,true);" + crlf()
     vjs = vjs + "{dialog.Object}.populate(" + json_generate(j) + ",1,false);"

else
     vjs = "alert('Error: " + js_escape(cnx.CallResult.text) + "');"
end if

if flg then
     cn.Close()
end if

getDeliveryNotes = vjs

end function

There, I wrote the whole thing for you :)
Replace RSFIELDNAME and TBLFIELDNAME for each repeating section control you want to populate. Also, make sure the name of the repeating section is correct.

Hope that helps.

[Davidk]

Re: populating repeating section in a UX component

Although the code is great... because Carlos is using bound data tables in the UX, it's not really necessary.

The dropdown needs to be an unbound control... and in the onChange event of this control run the Action "Get Primary Key values for Records in Query".

This action will get a query key value from a control (in this case the dropdown) and then retrieve the needed record.

Have a look... http://www.youtube.com/watch?v=CkMC7y_gnPw

[GGandhi]

Re: populating repeating section in a UX component

After the repeating section is populated, I should be able to edit records, but no need for adding new ones.

I know you asked about ux, can this not be done with parent grid and editable child grid.. I would think it lot easier and you can open the child grid below the parent in the free form area and it will look the same as ux with repeating section. you are going to edit the data nothing fancy.

[cpampas]

Re: populating repeating section in a UX component

I have tryed David's suggestion, and it worked out fine. Anyway i will try yours aswell Dan, even if only for the sake of learning something new.
Great help
Thanks