Home > Forum > User Voice > SQL report

SQL report
0

I have a question:
How to create an SQL filter in the "source" section of the report that will show only the column/attribute items indicated in this SQL. The attribute column consists of the dictionary entry ?

MVP

Hi,

I'm sorry, but I don't grasp what you are asking.

You can only display the columns/attribute selected in the column tabs. In the views you can define, which of these selected columns would be available.

I don't see any relation to the filter.

Maye reading through this post will help you:

https://community.webcon.com/posts/post/reports-configuration-views-editing/233

Or/and you could add more information / an example.
- What attributes/fields there are in the dictionary.
- What entries exists.
- What entries should be displayed.
- What should not be displayed.

Best regards,
Daniel

In reply to: Daniel Krüger (Cosmo Consult)

Hi,

I'm sorry, but I don't grasp what you are asking.

You can only display the columns/attribute selected in the column tabs. In the views you can define, which of these selected columns would be available.

I don't see any relation to the filter.

Maye reading through this post will help you:

https://community.webcon.com/posts/post/reports-configuration-views-editing/233

Or/and you could add more information / an example.
- What attributes/fields there are in the dictionary.
- What entries exists.
- What entries should be displayed.
- What should not be displayed.

Best regards,
Daniel

You're right, I wrote it a bit wrong.
I have an attribute that contains the data source as a list of values e.g. 1, 2, 3, 4, 5 etc.
I want to display only values 3 and 5 on the report.

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.