error in reference qual?

[Julius28]

Hi!

I'm updating Look up select box reference qual with parameter Operational status is not Retired but something is odd and not working. Can someone can spot mistake?

This is for first field:

javascript:'u_active=true^u_region=pb^u_service_id.operational_status!=4^EQ'

This is for second field:

javascript:'u_db_name='+current.variables.select_db+'^u_active=true^u_region=pb+'^u_service_id.operational_status!=4^EQ'

Thanks.

[Community Alums]

May be here:

javascript:'u_db_name=' + current.variables.select_db + '^u_active=true^u_region=pb +'  ^u_service_id.operational_status!=4^EQ'

[Julius28]

should i remove  +' ? because i already have it there.

[Community Alums]

yup

[Community Alums · Accepted solution]

Remove both " + " and " ' " (+') - its not correct as you are concatenating to pb the plus sign and you close your string query by adding single quote and not closing it correctly. What happens is that you pass to the DB query like "gimme me active to be true and region to be pb+" here you end your string query and add ^u_service_id...so on. The syntax is incorrect in general as you need to concatenate stringified queryes with + and then use either variables, javascript calls or just add extra stringified query (like "active=true" + "region=pb", but not "active=true+"^region=pd -> this is very wrong syntax.