Asset Catalog Item form reference field query

[Shekhar Deshin1]

@Ankur Bawiskar 

We have following requirement :

If serial number on (alm_asset) is found data will be updated on existing record OR if not found asset will be created on alm_hardware table.

User wants MRVS to select the multiple records at a time and wants to update or Create.

Only i am facing issue with initial logic defined below.

With this logic on the form we have some fields that needs to be updated OR created on the target table.

Search for Asset by Serial Number:	Match alm_asset fields
	*If Asset is not found open pop-up with below fields for input
Model *	Reference: cmdb_hardware_product_model for selection
Serial number *	Text Box
Asset tag	Text Box

Please suggest thanks.

Thanks,

Shekhar,

[Ankur Bawiskar]

@Shekhar Deshin1 

You can use this approach

1) get the MRVS

2) parse and iterate

3) get each row and then query target table to check if serial number present or not and accordingly create/update

where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.