Lookup field in catalog is not working correctly.
in Service Catalog a service that contain a lookup field that search into the mdb for all the CI's that are from the X family.
This has a name of the X (resource_name) and use the "Select object" operator for SDM on PAM.
set the object "Asset" and the where clause = "resource_name ='"+ Process.SCATM + "' and inactive =0".
When trying to get this working the following error appear in the operator:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<faultstring>Error fetching: AHD03053:Bad where clause: Parse error at : "resource_name ='"+ Process.SCATM + "' and inactive =0" (Attr not found or not atomic)</faultstring><faultactor/><detail><ErrorMessage>Error fetching: AHD03053:Bad where clause: Parse error at : "resource_name ='XXXXX'" (Attr not found or not atomic)</ErrorMessage>