.. _ask-adi-common-questions-snip:

==============================
Ask ADI Common Questions
==============================

There are a number of common things we use Ask ADI for.

This is a list of them.

Find rows with duplicate keys
=================================

If you want to check to see how many duplicate field values are in  a History or Detail tile use:

    .. code-block:: RST

        list rows with duplicate [business names]

    Where [business names] is the field you want to check for duplicate values.

    .. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/rule-snippets/aacq-1.png
        :width: 100px

If you then want to see the duplicate rows to compare the fields 

    .. code-block:: RST

        list rows for [business name]equals [McNatty Construction]

    Where [business names] is the field you want to search and [McNatty Construction] is the value you are searching for in that field.

    .. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/rule-snippets/aacq-2.png
        :width: 100px