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  |  

telerik -- supercharge your DNN websites
  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  User Defined Ta...  Filtering in AdvancedTable.xsl
Previous Previous
 
Next Next
New Post 6/8/2008 10:08 AM
Unresolved
User is offline Octopus
2 posts
10th Ranked


Filtering in AdvancedTable.xsl 

Hi

Is it possible to filter in AdvancedTable.xsl, example on a date column, so that it only shows new date's from now on.

 
New Post 6/8/2008 1:14 PM
User is offline Stefan Cullmann
1551 posts
5th Ranked








Re: Filtering in AdvancedTable.xsl 

The current version supports only filtering in XSLT, so this would require a change to advancedTable.xsl. Copy the file and open it in a editor, search for  line 184:

change

<xsl:variable name="filteredData" select="udt:Data[contains(*[name()=$searchColumns][1],$search) or contains(*[name()=$searchColumns][2],$search) or contains(*[name()=$searchColumns][3],$search) or contains(*[name()=$searchColumns][4],$search) or contains(*[name()=$searchColumns][5],$search)or contains(*[name()=$searchColumns][6],$search)or contains(*[name()=$searchColumns][7],$search)or contains(*[name()=$searchColumns][8],$search)or contains(*[name()=$searchColumns][9],$search)or contains(*[name()=$searchColumns][10],$search)]" />

to

 <xsl:variable name="filteredData" select="udt:Data[udt:DateColumn_UDT_Ticks &gt; /udt:UserDefinedTable/udt:Context/udt:TodayInTicks and  (contains(*[name()=$searchColumns][1],$search) or contains(*[name()=$searchColumns][2],$search) or contains(*[name()=$searchColumns][3],$search) or contains(*[name()=$searchColumns][4],$search) or contains(*[name()=$searchColumns][5],$search)or contains(*[name()=$searchColumns][6],$search)or contains(*[name()=$searchColumns][7],$search)or contains(*[name()=$searchColumns][8],$search)or contains(*[name()=$searchColumns][9],$search)or contains(*[name()=$searchColumns][10],$search))]" />

where DateColumn is the name of your date column.

If you don't need XSL, you can set a filter direct in ManageUDT: [DateColumn_UDT_Ticks]>[Ticks:Now] 

 


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
 
New Post 6/9/2008 7:04 AM
User is offline Octopus
2 posts
10th Ranked


Re: Filtering in AdvancedTable.xsl 

Great that works fin.

Is it possible to add +1 ore -1 to the [Ticks:Now] ore something like that?

 
New Post 6/9/2008 9:33 AM
User is offline Stefan Cullmann
1551 posts
5th Ranked








Re: Filtering in AdvancedTable.xsl 

Sure.For example:

Next week:  [Ticks:Now] + 7 * [Ticks:TicksPerDay]

Check documentation and online help links to hiden columns and available tokens.


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
 
New Post 8/8/2008 3:56 AM
User is offline Roman Müller
1 posts
10th Ranked


Re: Filtering in AdvancedTable.xsl 

Another question on filtering:

I have 3 additional bool attributes in my table, GER, SWI and AUT. The idea is that the author of the entry ticks one or more of those attributes for his data.

When now somebody enters this page with myDomain.de he should see the entry only when the GER checkbox has been ticked. Or if somebody else enters with mydomain.ch he should see only the entries that have been defined for SWI. (We have several domains, all pointing to the same server).

What I am looking for is how do you access the HTTP_HOST server variable in AdvancedTable.xsl.

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  User Defined Ta...  Filtering in AdvancedTable.xsl
 


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.

 


Sunset Hill Solutions - Consulting and Development
We offer general DNN consulting services - including custom module development and commercial module integration/setup.
www.sunsethill.ca
MaximumASP
MaximumASP provides a wide array of web hosting plans to fit any hosting need. We also provide software and services needed to keep it running optimally.
MaximumASP.com
Mad Development: dotnetnuke design and development
We are an expert Dotnetnuke shop specializing in developing solutions that merge the requirements of design and branding, content management, ecommerce, search engine optimization and business logic.
www.MadDevelopment.com

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