Remove option from Lookup selectbox based on other field

[MercBuilding]

Hi,

  iam trying to populate lookup select box values based on other field but when i keep javascript function in refrence qualifier function , it is returning all the values but in the logs i can see number of records as 4 only. Does calling script include/ function doesnt't work in look up select box type variable?

This is the variable where iam calling the script include and function.

This is the script include function which i have written, i need to return the records for which end of life date is past, but iam unable to populate the records only first so i didnt try achieving what i need. Can somebody tell me where iam going wrong.

Thanks!!

[AnveshKumar M]

Hi @MercBuilding 

Can you please share what you are returning from script include? 

Are you returning the query with sys_ids or just the sys_ids.

[MercBuilding]

Hi @AnveshKumar M ,

   iam trying to return the record with sysid's for now.

[AnveshKumar M · Accepted solution]

@MercBuilding 

You should be returning the formulated query like this below.

return 'sys_idIN' + items.join(',');

If yes, it should work.

[MercBuilding]

Thank you so much @AnveshKumar M  for quick turn back. Its really helpful for me.