How to get single record from Data type table ?

Hi Everyone,

My requirement is to pull the single record from data type table when click on “Add Member” Button. Then the next record will be added when clicking on button (first record is present). Next 3rd record will be added when clicking the button. Any one please help me

@NagarjunaS16644648

  1. You use a table layout in the UI and source it with pagelist

  2. On clicking add member button, what you will be doing is, pass the index to the data page, and append that result to table layout pagelist.

So in the data type you will have the sequential number against each record. 1,2,3…if not you need a column and maintain this sequential number, which we will be using as index.

Now create a data page with list structure, sources by report definition and add param as index/seqno.

On click of add member button, append result from dpage to pagelist.

AppendTo

. Members

DpageList[index:param.index].pxResults(1)

You need to set param.index before copying result.

param.index= @LengthOfPageList(.Members) +1

@NagarjunaS16644648

Pass primary key as parameter to the lookup data page and you can fetch single record from data type.

@Anoop Krishna Can you please provide the screenshot. I am getting Target and source field classes should be compatible error.

@NagarjunaS16644648will you provide the datatransform screenshot. I am getting error Target and source field classes should be compatible.

@NagarjunaS16644648 please provide the screenshot I’m getting Target and source fields must be compatible error.

@SaiVardhanM16657607