free form not working in prompt

building semantic layer
1

I have the following prompt and everything works correctly except the free form. I can free form the exact name that matches what I see in the slection list but it returns null. Any clue? Here’s the prompt:

abst_coder_STAFF.STAFF_NAME IN @Prompt(‘Coder Name or ALL’,‘A’,‘Abstract\Coder Name’,Multi,free,persistent,{‘ALL’}) OR ‘ALL’ IN @Prompt(‘Coder Name or ALL’,‘A’,‘Abstract\Coder Name’,Multi,free,persistent,{‘ALL’})

Thanks!

rdurbin9 (BOB member since 2008-04-03)

2

Hi,

Just a thought:
Is the problem not caused by trailing NULLs in the Coder Name object?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

I thought the same at first but their is no evidence of any trailing nulls or spaces. Selecting from the list works and so does ALL, just not the free form. Thanks!

rdurbin9 (BOB member since 2008-04-03)

4

Marek,
I stand corrected! I thought I had checked it before but I must not have. There is a trailing space! Thank you very much!

rdurbin9 (BOB member since 2008-04-03)

5

Hi,

You can use TRIM() function in the definition of the Coder Name object to get rid of the trailing spaces. Something like:

TRIM(abst_coder_STAFF.STAFF_NAME)

Marek Chladny :slovakia: (BOB member since 2003-11-27)