Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
QuickList.AndColumn
Returns a list with values which are contained in both lists.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| List | 10.0 | Yes | Yes | Yes | Yes | Yes |
MBS( "QuickList.AndColumn"; List1; List2; Separator; Column { ; ReturnNewList } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| List1 | The reference to the first quicklist. | $List1 | |
| List2 | The reference to the second quicklist. | $List2 | |
| Separator | The separator text. Can be multiple characters. For tab separated text, pass Char(9). For CSV separated text, pass ";" or ",". |
Char(9) | |
| Column | The index of the column to compare. Starts with 0 for first column. |
0 | |
| ReturnNewList | Pass 1 to return result as new QuickList. This new list must be freed later using QuickList.Free function. Pass 0 (Default) to modify the list in the List1 parameter. | 0 | Optional |
Result
Returns list, OK or error.
Description
Returns a list with values which are contained in both lists.Performs a logical AND operation.
Checks the given column in both lists too compare.
If Separator is empty, this is same as QuickList.And, but slower.
See also
- List.And
- QuickList.AddValue
- QuickList.And
- QuickList.Free
- QuickList.NotColumn
- QuickList.OrColumn
- QuickList.XOrColumn
Blog Entries
Release notes
- Version 10.0
- Added QuickList.AndColumn, QuickList.NotColumn, QuickList.OrColumn, and QuickList.XOrColumn functions.
Created 23th December 2019, last changed 23th December 2019
QuickList.And - QuickList.BestMatch
Feedback: Report problem or ask question.
Links
MBS FileMaker tutorial videos
