Creating Declare Index class for Page Property

User Experience
, ,
1

Hi All,

Can anyone tell me that can we create a Declare Index Table for Page Group property and Single Page Property?

Regards,

Mamatha Adiraju

2

@Mamatha Adiraju

Yes, we can create declare index table for Page group

I hope this helps!

PAge group.jpg
PAge group.jpg1576×1594 294 KB

3

Hi @Mamatha Adiraju

Please go through once below two article, similar to your question.

can declare index be used for page grp property? and Declare Index – its Configuration, Usage & Execution

I hope this will help you.

Thanks,

Ashok

4

Hi @Mamatha Adiraju

Declare Index table will be created for page group property when you run the optimization wizard and when you optimize the single page property declare index table will not created in the backend only column will be added to the current table.

Thanks,

Ajay kumar

5

@Mamatha Adiraju

We can only create declar index for .Page List or Page Group property in this pattern PageList().EmbeddedPage.AnotherPageList().

Optimization has two ways to do :

  1. Single property - In this case Declare index will not created in backend only a added column will add to the table

2.Pagelist,Pagegroup property- Declare index rule created here and also it can be created standalone with any pagegroup property.

Hope this will help.
Thanks,
Somil

6

Hi @Mamatha Adiraju,

No, You cannot create the Declare Index Table for Single Page Property. (i.e. Product.ProductName) If you optimize this property it will create the new column in DB

But you can create the Declare Index Table for Page Property (i.e. Product Page).

Yes, You can create the Declare Index Table for Page Group Property(i.e. Adderess(Home),Address(Office).

You can create declare index from sysadmin>Declare Index> Index_PageGroup Property>

give source class, index class details and map the properties from source to index class. Save it.

you can use this index class properties in Report definition.

Hope it helps

Thanks

Regards

Raja