Hi, I'm developing a custom module that should show the records added by the user on a UDT on the site. So far I've checked the UserDefined* tables by I can't see how to get the rows.

So, users are adding rows to the wishes UDT, and I need to show on my module only the rows added on that Wishes UDT by the logged user.

Could anybody help?

Thanks in advance,

Esteve.

I really recommend to use the UDT API:

Dim udt As UserDefinedTableController
Dim ds As DataSet = udt.GetDataSet(moduleid)

'Look Up the title of the "Created by Column
Dim dv As New DataView(ds.Tables(1), _
   String.Format("[{0}]='{1}'", "FieldType", "CreatedBy"), "", DataViewRowState.CurrentRows)
Dim titleOfCreatedByColumn = dv.Item(0)("FieldTitle")

'Filter Data
dv = New DataView(ds.Tables(0), _
            String.Format("[{0}_UDT_Original] = '{1}'", titleOfCreatedByColumn, Me.UserInfo.Username), _
            "", DataViewRowState.CurrentRows)

Esteve,

API is part of the source code, you can download and install in any DNN 3.3.5-3.3.7 installation. Another option is using class browser in VS or Reflector.