Print only germany country in list collector variable

[Community Alums]

Hi, I want to print only germany country in legal entity variable.

Its showing all countries .

How can I achieve this?

[Brad Bowman]

You need to add this in the Reference qualifier - whatever makes sense on the referenced table, something like 

x_mkgaa_cmd_country=Germany

This is like an encoded query, so no quotes and use your field name and value. Remove the "=Germany" from the attribute as that is not doing anything.

[Community Alums]

its still showing all countries.field name is x_mkgaa_cmd_country .

[Brad Bowman]

Maybe the actual Column name is cmd_country if x_mkgaa is the application/scope? Is this a String field which has the value 'Germany'?  If it's a reference to the core_country table you'll need to use the sys_id or try

x_mkgaa_cmd_country.name=Germany