Intersoft Community - WebScheduler - Multiple Query

Multiple Query

frankgary — Thu, 23 Feb 2012 09:10:39 GMT

Hi Handy,

I was able to resolve my issue simply by disabling the editing feature, (had not considered that one, thanks for pointing it out!).

Thank you for all your help. Your forum support is truly top notch!

Frank

Multiple Query

handy@intersoftpt.com — Tue, 21 Feb 2012 01:17:10 GMT

Hello Frank,

Why don't you disable data editing from the first time? If not, you can also get the element of Callout and set display none for the button. To get the Callout element, simply use below code.

  function WebScheduler1_OnCallOutShow(controlId, action) {
            		    var WebScheduler1 = ISGetObject(controlId);
            		    var el = WebScheduler1.GetCallOutElement();
            		    if (el != null)
            		        if (el.style.display == "")
            		        //find until the button element and the display none
            		    return true;
        }

Regards,
Handy

Multiple Query

frankgary — Mon, 20 Feb 2012 21:04:15 GMT

Hi Handy,

I was able to get it working using your option #1 above. Thank you!

I do have one remaining issue in my configuration. When a user one clicks a color bar, I am trying to "hide" the "Edit Event" button on the fly out dialog. I am able to hide the entire Edit Event dialog completely through the "OnEventSelected" client side event.

However, I would like to show the Edit Event dialog so the user can see the details, but not allow them to click the Edit Event button. Can the Edit Event button be hidden somehow?

Attached is a screen shot. Is this possible?

Thanks - Frank

Multiple Query

handy@intersoftpt.com — Sun, 19 Feb 2012 22:02:41 GMT

Hello Frank,

After I discussed with our developers, I think there are two possible ways for you to do that.
1. Create a another table in your dataset. You can also fill the same datatable to the new table.
After that, everytime you Postback the option, you need to change the datamember property of the current events/resource/etc.
2. Or still use parameter. But you need to handle those queries in one StoreProcedure.

Regards,
Handy

Multiple Query

frankgary — Fri, 17 Feb 2012 06:54:06 GMT

Hi Handy,

Thank you for your prompt response.

You stated:

"use dropdown only as options to change the query
We have server side selecting event in ISDataSource. I think you can interrupt and change the query based on your dropdown value in this event"

This is EXACTLY what I have been trying to do with no success! In the events table adapter it does not appear that I can use compound queries as I get an error "The Declare SQL construct or statement is not supported" so it does not allow me to utilize two different queries or sub queries in the same single query.

I am able to use query 1 by itself and set the parameter on the ISDataSource Events table fine, and I am able to use query 2 by itself and set the parameter on the ISDataSource Events table fine, however I am NOT able to add a compound query for query 1 AND query 2 without getting the above error.

I also do not see a server side selecting event in the ISDATASOURCE anywhere, I have checked from top to bottom.

Can you adivise further?

Thanks! - Frank

Multiple Query

handy@intersoftpt.com — Thu, 16 Feb 2012 20:50:43 GMT

Hello Frank,

Using our dropdown is also the same as your current dropdown control. The problem is, dropdown is not the part of our WebScheduler control.
That's why I said you can use this dropdown as parameter.
Based on what you said, it seems your case is different from our previous customer.
In my humble opinion, use dropdown only as options to change the query.
We have server side selecting event in ISDataSource. I think you can interrupt and change the query based on your dropdown value in this event. Hope this helps.

Regards,
Handy

Multiple Query

frankgary — Thu, 16 Feb 2012 07:34:58 GMT

Hi Handy,

Thank you very much for your reply. I am using parameters in other areas of my webscheduler development project so I am very familiar with your suggested solution.

However, I am not certain parameters will work in my scenario since using parameters appears to be based on a SINGLE query. What I want to do is utilize TWO different queries.

How would I accomplish this if I were using an Intersoft dropdown list control? Is is even possible to invoke Events query 1 when user selects dropdown option 1 and invoke Events query 2 when user selects dropdown option 2?

There are basically TWO different select statements and I am not aware of any way to have two different select staements in the same sql query based on a parameter?

Thanks - Frank

Multiple Query

handy@intersoftpt.com — Thu, 16 Feb 2012 02:13:37 GMT

Hello Frank,

In my humble opinion, there is no event for that since dropdownlist itself is not our control.
I suggest you to use select parameter which you can change the value by using postback on dropdownlist itself. To know about how to select by using parameter, please kindly follow this current thread.

Regards,
Handy

Multiple Query

frankgary — Wed, 15 Feb 2012 11:56:38 GMT

Gentlemen,

I have added a dropdown list to my webscheduler named "Display Mode". There are only two options; Summary or Details. The option list can either be a named list or listed from a database. Currently I have the dropdown list bound to a database field.

In my Intersoft_DataSet I have added a second query to the events table. There are two queries total, one is the native Events data query, (Details), and my new query, (Summary).

My question is, how can I invoke the Events "Details" query when a user selects "Details" from my dropdown list, and how can I invoke the Events "Summary" query when a user selects "Summary" from my dropdown list?

I have tried every possible configuration but cant seem to get the Events queries to invoke depending on what the user selects from the "Display Mode" dropdown.

I have attached a screen shot image, please look at the "Display Mode" dropdown.

I simply want to change what data the Events table displays based on whether the user has selected "Detail" or "Summary" from the "Display Mode" dropdown.

Can you please help?

Thanks!!!!!