How to find all relations to a Product

[Former Member]

Hi everyone,

I am facing the following problem: our Product items get modified by something (we see the modifiedtime field changing) and this makes the SOLR update jobs pick up these products again, slowing them down. We are injecting in the query the last index time, the current time and date and the current store, but we get more products than we expect to update.

There is no direct change to the Product or its subclasses, so we are suspecting there is a relation to a Product, that marks the product as modified when the other side of the relation is modified.

I am looking if there is any way to find out all the relations to a Product (or a subtype of Product), maybe some eclipse/intellij plugin that can read the items.xml files.

Thanks for any hints!

Cristi C.

[arvind-kumar_avinash]

The easiest thing coming to my mind is to use a SQL query something like as mentioned in the following answers/topics:

1. https://stackoverflow.com/questions/26293085/find-all-table-names-with-column-name/26293118
2. https://www.thepolyglotdeveloper.com/2015/01/find-tables-oracle-database-column-name/
3. https://stackoverflow.com/questions/193780/how-to-find-all-the-tables-in-mysql-with-specific-column-...

In your case, you need to find all the tables which have the column, P_CATALOG.

[Former Member]

Thanks Arvind for the hint, it is aligned with my idea to check tables with P_PRODUCT or to look in all *-items.xml and find relations with source or target Product.

I would exclude direct references to a product, as in order entry, because these do not seem to be updated with the relation mark modified mechanism.