Intersoft Community - WebScheduler - can filter resource, category and event?

can filter resource, category and event?

handy@intersoftpt.com — Tue, 14 Dec 2010 21:39:10 GMT

Hello Naaz,

Ok, Thank you for the confirmation. I could not mark this as the aswer because this a discussion thread.

Regards,
Handy

can filter resource, category and event?

naaz — Tue, 14 Dec 2010 06:22:20 GMT

yeah great. could you please mark it as an answer..This is exactly what i need.

Many Thanks,
Naaz

can filter resource, category and event?

naaz — Tue, 14 Dec 2010 04:43:50 GMT

Hello Handy,

Can you please send me this application with framework 2.0 support. I have vs2008 and i am using FW 2

Many thanks and waiting

Naaz

can filter resource, category and event?

handy@intersoftpt.com — Tue, 14 Dec 2010 03:25:44 GMT

Hello Naaz,

It is not possible to do that directly. As you can see in previous project, in my dataset for table Resources, you can see what query I used.
The problem is you could not dynamically change its parameter.

e.g
My custom select method is:

SELECT        ID, ResourceName, Description, Location, ResourceColor
FROM            Resources
WHERE        (ID = ?) OR (ID = ?)

My suggestion is, provide some parameters to be called in your query.
e.g

SELECT        ID, ResourceName, Description, Location, ResourceColor
FROM            Resources
WHERE        (ID = ?) OR (ID = ?) OR (ID = ?) OR(ID = ?) OR(ID = ?) OR(ID = ?) OR(ID = ?)

Then, validate in your login information. If user has 3 parameters such as 1,2 and 3, You will need to substring "," and split each values. After that, add each values into the parameter.

e.g
in ISDataSourceSelecting serverside event, define

 e.InputParameters[0] = 1;
 e.InputParameters[1] = 2;
 e.InputParameters[2] = 3;

It will run the query like this:

SELECT        ID, ResourceName, Description, Location, ResourceColor
FROM            Resources
WHERE        (ID = 1) OR (ID = 2) OR (ID = ?) OR(ID = 3) OR(ID = null) OR(ID = null) OR(ID = null)

Regards,
Handy

can filter resource, category and event?

naaz — Mon, 13 Dec 2010 06:39:52 GMT

Dear Handy,

Thank you so much for the great response. Is this application if the Parameter is in difference in number.

I have two managers. One manager is having 4 employees working under him and one manager is having 3 employees working under him and each and everyone want to see the schedule of his employees. It can be implemented at run time. i mean can i pass the paramater at runtime. The query which i was trying is something like that

SELECT ID, ResourceName, Description, Location, ResourceColor
FROM Resources
WHERE (ID IN (?))

If i pass one parameter it works file but i can't pass more then one parameter in it. Could you please advise what is the best approach to achieve what i am looking. I have a login. As far as the person logon i am getting a string of resource working under him like 2,3,5,7 or 1,4,6 etc...

Please guide me how to pass the query at runtime..

Many Thanks,
Naaz

can filter resource, category and event?

handy@intersoftpt.com — Mon, 13 Dec 2010 05:36:23 GMT

Hello Naaz,

It does not matter. You only configure your query to select more than one parameter in your select Resources. Then, add parameters that you would like to use. Please see my attached sample, I assign two sessions as the parameter.

Regards,
Handy

can filter resource, category and event?

naaz — Sat, 11 Dec 2010 10:22:18 GMT

Hello Handy,

Thanks for the great help. This is exactly what i am looking for but i want to display more then one resources, if i change the session parameter to obtain the group of ids, means my manager want to see all his employees schedule. this is very important for me. please guide

Many Thanks,
Naaz

can filter resource, category and event?

handy@intersoftpt.com — Thu, 21 Jan 2010 05:20:51 GMT

Hello,

You will need to select by using parameter in your query. The parameter should be specific "Resources". Here is my attached sample. I am using parameter session to show you that the resources would select only the parameter i set. Hope this helps.

Regards,
Handy

can filter resource, category and event?

aloisius — Wed, 20 Jan 2010 04:38:53 GMT

i need customize web schedule for department, user only see event, resource and category for her department. ex: user form marketing department only see event on marketing department, select resource and select category form marketing department.