I have an idea to create an audience (in Content Publishing) based off of logic from the sys_user table (ie, if a user has a specified date in one field I want to create notifications and banners for their specific managers). I have tried to use the internal Audience logic to create this but have yet to succeed. I would like to build the audience via a script so that I can include the specific logic in the script and have the script run everyday so that the audience is changed daily. Is this possible or am I just barking up the wrong tree?
Example: If User's prim_location is 'Florida', then I want to show a banner for that employee's manager.
