I have a DD project including some custom pages like an entry page displaying different "statistics". One of this informations shows the number of users who are not assigned to a specific project. Due to my model, this are all users who have not set a Project
ID (Foreign Key to Project Table).
I want to build a hyperlink that forwards to the List.aspx Page of the Users, only showing all not assigned Users. The link to show all Users assigned to a specific Project would be:
http://somewebsite/Users/List.aspx?Project.ID=123
But how to filter on Users who are not yet assigned to a project, like:
christoph_D
Member
4 Points
6 Posts
Filtering NULL Values by URL
Aug 08, 2011 08:08 AM|LINK
Hello,
I have a DD project including some custom pages like an entry page displaying different "statistics". One of this informations shows the number of users who are not assigned to a specific project. Due to my model, this are all users who have not set a Project ID (Foreign Key to Project Table).
I want to build a hyperlink that forwards to the List.aspx Page of the Users, only showing all not assigned Users. The link to show all Users assigned to a specific Project would be:
http://somewebsite/Users/List.aspx?Project.ID=123
But how to filter on Users who are not yet assigned to a project, like:
http://somewebsite/Users/List.aspx?Project.ID=[null]
<div></div> <div>Regards,</div> <div>Christoph </div>