cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lautorp Frequent Visitor
Frequent Visitor

Use of ASCII code as a filter

I'm trying to filter an inventory tabel from my Dynamics C5 but the Location colum on my primary location is marked with an ASCII code (┐) in the SQL db. Does anyone knows how I can use this as a filter? PS: It dosn't work just trying it in ;-) BR Morten

3 REPLIES 3
Community Support Team
Community Support Team

Re: Use of ASCII code as a filter

Hi @Lautorp,

 

How do you want to use it exactly? I can do it this way in a slicer.Use of ASCII code as a filter.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lautorp Frequent Visitor
Frequent Visitor

Re: Use of ASCII code as a filter

In my Inventory table in my Dynamics C5, my warehouse location is set with a blank character in the C5 system, but in the SQL table an ASCII character (CHAR(2)) is set.

 

I want to filter my inventory record so I only see my blank location.

 

Hope that makes sence ;-)

 

Morten 

Community Support Team
Community Support Team

Re: Use of ASCII code as a filter

Hi @Lautorp,

 

Can you connect to the SQL directly?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.