User Info, Company Info, Ad Notice info based on Ad Notice ID
Given ad notice id 70473 , this guide will highlight the BA database tables responsible for this ad notice’s configuration and how to retrieve this data.
The ad notice query string contains the ad size, company id, and notice id. This call can be found in the web inspector of common browsers. Using this method, you can identify the origin of the ad notice on a live site.
nid=70473 will be a column in the table ad_notice. This table is found in BA.
The relationship between user and company is consistent with all BA referenced tables.
The following query is an example of how these tables fit together:
SELECT c.company_name, u.user_name, a.an_internal_name
FROM ad_notice as a
left outer join company as c on c.company_id = a.an_company_id
left outer join user as u on u.user_id = a.an_created_by_user_id
WHERE a.an_id = 70473
Comments
0 comments
Please sign in to leave a comment.