Query element issue | Community
Skip to main content
A
AlishaKapoor
August 10, 2021
Question

Query element issue

  • August 10, 2021
  • 1 reply
  • 998 views

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 post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

B
Adobe Employee
bisswangAdobe Employee
Adobe Employee
August 12, 2021

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

    A
    AlishaKapoorAuthor
    August 12, 2021

    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.
    Terms & ConditionsAccessibility statement

    Loading footer...