jorg2

Thanks a lot Justin. It works. Have a nice day! Jorg

Hi Peter,

thank you for your instant reply.

I understand that it’s possible to use complex statements / subqueries in where clauses. This makes a solution possible to
– Filter by username with environment variable $$USERID$$ AND
– Filter a subset of records for example that meet the condition (sales > 100)

This makes it possible to devide the records of a large dataset into several output tables depending on conditions that are defined in the where clause (or Shortcode or URL Parameters). I bought the premium version and I’m currently testing this.

My goal is to make large datasets in ONE table more readable by adding a visual component (font color) so that the user can easily identify records where he has to take some action. It’s important to mention that the conditions for formatting are variable from user to user. Example: User 1 Table 1: Sales > 100 => font green, User 1 Table 2: Sales > 35 => font green, User 2 Table 1: Sales > 10 => font green. The cutting values for green are calculated in the backend. They are available in a MySQL table.

I thought there could be a solution by adding CSS or custom Javascript to a collumn. I saw that there is a “Code Manager Plugin” that is completing WP Data Access. Is there a solution by adding Javascript etc. with the Code Manager?

Many Greetings
Jorg

• This reply was modified 2 years, 11 months ago by jorg2.

The best solution for me would be if the values (10, 100) could be defined dynamically based on sql-queries that select basic user inputs made before.

Another solution for me could be to do conditional formatting based on the content of a hidden collumn “ColorCode”:

– If ColorCode = 1 then font color Sales = red
– If ColorCode = 2 then font color Sales = yellow
– If ColorCode = 3 then font color Sales = green