Report Generation using Query configuration in backoffice

[Former Member]

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,

[arvind-kumar_avinash]

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.

[Former Member]

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

[arvind-kumar_avinash]

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.

[Former Member]

Did anyone get a chance to look into query?

Request to help me in this.