Populate asset value based on category, subcategory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 02:02 AM
Hi Developers,
I've created a customized catalog form called 'Create an Incident' in which I have used variable 'requested for' which is referenced by sys_user table as category and subcategory which is reference to incident table and asset variable field which is referenced to alm_asset table. I want asset field to show only value assigned to requested for and we have one choice in category I.e., computer peripheral similarly in subcategory we had 5 choice, keyboard, mouse, adapter, etc.
So based on category and subcategory select asset field value show assigned to requested for and category is computer peripheral and subcategory user selected.
So my question is, how can we populate asset value based on category, subcategory and assigned to requested for?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2024 10:52 PM
your question seems a little confusing, basically you want assets to be shown based on category , sub category and requested for?
Couple of ways to do this, but i think best would be right down the logic in a script include and then return that array onto this field based on the logic defined