Dec 22, 2015; 10:54
Jeremy Reynolds
Searching FileMaker using Array
I've collected up an array of Record IDs from a FileMaker database (called
$Record_id_Array) and want to turn around and search the IDs in the same
FileMaker data source.
However, I'm having a very hard time getting it to search successfully.
Does a lasso inline on a search want an array? Or does it want a string?
If I take the value stored in the $id_search variable and hard code it
inside the inline such as:
'RecordID'='169057','RecordID'='171825',
it works and finds two records. But when I try to substitute out the
value with a variable, it finds zero records.
Can you please help me figure out how to structure the variable or search
to get this search to work?
Jeremy
-----------------------------------------------------------
[var: 'id_search'='']
[Iterate: $Rec_id_Array, (Variable: 'Item')]
[$id_search=$id_search + '\'RecordID\'=\'' + (Variable: 'Item') + '\',']
[/Iterate]
[$id_search]
[inline: -Search,
-Database='R',
-Table='Web',
-Operator='eq',
$id_search
-OpLogical='OR',
-SortField=$Sort,
-SortOrder=$Sort_Order,
-SortField=$Sort2,
-SortOrder='Ascending',
-Maxrecords=5]
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Dec 22, 2015; 10:47
Maxwell Klein
Re: Searching FileMaker using Array