NeXTensio Forum :: How to pass URL param to filter Nextensio list

How can I pre-filter a Nextensio list by passing the parameter in the URL?

For example, a DB table contains a list of books and authors. Rather than simply let the user filter an entire Nextensio list, I need to create a link that limits the query. So, let's say the link is to display all books by the author Hemingway. I'm passing the 'authorName=Hemingway' value through this link.

I've tried adding the following to the SQL statement:
WHERE KTWhereDefParam AND authorName = getAuthor

Then I defined the variable getAuthor:
getAuthor
Default Value: ''
Run-time Value: $HTTP_GET_VARS['authorName']

This results in a SQL error so obviously my syntax is incorrect. Where am I going wrong?

Hello Jeff,

The first problem is that your extra condition added to your SQL should be:
WHERE KTWhereDefParam AND authorName = 'getAuthor'

A second problem is that the NeXTensio2 don't support to pass the search parameters through the GET and instead some SESSION varaible are used. If you want to filter your NeXTensio2 with a value you have to register that value into the SESSION into the $HTTP_SESSION_VARS['KTNL_fieldname_F'] I think. You may retrieve for each of the fields displayed in the List the equivalent filtering name into the session from the default value of the Filter input corresponding to that field. 

Regards,
Cristian MARIN

Actually, I did have 'getAuthor' in quotes; that was just a typo.

I'll try your suggestion about the session variables and let you know if it works for me. Can you confirm for me that the 'KTNL_fieldname_F' name is correct? Thanks.

Hello Jeff,

The KTNL_fieldname_F is just a mask like which the session variable should look like and I gived you for orientation in the code. The real variable is more complex for example:

$HTTP_SESSION_VARS['KTNL_article_art_F']['name_art']

where the 'article_art' is the name of the NeXTensio2 List which default is set to the name of the table in the database and 'name_art' is the name of the field which should contain the value you are looking for.

Regards,
Cristian MARIN

Thanks, I understood that. Your first reply made it seem as if you weren't sure of the "mask":

you have to register that value into the SESSION into the $HTTP_SESSION_VARS['KTNL_fieldname_F'] I think.

I will give it a try.

I don't understand this - is this for PHP?  How do you do it in VB_Script/ASP?

It seems a weakness of NextTensio that you cannot specify a default "start filter" condition.  Can this be added to the next version?  PLEASE, can you (or someone) tell me how do it with the existing version (a bit of sample code in VB_Script would be helpful.)  I want the start condition to be "areaID = 'Block3'" against table NewFAQ.

I know you are really busy, but prompt answers to tech support requests would be helpful.  At the moment it is taking several days.

Kind regards

Barry

Hello Barry,

Here is how to set a default start filter condition on a nextensio list. The following method works only if you have "areaID" as a field of the nextensio list.

Build your nextensio list page and then locate the method setListName in the new created page. This should be at the top of the page, and the line of code should look something like this:

call KTNL_[table_list].setListName("KTNL_[table_list]")

[table_list] is actually a string that depends on the table you used to build your nextensio list and the name you gave for your list. So, if your table is Employee and your list name is mylist =>[table_list] = Employeemylist

Add after the above line the following lines of code:

If isEmpty(Session("KTNL_[table_list]_F")) Then
   Session("KTNL_[table_list]_F") = Array( Array("areaID", "Block3"), Array("","") )
End If

Don't forget to replace [table_list] with your actual string

KTNL_[table_list]_F must be the parameter given to the setListName method + "_F"

Hope this helps you,

Regards,

Dragos Georgita

How is this achieved with the most recent version of NeXTensio?

I found http://www.interaktonline.com/Documentation/MXKollection/097000_shownxttfidef.htm  which mentioned adding the quertystring list.asp?show_filter_tfi_listname1=1 where listname1 is the list name and list.asp is your file name. This actually works but only in enabling the filter to be on by default. The info in there about adding a paramerter to the .addColum method of the filter class does not work.

I'm trying to have a list of links on a dashboard which are essentially frequently used searches and I want those to prefill/execute the filter on the list (Nextensio list) page. the links would look like list.asp?show_filter_tfi_listname1=1&Colum1=Value&Colum2=Value.

How is this achieved?

I can't believe I'd have to develop and maintain a new page for each frequently used search term. That's the difference between 2 pages and 50 pages!