Lookup value in cmdb_ci_business_app based on entered company name

[Bret Smith]

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)

[Brad Bowman · Accepted solution]

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:

[Bret Smith]

business_app_company variable reference lookup on core_company table

javascript: 'company =' + current.variables.business_app_company;