I have jms installed along with jomsocial and AEC. I'm setting up an affiliate network.
I would like to show only female users on one of the clones.
I'm having trouble when trying to create or replace the community_users view with my own because views created with subqueries or unions use a temp table and make a non updatable view.
I was wondering if you have any tips or tricks you can share with me to create a clone that only shares users that are female? Below is the code to create the view.
| Code: |
CREATE OR REPLACE VIEW child.child_community_users AS
SELECT
u.userid,status,status_access,points,posted_on,avatar,thumb,invite,params,view,
friendcount,alias,latitude,longitude,profile_id,storage,watermark_hash,search_email,
friends,groups
FROM master.`master_community_users` AS u
JOIN master.master_community_fields_values AS fv ON fv.user_id = u.userid
WHERE fv.field_id = 2 AND fv.value = 'Female'
|
Forum
