use criteria based on two tables

levino
Giga Guru

Hello Experts

 

to restrict a catalog item where assigned_to on the cmdb_ci table is null

at the same time i need to restrict it based on certain conditions like a encoded query on the sys_user table e.g. emailENDSWITH@cpu.com

 

assigned_to  references the sys_user table

 

the catalo item is for user with no device assigned to them at the same time only certain set of users from the sys_user table should use the form

please provide sample of code 

 

Thanks

Levino

0 REPLIES 0