iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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.
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
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.
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 thatSELECT ID, ResourceName, Description, Location, ResourceColorFROM ResourcesWHERE (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
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)
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
Ok, Thank you for the confirmation. I could not mark this as the aswer because this a discussion thread.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname