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  |  

AspDotNetStoreFront
  Ads  
Webhost4Life - $4.95 Windows Hosting
 


  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...  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.

 


Alki Homes - Seattle, WA
Exemplary service for your Seattle Real Estate needs. It's what you deserve from your Realtor®!
www.alkihomes.com
PointClick DotNetNuke Solutions
PointClick Technologies provides high-end DNN Hosting for businesses.
PointClick.Net Hosted Solutions
Active Modules, Inc.
Creators of Active Forums, the best forum module for DotNetNuke
www.activemodules.com

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