Filtering by first three characters

[Inactive User]

Hi!

I am trying to filter by the first three numbers of ManagerID. I am doing this in database. Any ideas on how I could do this? Thank you!

[EW]

Try using a Filter In-DB tool with something like: 

"ManagerID" LIKE '123%'

To filter for records where the first three characters are 123.  

[Inactive User]

Thanks! Do you know how I could do it so the end user can do the filter? I am making this an app.

[EW]

I'm less familiar with apps, but try this!  I've got it set to update the value 111 to the input value.  

I'm not sure how to post functional in-DB Connect or  Data Stream In, so this is unconfigured but the filter seems to be working.  

[Inactive User]

That is perfect, thank you! Would you mid explaining how you build that out? 

[EW]

Trial and error for me and app tools!  🤣

Once you have your filter in-DB tool inserted and configured, you'd insert a Control Parameter tool connected to it, and a Text box tool connected to the control parameter.  You'd configure the Control Parameter to Update Value, Replace a specific string, and whatever your placeholder text is like this:

Does that help?