(function openLouie() { let louie = document.getElementById("Dropdown-Toggle-14"); louie.classList = "host-toggle w-dropdown-toggle w--open"; console.log(louie); })();
List Search

You can search through the data on a list screen. You can use this feature directly by activating the screens you will create with CRUD Screen.

However, for detailed searches, you should add the Search function to the relevant custom action with the SQL editor.

select * from TodoItem  WHERE  (Description LIKE '%' + @searchFor +'%' OR Title LIKE '%'+@searchFor+'%'   OR @searchFor is null OR @searchFor = '')

  ORDER BY Description OFFSET (@currentpage-1)*@pagesize ROWS FETCH NEXT @pagesize ROWS ONLY

We have enabled search in the title and description fields. This query can be searched even if just a part of the word is written related to the % sign.

Simplicity Meets High Performance

Free edition subscription
Keep your work
No credit card required to try