Select observations based on field variable

[#1]

Dear All,

I'm struggling with this simple script:

//a day select for listbox

Day_select:
LOAD * INLINE [
Day_number
1
3
4
5
6
7
];


//Example from a large database
Table1:
LOAD * INLINE [
Day, Description, ID
1, Shutdown,1
1, Maintenance,2
2,Shutdown,3
3,Shutdown,4
5,Maintenance,5
6,Maintenance,6
7,Maintenance,7
1,No order,8
];


//Select the day
Table2:
NoConcatenate LOAD *
Resident Table1 where Day = $(eDay_number);

Drop table Table1;

What I would like to do:

First: I have created Select your day Lost box.

After selecting a day, I press on the Reload button and the script will be reloaded.

Then I expect that the Table box contains observations with Day = 4.

I have defined eDay_number in the variable list that refers to name Day_number.

But I got an error...

Why do I use this construction?

The database is quite large and need to select a certain day number to prevent too much re-loading time.

Could you please advice?

Thank you and best regards,

Cornelis

[Aurelien_Martinez]

Hi,

I think you can use a input box with a list of all your day number like this qvw

Regards,

Aurélien

[kedar_dandekar]

Hi,

To filter data in the script you will need to use a variable.

The variable for the selected day-number selection can be set on using a Trigger (refer image below).

Refer attached QVW..

HTH

Kedar

[janardhan · Accepted solution]

Hi , Please find the below attachement.

Hope this will helpss!!!!

[#5]

That is a good starting point, you are right.

Thanks for it!

Best regards,

Cornelis

[#6]

Hello Janardhan,

Thank you for your reply, this is a to-the-point answer, it works.

When I have tried to reproduce your result, it does not work although the settings are exactly the same.

Does it depends on the Document properties, i.e. the aswer from KedarDan as described above?

Best regards,

Cornelis

[#7]

Hi Kedar,

Yes, that is very clear although not very easy to find.

The Trigger settings is key to make the event happen.

Using input box is not necessary because the list box provide the solution.

Thank you for your excellent answer, that is the best.

Regards,

Cornelis