Apr
12
Written by:
Michael Washington
4/12/2013 6:31 AM
The LightSwitch HTML Client allows you to easily create a server side search.
We start with a simple Browse screen.
First, we add a property.
We create a Search property.
The property will be added to the View Model on the Screen.
We now select Edit Query.
We create a query that takes a parameter.
We click on the parameter and in its Properties we make it Optional.
We bind the Search property to the SearchParameter.
The line shows that the Search property is bound to the SearchParameter.
We drag and drop the Search property to the Screen layout.
We switch the Search element to a Text Box.
When we run the application and enter a search term and hit the Enter key (or Tab or click away) a server side paged search is executed.
11 comment(s) so far...
is an option to use a grid in html client like we do in silverlight ?
any third party can html5 grid ?
the most important control is missinig...
By alon on
4/15/2013 8:25 AM
|
@alon - You would have to use a 3rd party control.
By Michael Washington on
4/15/2013 8:27 AM
|
I think that becuase grid control is the most missing for all lightswitch developers,
sample of third party grid (like wijmo, telerik, devexpress) with dynamic tabs. (like we do in silverlight) is all wish
when we can combine controls from Third party, we can Eventually say Goodbye to silverlight....
with great hope that microsoft will deliver more and more JS controls to lightswitch.
before 3 or 4 years, silverlight was the best - but now - all developers want html5 + JS.
Thanks for all !!!
By alon on
4/19/2013 6:45 AM
|
I encountered a small issue when adding a search to my app, and am hoping there's an answer. My data resides on an Oracle 10 db, so all of the queries are case sensitive. Is there any way to tell Lightswitch to add a lower() or upper() to the generated query as well as to convert the input text the same way?
Thanks,
Mike
By Michael Whitis on
8/1/2013 5:25 AM
|
@Michael Whitis - Sorry I have no code samples. You will want to post to the official LightSwitch Forums at: http://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=lightswitch
By Michael Washington on
8/1/2013 5:37 AM
|
Good post, the only thing is, after searching you delete all characters from the Search textbox and press Enter, no records are displayed (opposite of what's expected). I'm sure you fixed it already. (I'm using VS2013 HTML Client)
By Nicolas Lope de Barrios on
3/5/2014 10:14 AM
|
I forgot to mark the parameter as Optional in the query. My bad! sorry about that.
By Nicolas Lope de Barrios on
3/5/2014 10:19 AM
|
Is there a solution available for the issue of Michael Whitis? I am encountering the same problem.
By Rob Vaes on
11/24/2014 2:15 PM
|
@Rob Vaes - Sorry I have never encountered that problem because I don't use Oracle :( You will want to post to the official LightSwitch Forums at: http://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=lightswitch
By Michael Washington on
11/24/2014 3:15 PM
|
Thank you so much for this Michael. I am also working my way through your book as I am new to LS. I did note that after following this procedure the search button is rendered at the bottom of the page and clicking it produces a second search textbox. That i believe will be confusing to the users of the app I am writing(my first LS). Is there a way I can avoid this duplication?
By Doyle Johnson on
1/4/2015 8:15 PM
|
@Doyle Johnson - On the properties for the table (in the server project) you should be able to unselect the box "Is Searchable"
By Michael Washington on
1/4/2015 8:31 PM
|