Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListFiltering in AdvancedTable.xslFiltering in AdvancedTable.xsl
Previous
 
Next
New Post
6/8/2008 12:08 PM
 

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 3:14 PM
 

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] 

 

 
New Post
6/9/2008 9:04 AM
 

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 11:33 AM
 

Sure.For example:

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

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

 
New Post
8/8/2008 5:56 AM
 

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
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListFiltering in AdvancedTable.xslFiltering in AdvancedTable.xsl


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, 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 DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out