Forum Discussion
URL Filtering with number in table name
m4dt3o wrote:
Thank you d_gosbell, but this was the first thing i tried.
OK, but you did not mention that in your original post.
This does seem like a bug. I would suggest raising a support ticket for this so that an engineer can investigate this.
One work around that appears to work on the service is to encode the ASCII value for the leading number in the same way that the other special characters like spaces are encoded.
eg
?filter=1_x0020_table_x0020_name%2FColumn%20eq%20%27John%27
would become the following since 1 is ascii character 31
?filter=_x0031__x0020_table_x0020_name%2FColumn%20eq%20%27John%27
m4dt3o wrote:
Thank you d_gosbell, but this was the first thing i tried.
OK, but you did not mention that in your original post.
This does seem like a bug. I would suggest raising a support ticket for this so that an engineer can investigate this.
One work around that appears to work on the service is to encode the ASCII value for the leading number in the same way that the other special characters like spaces are encoded.
eg
?filter=1_x0020_table_x0020_name%2FColumn%20eq%20%27John%27
would become the following since 1 is ascii character 31
?filter=_x0031__x0020_table_x0020_name%2FColumn%20eq%20%27John%27
Again Thx! my fault didn't mention it before.
BTW on the report server side, seems NOT working even the
?filter=_x0031__x0020_table_x0020_name%2FColumn%20eq%20%27John%27
😞
Do you know how to raise a ticket? there is a link?
thank you very much again for your reply
Correct myself: IT is working!!!
the syntax with the translated ASCII number seems to wiork. Thank you again d_gosbell