Hello,
I want to use a parameter value from one table which is not a primary key nor IDX and use that value of parameter to filter the other table row.
I have added input data in service template to fetch the parameter value. And I am using that value to filter Input service table but its not filtering.
Let me know what needs to be corrected in order to filter the row.
Thanks.
Hello, Yes I did the same thing but its not filtering in other table.
For this one my suggestion would be to inspect the final configuration for the generated service that was created by the service template.
So in Cube surveyor, right-click the generated service and select Service Template > View Details.
A window will show up which will show all included child elements with the included parameters as well as the filters that are effectively being used. Verify that these filters are what you were expecting.
An alternative would be to select Duplicate > As Regular Service and to validate the settings from there. You can even save this service to verify whether the filtering works or not.
Hope this helps!
Yes, all the values of the parameter is correct. I verified in the service template details. I am getting parameter value suppose 12345. Now, I want to use this value to filter the other table. The other table has matching value under the column which has green key drawn on it. I have used ^pk^value and *value* in the child elements of service template to filter but none of this is working. may I know if I am using parameter in wrong way or what is actual way to use the value.
Thanks!!
Some more thoughts:
– Make sure the “^pk^*[data:xxxx]” does not contain any spaced between “^pk^” and “*” or between “*” and “[data…”
– Try creating a regular service (so outside of service templates) and use the same filters (e.g. “^pk^*xxx*”), without clicking the key icon. Then verify whether or not your parameter is properly included or not in the service that was created
Hi friend,
couldn’t you use a fixed data variable on the service template in order to store that parameter value first and then use that variable for filtering?
best regards