Functionality to retrieve information from a table by searching for details on the portal form.

[Preksha Kapoor]

Hi Folks,

We are looking for a solution that allows us to retrieve details related to a Software Model from the alm_license table. Example: when users provide the Software Model details in a form, they should receive all associated information from the alm_license table as the output.

Also do let us know can we achieve this using Service catalog or Record Producer.

Attached is the desired output

 Please note we do not have SAM.

[Ankur Bawiskar]

@Preksha Kapoor 

are you saying user will upload this document or image in record producer and information has to be fetched from it?

If yes then this is not feasible OOB.

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

[Preksha Kapoor]

Hi @Ankur Bawiskar 

The snip is just for your view, that is how we want the data to be visible to the end-user on the portal.

What we want is for the end user to fill the value in the Software model field with the model name and hit Search and it should give me information about that Model such as whom it is "Allocated To", "Serial number", "Allocated on"

[Ankur Bawiskar]

@Preksha Kapoor 

then why not use MRVS and have 4 variables within it

1) reference to alm_license

2) Allocated to - reference type to sys_user

3) Serial number - String type

4) Allocated on - Date type

when user selects the License record, you can have onChange catalog client script which applies to MRVS and that variable and auto populate the other 3 variables using GlideAjax

refer this link for help

How to auto populate project details in a multi row variable set 

If you want the output with same look and feel as above, then you will have to build a widget with HTML and then associate this widget with variable of type "Custom" in your record producer.

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

[Ankur Bawiskar]

@Preksha Kapoor 

Hope you are doing good.

Did my reply answer your question?

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