Hi @swapnil15
try edit in catalog builder ,
Determine the correct table and relationship that defines what “Available For” means. This might involve a many-to-many table or a condition based on user or group relationships.
The script is hypothetical as the specific tables and relationships for “Available For” need to be identified.
Business rule or use it in background script
var catItemsWithoutRelatedRecords = [];
var catItemGR = new GlideRecord('sc_cat_item'); // Catalog Item table
catItemGR.query();
while(catItemGR.next()) {
var relatedRecordGR = new GlideRecord('related_table'); // The related table that defines “Available For”
relatedRecordGR.addQuery('catalog_item', catItemGR.sys_id); // Assuming the relationship is stored here
relatedRecordGR.query();
if (!relatedRecordGR.hasNext()) { // No related records found
catItemsWithoutRelatedRecords.push(catItemGR.getValue('name')); // Collecting item names
}
}
// Example output to log (or adapt to your needs)
gs.info(‘Catalog Items without related records: ’ + catItemsWithoutRelatedRecords.join(’, '));
Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning
Thanks & Regards
Deepak Sharma
