Questions

Clear SearchSort FilterExpression

I am using the SearchSort functionality to find records in my table. If the user searches for something that doesn't exist I was hoping to use the "NoItemsTemplate" to show a simple message "No records found" and a CommandButton that would reset the select statement to my initial SELECT * FROM.... However, I can't seem to get the select statement to work. The command button works (I think) but the

0 votes

1 responses

2712 views

Bryan Lynn asked May 2, 2018 active May 3, 2018

filter data in template

I have the following that creates a url from the form in a module above the template module. The url appears correct in the address bar however it is not picked up in the template with the url parameter...can anyone see why its not working please? http://dnndev.com/fiddle/fid/646

Filter template

0 votes

1 responses

2120 views

Paul Buckley asked Apr 9, 2017 active Apr 9, 2017

Filter data in view based on a variable

I have a form on the top of a page and a view below that. The form has a dropdown list. I would like to filter the view based on the selection from the dropdown list. Is there a way to do this?

Filter variable View

0 votes

9 responses

2435 views

Brenda Etherton asked Aug 19, 2013 active Mar 30, 2017

How to use Custom Setting value as Column Name in SQL WHERE clause

Hi there, I'd like to reuse an xMod template by passing in a Custom Setting that contains the name of the SQL column I want to search for a value of "True". Where my setting is [[Module:DayName]] = adminDayMon I want to use the SQL statement in my template of ... WHERE [[Module:DayName]] = 'True' ... I have tried the above and no joy. Have also tried to create a parameter and then use the paramete

Custom Setting Filter parameter Where clause SQL

0 votes

7 responses

2660 views

bensch asked Oct 19, 2016 active Oct 19, 2016

Filter records by default

I have a SearchSort integrated with a template and have looked at all the parameters available, but I need the ability to filter records by default until the user enters their own search term. If I use a WHERE clause in my SELECT statement, it limits the recordset, which I can't have. I need all records available for the search, but when the page first loads, show only a certain subset by default.

Filter Searchsort

0 votes

4 responses

2134 views

Jen Sharp asked Mar 9, 2016 active Apr 22, 2016

Getting Good Answers

How do you get good answers to your questions? Ask good questions. That means:

Good Titles: Give your question a concise but informative title. Rather than "Email Forms", use "Sending multiple emails from forms".
Do Your Research: Check out the XMod Pro help file, the XMod Pro Guide on this site, do a search in this Answers forum. Members are friendly and more than happy to help, but it's good etiquette to show you've done your homework.
Is It Answerable? Your question should be practical and answerable. Provide clear and accurate details about your specific problem. Be sure to include all the pertinent information or links to images and examples.
Show Your Appreciation: If someone correctly answers your question, come back and ACCEPT the answer. That gives them points and helps others know it was a correct answer. If members know you'll accept an answer, they'll be more likely to spend time on your next question(s).