Hi,
I am attempting to feed an attribute value into a published parameter WHERE Clause in a WorkspaceRunner (the workbench reads an AGOL feature service, which i want to limit the number of features it has to read as its very slow).
FeatureReader is not an option as I need to read attachments.
In the error log it shows that instead of using the attribute value @Value(SQL), it is the actual text @Value(SQL) that is getting used. Am I doing something wrong? Or is this a bug?
Thanks
Best answer by takashi
Hi @n543, I was able to reproduce the same error, if I have created the published parameter from the WHERE Clause parameter in the AGOL reader. I think it's a defect. Hope someone from Safe would take a closer look at this. > @NatalieAtSafe
In the interim, it might be a workaround if you create a new published parameter with Text or Text (Multiline) type and link the WHERE Clause parameter to that.
I had a similar issue when trying to pass the list of attribute to compare for a Matcher in the child workspace as the value of and attribute from the calling workspace. I worked around that by using a SystemCaller calling fme.exe with the required parameter values.
+19Hi @n543, I was able to reproduce the same error, if I have created the published parameter from the WHERE Clause parameter in the AGOL reader. I think it's a defect. Hope someone from Safe would take a closer look at this. > @NatalieAtSafe
In the interim, it might be a workaround if you create a new published parameter with Text or Text (Multiline) type and link the WHERE Clause parameter to that.
Hi @n543, I was able to reproduce the same error, if I have created the published parameter from the WHERE Clause parameter in the AGOL reader. I think it's a defect. Hope someone from Safe would take a closer look at this. > @NatalieAtSafe
In the interim, it might be a workaround if you create a new published parameter with Text or Text (Multiline) type and link the WHERE Clause parameter to that.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
