Questions

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

0 votes

7 responses

2742 views

bensch asked Oct 19, 2016 active Oct 19, 2016

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

2487 views

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

CommandButton and Foms

I need to have dropdowns, textboxes, radio buttons and other fields to create an advanced filter form. How do I hook these fields with CommandButton to fire the seach and load data into templates of my page? Thanks!

commandbutton Filter forms

0 votes

5 responses

1365 views

Rosil Belli asked Oct 9, 2014 active Oct 27, 2014

How to 'refine' a template list with search criteria

Answer Accepted

I have researched this and still can't find out the best 'XMOD' supported way to do this. Most sites I am guessing would have a listTemplate showing a product but of course most websites allow you to refine your product/database record search depending on the category (maybe a dropdown) or by name (a search box) or other filter criteria. I have found this page - http://dnndev.com/Products/XModPro/

Filter search xmp

0 votes

7 responses

800 views

Darren asked Jul 9, 2013 active Jul 9, 2013

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

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