AnsweredAssumed Answered

Use ADDITIONAL_WHERE for search "Configuration Item" by "Service Contract"

Question asked by erp.agilis on Nov 10, 2017
Latest reply on Dec 20, 2017 by Chi_Chen

Hello everyone!

 

I need to create an "ADDITIONAL_WHERE" that in the search of an "Configuration Item" field filters through the "Service Contract ID" that I will inform.

 

I did this "ADDITIONAL_WHERE", but filtering the inverse, from a field "Service Contract" filtered by the "Configuration Item ID", as below:
<PDM_MACRO name=dtlLookup hdr="Contrato de serviço" attr="z_srl_ContratoServico" extraURL="ADDITIONAL_WHERE=my_nr_maps.map_persid='$args.affected_resource.persistent_id'">
It generates the following filter in the field "Additional search arguments" in the search for "Service contract":
my_nr_maps.map_persid='nr:358CCFAF5362CF4DA9B7A6BF15FA137F'

 

My difficulty is because I have not found the field that corresponds to the list of "Service Contracts" (svc_contract) in the "Configuration Item" (nr).
In what I did, the field is "my_nr_maps".

 

 

Thanks a lot!

Outcomes