I have a requirement to filter records dynamically using the a meta-key / meta-value from usermeta data table . It is dynamic because each user has a “team_id” assigned as metakey, so when the report is viewed by the logged in user, it auto-filters and shows only information of all the members of the users team dynamically. So if user belongs to “TEAM_A” (meta-key is “team_id” and meta-value is “TEAM_A”) and if in the table in context there is column called “team”, i want to filter all rows from “team” column, which satisfies the condition of the team that the user belongs.
Kindly advise how we can achieve this, if possible with a sample.
Also, Peter you are doing a great job..i could sucesfully create a star-schema view out of a fact table of records and dimension tables. (I am going to try extended star schema 🙂 )
- The topic ‘Create variable where clause parameters from User Meta (similar to $USERID$ )’ is closed to new replies.