CODEWITHSUNDEEP
sap-commerce-cloudflexible-search
john
john

Reputation: 15

Need help on Flexible search query to retrieve the classification atrributes values matches with one of the classification attribute

Iam new to Flexible Search Query, I am trying to write flexible search query to retrieve the classification atrributes values matches with one of the classification attribute as below:

select {ca.code} from {ProductFeature as pf 
join Product as p on {pf.product} = {p.pk} 
join ClassAttributeAssignment as caa on {pf.classificationAttributeAssignment} = {caa.pk}
join ClassificationAttribute as ca on {caa.classificationAttribute} =  {ca.pk}
join ClassificationClass as cc on {caa.classificationClass} = {cc.pk}
JOIN CatalogVersion as cv ON {cv.pk}={p.catalogVersion}
 JOIN Catalog as cat ON {cat.pk}={cv.catalog}} where {ca.code} = 'capacity' and {cv.version} = 'Staged'

In above snippet, am able to get code of ClassficationAttribute, but how do I get values of that attribute?

Upvotes: 0

Views: 1436

Answers (1)

Tugba Alparslan
Tugba Alparslan

Reputation: 203

I was facing the same issue. The problem is that your select statement is wrong. You need to be using {pf.stringValue} instead of {ca.code}

Upvotes: 0

Related Questions