Table not get filter properly

(0) Share

Report

Posted on by Community Member

Hello guys!

We have a table called Master Employee. From a another software they are entering data to our table. Directly using SQL.

If I filter table using primary key table get filter, but if I filter other field it does not get filter properly.

I tried lot but did not work.

Please help.

Thank you in advance.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (3)

Suggested answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

Hi

Could you show us the code how you have applied the filters, also refer the below

msdn.microsoft.com/.../dd354919.aspx

msdn.microsoft.com/.../dd354955.aspx

Regards

Rajasekhar.Y

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

EMPmaster.RESET;

EMPmaster.SETFILTER(EMPmaster."No.","No.");

IF EMPmaster.FINDFIRST THEN BEGIN

Dep :=EMPmaster."Department Assigned";

EMPmaster."Transfer Date" := TODAY;

EMPmaster.MODIFY;

END;

Was this reply helpful? Yes No
Rajasekhar@MS 5,569 on at

Like (0)

Report

Is No. is the Primary Key of EMPmaster Table, if you can use Get if EMPmaster.GET("No.") THEN BEGIN;

and could you explain us it does not get filter properly means?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If filter in primary key, table will get filter. if filter in any other field it does not get filter at all.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

Check if the table contain any special characters since data is been transferred from third party application.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

Your code seems ok and it might be a issue in the table. Export your table object, Drop the table and import and compile the object.

After that restart the Microsoft Dynamics NAV instance and try.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for the advice, I tried it, but did not work, still have problem in filter. I tried with another table and filters work fine in that. Problem is only with this table.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (1)

Report

Which field is it and can you show us the filtering code?

Was this reply helpful? Yes No
Verified answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

can you run select * from [Tablename] in SQL Server Management and Copy the Rows generated as output in a Excel File.

It Seems to me that your Excel File Will not be same as it seems as Output in Sql Server Management Studio.

Just try the same and share the screenshot of the Excel File generated after copying rows from SQL.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Fond the issue! In some column there were NULL values and that cause the issue.

Was this reply helpful? Yes No