Need help with reference qualifier
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2024 02:56 AM
I have a table u_employment. I am creating a catalog item based on this table. I have two variables employee name and employment. Based on certain conditions I am choosing employment value.
Reference qualifier:
javascript: 'u_employee='+current.variables.employee.sys_id + '^u_active=trueORu_start_dateRELATIVELT@month@ahead@1'
This works as expected and returns the employee_id. However, I want to return employment_number. Is it possible?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2024 03:27 AM
To get the number you need to have a number field on the table either custom created or the ootb created field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2024 03:48 AM
I have this field in the table already. Not sure how to display this field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2024 03:54 AM
Yes it is possible to display the number what exactly you are looking for how to show the field on the form or how to populate the number in that field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2024 04:01 AM
When I chose the Employement, Employment ID is displayed. But I want employment_name to be displayed.