Whenever I try and reference a where clause key flexfield it inserts null into my sql script

User_3JONA

Hello,

Version: Oracle Analytics Public 12.2.6.4.0

I have a simple query that like the following:

SELECT TOWN, STRNUM, STRNAME FROM CUST.ADDRESS
WHERE STRNUM > 100

I also have a menu parameter filled with all the distinct towns in the table called TOWN_SELECT. I am trying to give the user the option to select a town using the select and pass the value to a key flexfield with a where lexical type named TOWN_WHERE. But when I alter the select statement by adding it to the sql in the style of the documentation, it fails. It looks like it just enters a null into the query. Here is the example of the sql query after I add the TOWN_WHERE flexfield:

SELECT TOWN, STRNUM, STRNAME FROM CUST.ADDRESS
WHERE STRNUM > 100
&TOWN_WHERE

Here is what is generated when I look at the engine log for the failure:

SELECT TOWN, STRNUM, STRNAME FROM CUST.ADDRESS WHERE STRNUM > 100 null

Here is how the flexfield is currently set up:
*Lexical Name: TOWN_WHERE
Flexfield Type: Key Flexfield
Lexical Type: Where
Application Short Name:
Flexfield Code:

Code Combination Table Alias: CUST
Structure Instance Number: TOWN (I have also used a 1)
Segments:
Operator: =
Operand1: :TOWN_SELECT
Operand2:
Metadata Type: Above Prompt of Segments

How do I make this work? Troubleshooting I have already done:
1. Extensive google searching as well as following one of Oracles own tutorials
2. Read the documentation multiple times
3. Talked to the duck (taken a break to discuss the issue with coworkers and come back to it at a later time with fresh eyes)
4. Toggled between 1 and TOWN for structure instance number
5. Built the query myself from just a sql statement and built it using only the query builder
6. Used generic application shortnames such as APPL and SQLGL

What am I doing wrong?