Mobile Search Bar not working in My App

I have a DataBase like MovieData.

In that i need to search movies name in a Movies screen.

I added a Input Widget to that screen.

--> after created a Local variable like : SearchInput

--> assign the that local variable to InputWidget

--> after, going to Data --> Click on Movies --> View data

--> In that click on Filters

--> assign like:- Movie.Title like "%" + SearchInput + "%"

Qus: Getting Error like.

Can't identify 'SearchInput' element in expression.


Please find attachment also

Hello,

I have a DataBase like MovieData.

In that i need to search movies name in a Movies screen.

I added a Input Widget to that screen.  fine

--> after created a Local variable like : SearchInput  fine

--> assign the that local variable to InputWidget   fine

what you do next is going to the data itself, and when you say 'View data' you are taking a look at what data is currenty available in the database on the server you are developing on.  This is completely unrelated to the screen you were previously working on, and that explains why you can't use screen variables when you filter here.  You can use filter here only as a way to change the look on the data you have as a developer, no filter or sort settings here will affect any screens of your application.

--> after, going to Data --> Click on Movies --> View data

--> In that click on Filters

--> assign like:- Movie.Title like "%" + SearchInput + "%"

Qus: Getting Error like.

Can't identify 'SearchInput' element in expression.


Please find attachment also

So, looking at your question, I think you would benefit greatly from  the online training for mobile development  , the part dealing specifically with fetching and filtering data for a screen would be this video and this exercise


Good luck,

Dorine

Solution

Hi Prince,

To give you explanation on how SQL queries works in OutSystems. 

  • To reference an entity in your SQL query write it between  { curly brackets (e.g. {CITIES}), and
  • To reference an entity attribute write it between  [ square brackets (e.g. [City_Id]), and
  • To reference an input parameter in your SQL statement use a @ prefix, e.g. @CityId.

So, being a local parameter, add @ prefix.

Regards,

Swatantra

Solution

Swatantra Kumar wrote:

Hi Prince,

To give you explanation on how SQL queries works in OutSystems. 

  • To reference an entity in your SQL query write it between  { curly brackets (e.g. {CITIES}), and
  • To reference an entity attribute write it between  [ square brackets (e.g. [City_Id]), and
  • To reference an input parameter in your SQL statement use a @ prefix, e.g. @CityId.


So, being a local parameter, add @ prefix.

Regards,

Swatantra


Thankq all for supporting to me.

Now my search-bar working fine. 

Thanks & regards,

Prince


Prince Raj wrote:

Swatantra Kumar wrote:

Hi Prince,

To give you explanation on how SQL queries works in OutSystems. 

  • To reference an entity in your SQL query write it between  { curly brackets (e.g. {CITIES}), and
  • To reference an entity attribute write it between  [ square brackets (e.g. [City_Id]), and
  • To reference an input parameter in your SQL statement use a @ prefix, e.g. @CityId.


So, being a local parameter, add @ prefix.

Regards,

Swatantra


Thankq all for supporting to me.

Now my search-bar working fine. 

Thanks & regards,

Prince



Glad, it worked.