Filtering on characteristic values

[Former Member]

HI Guru’s,

Does anyone has a nice solution for the following problem:

Query with characteristic ABC. Characteristic ABC can have the following values: 10, 20, 30.....90 (so 9 values). My client has the following demands for the query:

• Only values 10, 20, 30, 40 en 50 are relevant for the query.

• Default value for the query are the values 10, 20 and 30.

• The user is allowed to make additional selections via navigation for the values 40 en 50.

• The user is <b>not allowed</b> to make additional selections for the values 60, 70, 80 en 90. Although these values do exist, they are not relevant for the query.

• Selection-screen is suppressed in the WebTemplate

Anyone has a nice solution for this?

Thnx in advance,

Henk.

[Former Member]

Hi Henk.

We are currently using version 3.5 and we control this within the query designer. Using the query designer you can restrict Characteristic ABC to exclude from selection, 60, 70, 80 and 90.

Does this work for you?

Regards,

Larry

[Former Member]

Larry,

The question is, how can we:

1. Filter the values 10, 20, 30, 40, 50 <b>and</b>

2. Give defeault for values 10, 20, 30 <b>and</b>

4. Exclude values 60, 70, 80, 90

<b>at the same time</b>.

Henk.

[Former Member]

Hi Henk,

I guess the below given solution may work out...

1. Filter the values 10, 20, 30, 40, 50 and

<b>sol: restrict the char to display only these values in query designer.</b>

2. Give defeault for values 10, 20, 30 and

<b>sol: create a char variable with "user entry/deafult value" and set default values to 10,20,30.</b>

4. Exclude values 60, 70, 80, 90

<b>sol: this will be taken care in first step itself ie, by restricting the char.</b>

hope this helps...

😆

NM