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

[DT]

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).

The alm_hardware table looks like this:

warranty_end_date variable:

model_of_pc variable:

damaged_pc variable:

If any questions, please let me know, thanks!

[Brian Lancaster]

I think it is because you are only basing it on one field. So It is going to pull all values that have the same warranty expiration date. Since it seems to be the same model you could try checking the box for unique value. 

[DT]

If you are referring to the "Unique values only" option on the variable form, I have tried it before, unfortunately without success.

[DT]

Tried this out: "javascript: 'warranty_expiration='+current.variables.damaged_pc.warranty_expiration"
but the result is still empty on the form.

[Brian Lancaster]

You may need to call a client callable script include and use GlideAjex to get the data you want and just set the value. 

[Saurav11]

Hello

Can you please elaborate 5th and 6th point really did not understand exactly what you are trying to achieve?