How to save Page with pagelist under it
Hi Friends-
I have design structure like this-->
TestPage
PList(1). Properties
PList(2).Properties
I need suggestion on how to save the pagelist in DB such a way that I can run a report and show back in the UI. thank you
Updated: 6 Mar 2023 14:24 EST
Bits in Glass
IN
@Sharadk1 You need to have 1 data type for holding main page data and index table to hold the pagelist. For reporting, to get page data you can do directly refer it by optimizing it and to get pagelist data(class join with index--class) you can use a unique column and pass the unique column to the index-table you have created. So you need to have a common column to connect page and pagelist but this column should act as unique column for that one page all the pagelists under that page.
Capgemini
US
@Anoop Krishna thank you so without indexing , its not possible? because this Page is not under the workpage so wondering how to save when its just a CP page or a user page? thanks
Bits in Glass
IN
@Sharadk1 okk. In that case if there is no option to move it under pyworkpage, you can save these pages in pagelist to data type but for all the rows you need maintain a common unique column for joining with the page data. Now you can do class join this data class with the main data class.
Capgemini
US
@Anoop Krishna Can you pls share idea or steps to make it work?
my plan is to have this page and save the page with all the child pagelists? thank youj
Bits in Glass
IN
TestPage. Childlist(1)
. Childlist(2)
Update page
D_savabletestPage = TestPage
Savedatapage. ID(unique column)
D_savablechildlist
Source is activity-> as it's a pagelist. Loop the results and save it to it's dedicated data type. All the results are having ID(unique column) on it.
Now you have main page and pagelist in 2 different data type.
Now create a report on main page data type class. Class join with the pagelist class. Use the unique ID for joining.