ViewType representation in Backoffice Administration Cockpit is called a Report Definition. A Report Definition allows you to create customized calculated sets of data dependant on some other data. You can rely on the full power of the FlexibleSearch to specify your result sets.
We can create reports to daily use. Let’s suppose if business wants to know details of products on daily basis or how many new users added on daily basis. Reports can be very useful in these scenarios. We can download these reports in CSV format.
Table of Contents
Report Creation Through Backoffice
Let’s create one sample report.
Go to Backoffice -> System -> Report Definitions
Click on + Icon.
Provide Identifier For Example: Approved_Electronics_Reports
Now create columns.
Now create Params:
Now it’s time to provide the query. Here is sample query.
SELECT {p:code} as productCode, {p:name} as productName as CatalogVersion from {ArticleApprovalStatus as aap join Product as p on {aap:pk}={p:approvalStatus}} where {aap:code}='approved' and {p:catalogVersion}=?catalogVersion
Now you can see new report in the list.
Now Click on the report and further click on search by type.
Choose Catalog and Click on Search.
You can download this report in CSV and provide to business for further use.
Report Creation through Items.xml
For More Information about Hybris Topics please visit https://www.techwringer.com
