We are fetching some results using a Report Definition. In this Report Definition, we have a Text property and its values are getting saved into DB Table as a String with total 36 characters. For example - "6a921dcc-ebe2-4b2c-be55-23c74f4eec29".
Problem : This report definition is able to fetch some other values of this property successfully; for example - "abc", "123", "321" and so on... but it is not able to fetch the text value "6a921dcc-ebe2-4b2c-be55-23c74f4eec29".
What we tried : We checked the values of this property and tried searching from Report Definition Tab in Dev Studio and we found that there is a plus symbol just after this text value and it is fetching values like this - 6a921dcc-ebe2-4b2c-be55-23c74f4eec29+. We have tried changing the max length to 36 characters by optimizing the property. But this is still not fetching the any record.
Solution Required : Is there any way we an change the size of this property so that it will fetch the expected result? How we can make this possible?
***Edited by Moderator Marije to add Capability tags***
@SanthoshRanga Thank you for your concern. This has been sorted. It was not displaying any record because of the Varchar length issue. We were trying to save a string with 36 characters against that property however the its Max Length was less than 36. I optimized this property and later ran Connect SQL to update the max length in DB. It worked. Thank you once again!