Searching
mNo edit summary
mNo edit summary
Line 16: Line 16:




<br />


<br />Search Expression<syntaxhighlight>
<br />Search Expression<syntaxhighlight>
Contract.allinstances->select(a|a.Name.sqllikecaseinsensitive(vSeekParam+'%') or a.Description.sqlLikeCaseInsensitive(vSeekParam +'%') or a.State.sqlLikeCaseInsensitive(vSeekParam+'%'))
Contract.allinstances->select(a|a.Name.sqllikecaseinsensitive(vSeekParam+'%') or a.Description.sqlLikeCaseInsensitive(vSeekParam +'%') or a.State.sqlLikeCaseInsensitive(vSeekParam+'%'))
</syntaxhighlight>
</syntaxhighlight>

Revision as of 06:23, 21 October 2024

This page was created by Stephanie@mdriven.net on 2024-04-05. Last edited by Edgar on 2025-01-20.

We created a Seeker that translates OCL to SQL for searching in databases of any size using OCLps. We look at derivations, constraints, and validation rules. We need OCLps to seek the database without instantiating the objects in memory in the prototyper.

selfVM.Search

Triggers search functionality using search expressions in your ViewModel and populates the vSeekerResult.

See also: [edit | edit source]

Create a ViewModel and rights click on it, select Add Nested ViewModel class and choose Add Search Expressions: 

Documentation Searching 1729490219452.png








Search Expression

Contract.allinstances->select(a|a.Name.sqllikecaseinsensitive(vSeekParam+'%') or a.Description.sqlLikeCaseInsensitive(vSeekParam +'%') or a.State.sqlLikeCaseInsensitive(vSeekParam+'%'))