Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Query element issue

AlishaKapoor
Level 1
Level 1

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

3 Replies
ramon_bisswanger
Employee
Employee

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

AlishaKapoor
Level 1
Level 1

Hello Ramon,

 

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:

  • I try to search (say ID 123456) in ACS>>client data>> products, It shows me n-no of records with same ID
  • But when I extract whole data of Products table in an excel file through workflow, and I search same ID in my excel, I get only 1 record.