Hi, I need some help. This is what my page design is ?
1) My page has a derived rcd on level 0
2) Grid on level 1 which I'm using a view built by me to populate the data into the view. This view is basic select with 8 fields.
WHERE fieldname = 'A'
I'm using a rowset class topopuate the rows but somehow it is populating for all emplids'
This is my code:
SQLExec("SELECT COUNT(*) FROM PS_WW_GEM_IN_A_VW WHERE EMPLID = :1 AND EMPL_RCD = :2 ", DERIVED_HR.EMPLID.Value, DERIVED_HR.EMPL_RCD.Value, &COUNT_SCHD);
If &COUNT_SCHD > 0 Then
&ABSW_e_GRID = CreateRowset(Record.GW_SUPP_IN_A_VW);
&ABSW_e_GRID.Fill("WHERE EMPLID = :1 AND EMPL_RCD = :2 ", DERIVED_HR.EMPLID.Value, DERIVED_HR.EMPL_RCD.Value);
For &NEW = 1 To &ABSW_e_GRID.ActiveRowCount
&EMPLID_GRID = &ABSW_e_GRID(&NEW).GW_SUPP_IN_A_VW.EMPLID.Value;
&EMPL_RCD_GRID = &ABSW_e_GRID(&NEW).GW_SUPP_IN_A_VW.EMPL_RCD.Value;
&START_DT_GRID = &ABSW_e_GRID(&NEW).GW_SUPP_IN_A_VW.START_DT.Value;
&END_DT_GRID = &ABSW_eSUP_GRID(&NEW).GW_SUPP_IN_A_VW.END_DT.Value;
WinMessage("GRID SELECT " | &EMPLID_GRID | " " | &EMPL_RCD_GRID | " " | &START_DT_GRID | " " | &END_DT_GRID | " " | DERIVED_HR.EMPLID.Value | " " | DERIVED_HR.EMPL_RCD.Value);
All values are getting displayed but there are not populating into the grid. Above code is in apllication package and this package is being called in postbuil on the page. Just to test I also added above code in page.activate peoplecode..
I only need data for the empl which is being displayed on level 0.
I would appreciate your help..