- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-06-2024 12:44 PM
Reference field to bring back only the matches in the cmdb_ci_business_app table matching company value entered.
use form variable named: business_app_company to filter/return only business applications that match company
companyLIKE(current.variables.business_app_company)
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-06-2024 02:14 PM
Hi Bret,
This will work if the business_app_company variable is a reference to the core_company table so that the value (sys_id) will match the value of the company field on the cmdb_ci_business_app table. Since you are using the value of a variable, the reference qualifier has to look like this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-06-2024 02:14 PM
Hi Bret,
This will work if the business_app_company variable is a reference to the core_company table so that the value (sys_id) will match the value of the company field on the cmdb_ci_business_app table. Since you are using the value of a variable, the reference qualifier has to look like this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-06-2024 02:30 PM
business_app_company variable reference lookup on core_company table
javascript: 'company =' + current.variables.business_app_company;