Hello! I would like to know if it is possible to filter only the injection that has at sample name "100 mL"? I would like to express both injection but in a different page.
Find maintenance, best practice, and troubleshooting articles.
Hello! I would like to know if it is possible to filter only the injection that has at sample name "100 mL"? I would like to express both injection but in a different page.
Hello,
You would need to use sample_name like "*100 mL*" = false as the filter. In the example below, I remove the samples with Batch002 in the name. I typically use trim and ucase to make sure that spaces and string case do not affect the filters. In this case with the like function and wildcards the trim is not really needed.
Marty
I think I put like as you say but I couldn't filter.
The injection with 100 mL still showing at the report.
I think I put like as you say but I couldn't filter.
The injection with 100 mL still showing at the report.
Hello,
You need to change the filter string to the upper case version, so "*100 mL*" needs to be "*100 ML*" in your filter.
Marty
Thank you so much, Martin! It's working!