Hi @suchit39 

What is the use of using CStr(), I am sure you know, but the function is case sensitive.

Aleks

@suchit39  CStr() is useful for Converts expression to a String but not for the filter the details.

If possible, share your GI so that it will helpful for us to review.

@Naveen Boga I used  CStr() function just to convert in to string as filter was not working in GI I tries suggestion available in Acumatica community on below link. It will be a great help if you could help me out with filtering issue as I am not able to filter one column in GI.

@suchit39 Please share your XML format of GI here.

@Naveen Boga Please find the attached XML format of GI

@suchit39  I’m not able to import above provided Gi in the 23 R2 instance and getting below error.

 

Hi @Naveen Boga Can try this new attached xml

@Naveen Boga filter is not working on Document column

Hi @Naveen Boga,

I have tried CStr() function on Document column but values are getting corrupted highlighted in below screenshot (Document column is without CStr() which is not getting filtered out and Doc column is using CStr())

@suchit39  As you are using the custom table, it won’t works for me.

Anyways, can you please provide the screenshot that how are you filtering the data..

Using

1. Parameter with condition?
2. Conditions tab?
3. Grid column filter?
4. Shared filter?

@Naveen Boga 

Please find the below details

1. Parameter with condition- We have not added any parameter
2. Conditions tab- 

   

    

3. Grid column filter?

   

    

4. Shared filter?

   

    

Hi @suchit39 

Looking at the doc value, it looks like the field is a unique identifier.

Could you please share the DAC for this table?

Aleks

Hi @aiwan Please find the below details of the field

Thanks @suchit39 

What is happening is the CStr() is removing the “mask” from the raw value of the unique identifier.

I don’t think that you should use this column for filtering, it would be like filtering with NoteID.

Aleks

Hi @aiwan Thank you. It was helpful.