Question Re: Report Generation using Query configuration in backoffice in CRM and CX Q&A

Report Generation using Query configuration in backoffice

Former Member — Wed, 23 Jan 2019 17:42:34 GMT

Hello Team,

I am new to Hybris 6.7 version. I have a requirement to generate the report using query configuration in backoffice. After that, we should be able to download the report in csv format. I am able to download the report, but my columns are not displaying. All values are coming as null.

Request to help me in detail using one complete example and screenshot if required.

Thanks & Regards,

Re: Report Generation using Query configuration in backoffice

arvind-kumar_avinash — Wed, 23 Jan 2019 18:13:30 GMT

One will be able to understand the root cause of the issue you are facing only when you mention the steps you have followed so far.

Re: Report Generation using Query configuration in backoffice

Former Member — Thu, 24 Jan 2019 18:14:34 GMT

Did anyone get a chance to look into query?

Request to help me in this.

Re: Report Generation using Query configuration in backoffice

Former Member — Fri, 01 Mar 2019 21:22:48 GMT

Hi Aravind,

I have been facing the same issue. I followed the similar steps that they mention in this below link. https://help.hybris.com/1811/hcd/c97c0ac3701b400b915a8f774f06045e.html

I was able to get the results that i was expecting but when i am using the condition such as: select {cust.Pk} as custpk from {b2bcustomer as cust} where {cust.firstname} = ?user

i have added the new attribue but when i am searching with the user its not giving any results. please check the attachment for the screen shotlink text

please let me know your thoughts.

Thanks & Regards, Shiva

Re: Report Generation using Query configuration in backoffice

arvind-kumar_avinash — Sat, 02 Mar 2019 00:08:12 GMT

Hi Shiva - you can hope a faster response from the community if you create a new question for your specific problem.

In order to analyze your problem further, I need the screenshot/values of all fields that you filled up to create a Report Definition.