Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AppTheory specializes in solutions based on the DotNetNuke platform and has 2 employees on the DotNetNuke Core Team.
  Ads  
Biz Modules provides professional business modules and solutions for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

OnyakTech
The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  User Defined Ta...  Unsupported Filter Statement for UDT filter: [Created by] = [User:DisplayName]
Previous Previous
 
Next Next
New Post 2/26/2008 11:22 AM
Unresolved
User is offline Larry Daniele
19 posts
10th Ranked


Unsupported Filter Statement for UDT filter: [Created by] = [User:DisplayName] 

Does anyone know how to set up a UDT filter statement to only show records for the logged in user? Currently when I use:

[Created by] = [User:DisplayName]

I get the message:

Unsupported Filter Statement

 
New Post 2/26/2008 2:43 PM
User is offline Sebastian Leupold
15045 posts
www.deutschnetnuke.de
1st Ranked












Re: Unsupported Filter Statement for UDT filter: [Created by] = [User:DisplayName] 

try either [CreatedBy] = [User:DisplayName]

or [Created by_UDT_Original] = [User:Username]


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 3/26/2008 5:42 PM
User is offline Henrik Larsen
9 posts
10th Ranked


Re: Unsupported Filter Statement for UDT filter: [Created by] = [User:DisplayName] 

Hi,

Just wanted to add that the name of a column in a filter is the displayed name of the column. Ex. if you have changed the Title into another language, you should use that new title in the filter expression. Here in Danish.

[Oprettet af] = '[User:DisplayName]'

Also you need the quotes on the [User:DisplayName] because its a text field.

 

 
New Post 3/27/2008 2:20 AM
User is offline Henrik Larsen
9 posts
10th Ranked


Re: Unsupported Filter Statement for UDT filter: [Created by] = [User:DisplayName] 

 Henrik Larsen wrote

Hi,

Just wanted to add that the name of a column in a filter is the displayed name of the column. Ex. if you have changed the Title into another language, you should use that new title in the filter expression. Here in Danish.

[Oprettet af] = '[User:DisplayName]'

Also you need the quotes on the [User:DisplayName] because its a text field.

BTW, This is not such a good idea really - is it ?  What will happen in a multilanguage environment then ?

 
New Post 3/27/2008 8:15 AM
User is offline Stefan Cullmann
1551 posts
5th Ranked








Re: Unsupported Filter Statement for UDT filter: [Created by] = [User:DisplayName] 

 Henrik Larsen wrote

 Henrik Larsen wrote

 

Hi,

Just wanted to add that the name of a column in a filter is the displayed name of the column. Ex. if you have changed the Title into another language, you should use that new title in the filter expression. Here in Danish.

[Oprettet af] = '[User:DisplayName]'

Also you need the quotes on the [User:DisplayName] because its a text field.

BTW, This is not such a good idea really - is it ?  What will happen in a multilanguage environment then ?

I think it is a good idea as UDT does not multi language. You always declare both field column titles and the content inside in one single language.


Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com
form and List will be the successor of the User Defined Table module.
----------------------------------------------------------------------
Do you want to import external data to form and List /User Defined Table?
Check out http://www.codeplex.com/Csv2UDTImport
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  User Defined Ta...  Unsupported Filter Statement for UDT filter: [Created by] = [User:DisplayName]
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Gearworx Web Hosting
As a premier provider of Web Hosting, Private/White Label hosting, Server Colocation, Dedicated Server, and other Managed Services, Gearworx offers an array of services designed to more effectively manage strategies driving businesses on the Web. Headquartered in Fremont, California our state of the art tier one data centers and distributed managed services environment enables Gearworx to offer your business enterprise level solutions through simplified processes.
Gearworx Web Hosting
Glanton: Enterprise Intranet Specialists Using DNN
Glanton Solutions are a premier provider of sevices for large corporates lloking to outsource Intranet sites.
www.glanton.com
Jetkey Smart Map
Smart Map is an AJAX powered Google Map module that displays driving directions, proximity search results and data from your own databases. Smart Map reads GPX (GPS data) files, GeoRSS feeds, and KML data. You can pass any querystring parameter to Smart Map and into your own custom queries to control what data displays on the map.
smartmap.jetkey.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP