Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListVacation/Absence Request formVacation/Absence Request form
Previous
 
Next
New Post
11/21/2008 3:59 PM
 

I am going to use UDT to create Vacation/Absence Request form for our organization in our intranet. Our DNN uses AD (EazyAD) module that retrieves all the Units, Groups and Individuals information. Users are automatically logged in when they open the intranet.

 
My design plan is:
  1. User:
    There is a page called Vacation/Absence Request under My Account menu. The page has UDT Module and Reports Module.
    • UDT Module: User can ONLY CREATE a request.
    • Reports Module: Lists all the Vacation/Absence Requests of this user
  2. Supervisor:
    Unit leader can only see the Unit staffs’ requests. (I don’t know how? Can I use filter? If yes, how?). Unit leader flags “approval”.
  3. HR:
    HR checks the requests and only proceed with approved ones and marked “processed”.
 
Thus far, a request is completed. Reports can been created to show for users, unit leaders and HR:
  • User:
    • User can see a list of all vacation/absence taken of his/her own.
    • Staffs of the same unit can see the vacation/absence schedule
  • Unit leader: manager can see all the unit staffs’  vacation/absence status
  • HR: HR can see all staffs vacation/absence status
 
Questions:
  1. Is it possible that I can use filter to allow the unit leader only to see his/her staff request? And he/she can only flag “approval” to his/her staffs.
 
Many thanks in advance
 
New Post
11/21/2008 5:28 PM
 

uccan wrote

 
Questions:
  1. Is it possible that I can use filter to allow the unit leader only to see his/her staff request? And he/she can only flag “approval” to his/her staffs.

Staff is a profile value? So you can filter [NameOfTheStaffColumn] = '[Profile:Staff]'.

A unit leader will be able to edit all fields, not only the approval flag. He can edit ANY entry of any staff if he guesses its id.

I can't recommend you to use UDT for this type of application.

 

 
New Post
11/24/2008 2:23 PM
 

Stefan Cullmann wrote

Staff is a profile value? So you can filter [NameOfTheStaffColumn] = '[Profile:Staff]'.  

Thanks Atefan for you reply.

I have another question. Does the filter support CASE WEHN....ELSE...END statement? It seems not. If so, what condition statement I can use? In my case, I can use the filter you recommended for Unit Manager to see the staff in a unit, but the filter will affect HR as well. The HR should see the whole list. Is any solution for that?

Thanks agan.

 
New Post
11/26/2008 5:11 AM
 

although it looks like, the Filter does not support SQL, you may enter expressions valid for ado.net datasets, please refer to msdn.microsoft.com for a detailed syntax description.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/27/2008 2:58 PM
 
Sebastian Leupold wrote

although it looks like, the Filter does not support SQL, you may enter expressions valid for ado.net datasets, please refer to msdn.microsoft.com for a detailed syntax description.

Thanks Sebastian very much! I’ve figured out that the CONDITINAL filter string I need for my case is:
 
iif('[Profile:Office]'='HR',1=1,Unit='[Profile:Office]')

 

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListVacation/Absence Request formVacation/Absence Request form


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out