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  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  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.

 


TMA Resources
TMA Resources is a software company providing eBusiness solutions for the Association market.
www.tmaresources.com
DotNetNuke Hosting Provider UK
UK leading DotNetNuke Hosting provider. Owned and operated by a Microsoft Gold Certified Partner.
www.DNN-Portals.co.uk
Alliance Systems & Programming Inc
Alliance is not just our name... it's how we do business. We partner with our clients, learning their business processes and standards and then applying our expertise to help them improve their workflow and profitability.
www.Alliancesys.com

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