Hi To Populate Multiple Grids from one main record
Two Grids are on a same page with a same main record and different page field name.
I would like to populate two grids independently from one record based on conditions, but not sure on how we can distinguish between grid names.
I under GetGrid, but how we can write under IF condition.
The outcome of below code is it's populating both grids based on the last rowset result and not by specific Grid
Below is my code under field Change.
Local Rowset &Level0wk, &Level0wk1, &firstGrid_RS, &SecondGrid_RS;
Local Grid &getfirstGrid, &getscndGrid;
Local string &sWhere;
&getProType = IP_PROMOTIONS.IP_PROMOTION_TYPE.Value;
/*&getGrade = IP_PROMOTIONS.IP_GRADE.Value;
&getMonth = IP_PROMOTIONS.MONTHCD.Value;*/
&Level0wk = GetLevel0();
&Level0wk1 = GetLevel0();
&getfirstGrid = GetGrid(Page.IP_DEPTSTG_DTALOAD, "IP_PROMO_FE");
&getscndGrid = GetGrid(Page.IP_DEPTSTG_DTALOAD, "IP_PROMO_FE1");
rem MessageBox(0, "", 0, 0, "ActiveRowCount->" | &getfirstGrid);
MessageBox(0, "", 0, 0, "First Grid" | &getfirstGrid);
MessageBox(0, "", 0, 0, " Second Grid" | &getscndGrid);
If &getProType = "D" Then
REM &firstGrid_RS.Select(Record.IP_PROMOTIONS, "WHERE IP_PROMOTION_TYPE = :1 AND IP_ELIGIBILITY = 'E'", &getProType);
If All(&getfirstGrid) Then
&firstGrid_RS = &Level0wk(1).GetRowset(Scroll.IP_PROMOTIONS);
&firstGrid_RS.Flush();
&firstGrid_RS.Select(Record.IP_PROMOTIONS, "WHERE IP_PROMOTION_TYPE = :1", &getProType);
End-If;
If All(&getscndGrid) Then
&SecondGrid_RS = &Level0wk1(1).GetRowset(Scroll.IP_PROMOTIONS);
&SecondGrid_RS.Flush();
&SecondGrid_RS.Select(Record.IP_PROMOTIONS, "WHERE IP_PROMOTION_TYPE = :1 AND IP_ELIGIBILITY = 'E'", &getProType);
End-If;
End-If;
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 29 weeks ago
2 years 34 weeks ago
2 years 34 weeks ago
2 years 36 weeks ago
2 years 36 weeks ago
2 years 37 weeks ago
2 years 39 weeks ago
2 years 40 weeks ago
2 years 43 weeks ago
2 years 49 weeks ago