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.

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings