I wish to perform a query on an existing data reload

[#1]

what I have is a simple select:

select s_name,m_name,date_stamp,time_stamp,site from restart;

what I wish to do is allow a user to select a date from a Qlickview form listbox and push a button that grabs the date she selected and stick into a variable called "search_date"  (for example) and then perform the query:

select s_name,m_name, count(*) as total_machine_count from ????? where date_stamp= search_date group by s_name,m_name;

The short version is how do I operate on existing data as a result of a reload.  I just cant keep doing reloads after the user has selected a new date to be searched against.

thanks a bunch

Marshall Rowe

[#2]

Hi Marshall,

Why dont you try something like this instead? This should be done in the script:

"MAIN":

Load SName,

        MName,

          1 as "Total Machine",

          Date_Stamp

;

SQL Select

          s_Name AS "SName,

          , M_NAME AS "MName

FROM YOUR TABLE NAME

;

The above should bring in all of the data instead of just the selected date range, thus eliminating the need to reload after each user selection.

Then on the Front end create a a list box with the "Date_Stamp" dimension.Also create a Straight table with SName and MName as Dimensions and SUM("Total Machine") as an expression.

This should then show the information by the date selected.

Hope this helps.

Regards GJ.

[#3]

Cool!!!

I will give it a try

Thanks

Marshall

Orbitz

[#4]

Great, Let me know if it works?

Regards GJ.

[#5 · Accepted solution]

Hey GJ

Thaks foir the solution!  It worked GREAT!!!

thanks again

marshall

Orbitz

[#6]

Hey Marshall,

That is great news, glad that it solved your problem.

Regards

GJ.