Forum Discussion

PhilB's avatar
PhilB
Kudo Collector
10 years ago
Solved

Omit certain results from data when pulling from the SQL database

Hello,   I imagine this is possible, i just cant seem to figure it out myself. And i know i could apply a filter for this on my visualisations. However this could get tedious quickly.   Reason fo...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    10 years ago

    PhilB Are you ever going to need the info for those users? If not, you could just filter this out by referencing a SQL View where the logic is built in to exclude those users, but return the relevant information you want for the sales table.

PhilB's avatar
PhilB
Kudo Collector
10 years ago

 

Hi again,

 

Unfortunately for me the information is stored across 100+ tables, its a wordpress website with a plugin called Event Espresso for event management and BuddyPress to take care of the community side of things. The biggest problem im having right now is linking everything together. everything from event espresso is a custom post type in the wordpress posts tables. Its a bit of a mess if im honest.

 

Thank you for the solutions though i will give them a try once i have finished with some of the other bits and pieces im working on this afternoon.

 

PhilB