What is TypePkString in Hybris?

[Former Member]

What is TypePkString in Hybris?

[former_member620692 · Accepted solution]

TypePKString represents the code of an item type. There is a unique code for each of the item types in your hybris system e.g. execute the flexible query, SELECT DISTINCT {item.itemType} FROM {Product as item} in hAC and it will give you the TypePKString of Product and all its child item types. You can validate the same by hovering the mouse over the rows representing Product or its child item types on Maintenance > Deployment page of hAC. I have also attached the screenshots for your quick reference.

Note: If you are interested to check the TypePKString of just Product, you should execute the flexible query, SELECT DISTINCT {item.itemType} FROM {Product! as item}.

[geffchang]

Is this from the SQL? It's a String representation of the Primary Key of the Type. For example, it could be the Primary Key of the Product type (not the instance of a Product), represented as a String, instead of a number.

[Former Member]

Yes from Sql. Thank you . : Any reference or Link if u share, that would be great.

Rgards, Jagnya

[geffchang]

I'm not sure if there is any official documentation about each SQL-based column name. Usually, you only work / query Hybris using FlexibleSearch syntax, not SQL. Hybris converts this to SQL. Anyway, there is some relevant document about FlexibleSearch and SQL: https://wiki.hybris.com/display/release5/FlexibleSearch

[Former Member]

Thank You :)

[geffchang]

If you are satisfied with the answer (or if it answers your question), please Upvote and Accept it. If not, you can keep it open.