Using a List to Filter in Custom Query Builder - Question

Benjamin_S — Sat, 10 Jun 2023 20:45:23 GMT

Hello,

I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom query. This seems like a no brainer but I am having trouble finding an easy way to do this from Query Builder. The answer likely lies in the "custom expression" as there are not a lot of options, but to manually enter in e.g. "t1.mfgID = ######## or t1.mfgID ######### or ..." is not realistic for repeatability.

Thanks for any help!

topic Using a List to Filter in Custom Query Builder - Question in Discussions

Using a List to Filter in Custom Query Builder - Question