I have come across a problem to which I cannot find a solution. Problem goes like:
Say, I have a table named "Products" and we inserted data into table using file. We had unique data in file and data also gets inserted successfully but when I open my table from client data>> products table, I can visibly see duplicacy of records.
Surprisingly, If I try to query the table by using particular ID in query element:
it returns only "1" as Count
but shows me n-no of records when I preview same data in same query element
This then rather looks like some issue with a link definition on the table.
Count basically just executes a count on the table itself while view fetches the records including links/joins to other resources.
So you may need to check the link definition that it really just results in 1:1 results.
e.g. if you have "country" on the product table linked to "country" on a profile, then the row would be shown once for each profile assigned to that country
Thank You for replying. I checked on my links. My table is connected to three other tables using 0 and 1 cardinality simple link.
I understand that Count basically just executes a count on the table itself while view fetches the records including links/joins to other resources but when I try to access my table from navigation client data>> products, I can visibly see my duplicate records.
Also to explain more, I tried two things: