CA Service Management

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!

Hi erp.agilis,

I think you need use this:

<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'" factory="svc_contract">

But it only works after affected resource is saved.

Regards,

Carlos

Hi Carlos_Labarta,

This example is what I've done. Searches for a "Contract" filtering through a "Configuration item".
And it works like you said, after saving the ticket.

Now I need to search a "Configuration item" filtering through a "Contract".

Hi Rodrigo - do you still need assistance on this one?

Carlos_Labarta - can you provide any insight regarding Rodrigo's question about searching a Configuration item filtering by contract?

Hi Jon_Israel!

Yes, I still need to search a "Configuration item" filtering through a "Contract".

Rodrigo, Can you give the schema details of z_srl_ContratoServico?

And in what htmpl page you wanted to do this ADDITIONAL_WHERE?

Thanks _Chi

z_srl_ContratoServico SREL -> svc_contract.id UI_INFO "+AUDITLOG()"

detail_cr.htmpl

I don't think you can do ADDITIONAL_WHERE like this for the BREL attribute:

my_nr_maps           BREL <- sdsc_map.map_contract {map_contract = ?}

for the svc_contract object. It would involve way more to accomplish what you wanted here. You may want to take a

look at

How to create custom BREL/QREL/LREL attribute 

Chi_Chen,

The suggestion may even solve my need, but it is a very big change to make in the system. I expected to be some missing instruction in ADDITIONAL_WHERE.

Rodrigo, with BREL relation, there will be a lot of limitation using ADDITIONAL_WHERE. Thanks _Chi