Is anyone aware of using a wild card with filter string on the LMRK Transaction node?

jose-sahagun

I am trying to filter a set of records that contain certain criteria in the description. Has anyone had any luck in trying to use filter to records using a wild card? Trying to obtain the same functionality as with TSQL where you can use LIKE '%criteria%'

Example:

Transfer 1000; 12345-Doe, John

Goal:

Pull all records where description is like "Transfer 1000."

I am trying to avoid pulling all records and using javascript to then iterate to idenify the LIKE scenario.

kyle-tucker

Here is an example from the Employee business class that is pulling names with "yl" in the Given Name. I like to use ISD to test out filters as the filters there are written similarly to those needed in LMRK transaction nodes.

Name.GivenName like "*yl*"

In your case this would be - Field like "*Transfer 1000*"