Forum Discussion

Lautorp's avatar
Lautorp
Frequent Visitor
8 years ago

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 fil...
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Lautorp,

 

How do you want to use it exactly? I can do it this way in a slicer.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

  • Lautorp's avatar
    Lautorp
    Frequent Visitor
    8 years ago

    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 

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Lautorp,

       

      Can you connect to the SQL directly?

       

      Best Regards,

      Dale