Questions

Hide SearchSort and Pager until results

Hello.. On the template searchsort and pager are shown all the time, not matter if there's results listed in the template or not. is there a way to hide these until a results are shown and cleared when a clear search is requested? Thanks..

0 votes

2 responses

2350 views

Jeff M. asked May 27, 2020 active May 27, 2020

Template SearchSort

Hello.. For the FilterExpression, if someone enters two words separated by a "space", I'd like to replace it with a wildcard. So if they enter "Joe Smith", the FilterExpression will end up being '%Joe%Smith%'. Is that possible? E.g.: FilterExpression="FirstName LIKE '%{0}%'" TO: FilterExpression="FirstName LIKE 'REPLACE(%{0}%), ' ', '%')'"

filterexpression Searchsort template

0 votes

0 responses

2310 views

Jeff M. asked Feb 18, 2020 active Feb 18, 2020

How can I use the <searchsort> to search for a range of dates?</searchsort>

I have a form that uses date input fields. I need to be able to filter applications where specific fields fall within a date range. The examples given for the <SearchSort> feature seem to provide a way for only one search input, however I don't see how to use this for two inputs so that the range can be searched. Is this possible?

Searchsort

0 votes

0 responses

1474 views

Lisa asked Mar 8, 2019 active Mar 8, 2019

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

Filter filterexpression search Searchsort select

0 votes

1 responses

2549 views

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

Searching for the right tree!

Hi Everyone, I created a little table and a form to input the data, but what I am trying to do is then have a search form and when a match is found, it returns the results. Now I think I might be barking up the wrong tree here, perhaps someone could advise: I used the following template, which displays all the results and then lets you search for a record, but I didn't want anything displayed, onl

Searchsort

0 votes

8 responses

2129 views

Trevor Guyton asked Apr 11, 2018 active Apr 16, 2018

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