Reference Qualifier issue on Catalog Item - multiple choice values instead of just one

DT
Kilo Contributor

Hi, I have a problem with my reference qualifier. Hope someone could give me a hint on point 5 and 6.

I've got an asset replacement form with some fields. The idea is to:
1. Choose an user (done).

2. Choose the project name assigned to this particular user (done).

3. Choose the opened incident number, where the user is the caller (done).

4. Choose the affected asset which is assigned to the above chosen user (done).

5. Auto populate the field with the model name of the above chosen asset (instead of one model name, I get a list to choose from - this is wrong, I should get the model name of the asset).

6. Auto populate the warranty expiration of the above chosen asset (instead of one date I get a list of multiple dates and I should get only the date of the asset).

find_real_file.png

The alm_hardware table looks like this:

find_real_file.png

warranty_end_date variable:

find_real_file.png

model_of_pc variable:

find_real_file.png

damaged_pc variable:

find_real_file.png

If any questions, please let me know, thanks!

1 ACCEPTED SOLUTION

For warranry field please use the below:-

javascript:'display_name='+current.varibales.damaged_pc;

For model fields as well use:-

javascript:'display_name='+current.varibales.damaged_pc;

And make the checkbox Unique values only to true

Please mark answer correct/helpful based on impact.

View solution in original post

13 REPLIES 13

DT
Kilo Contributor

Hi, sure, the point is, this should be a form for the manager to report an user's broken asset.
So after choosing the asset (display name of the asset), the field for model and warranty end date, should auto populate with the values of the chosen asset.
Example:

choosing "Dell XYZ" ---> makes the model field auto populate with "Dell Inc Latitude 123 Series"

and the warranty field should auto populate with the end date warranty of the "Dell XYZ".

 

Now it is not the case, as it shows me a dropdown list with more than 10 model names and a list of different warranty dates.
 

find_real_file.png

find_real_file.png

What is assed? Reference field?lookuo field what is it returning sysid or string?

DT
Kilo Contributor

find_real_file.png

find_real_file.png

For warranry field please use the below:-

javascript:'display_name='+current.varibales.damaged_pc;

For model fields as well use:-

javascript:'display_name='+current.varibales.damaged_pc;

And make the checkbox Unique values only to true

Please mark answer correct/helpful based on impact.