i have a saved search which is showing results in the UI, but when i load it in the script and run, it shows the eroor 'Unexpected error'. How to resolve this?

try setting the search to public if it's not already.

thank you sir, its fine now

Do you only have one formulanumeric column?

no i have more than one.

I don't have an example in my code and haven't had to reference more than one recently. Normally for one, you drop the number altogether. I wonder if it's formulanumeric_1 though rather than formulanumeric1 🤔 I'll see if I can find out for you.

ok Thank you

You might have to use the columns from the saved search and use the columns index instead.

ok

If you search the slack channel you actually asked about this 3 months ago and have an answer that you said worked. so if the same resolution does not work, maybe it's not the approach but your data...

Thank you i used the column index and its ok

Just be aware that if the saved search changes, i.e. someone moves the columns around or adds / removes the columns you may run in to issues depending on how you're evaluating the columns. (this is why I prefer to code the saved search if it's static 😉 )