Pulling set of offers that have a specific custom attribute value (Treatment_type is the name of the custom attribute) | Community
Skip to main content
August 4, 2025
Solved

Pulling set of offers that have a specific custom attribute value (Treatment_type is the name of the custom attribute)

  • August 4, 2025
  • 1 reply
  • 286 views

Hi Team,

We want your insights to obtain list of offers that are having a similar value for the custom attribute column in AJO/AEP

Thanks,

Mohana.R

Best answer by Mayank_Gandhi

@mohanala Go to the AEP UI and check Datasets > 666025f90a4b0d2c3208eb32.If the dataset is empty (no records ingested), ingest at least one record.
Adobe Experience Platform does not create a physical table until some data is loaded.

1 reply

Mayank_Gandhi
Adobe Employee
Adobe Employee
August 4, 2025

@mohanala  you can try something like this with PQL

SELECT *
FROM decision_object_repository_personalized_offers    -- replace with actual dataset name
WHERE characteristics['customAttribute'] = 'YourValue'

 https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/pql/overview

MohanaLaAuthor
August 5, 2025

Hi @mayank_gandhi ,

 

Thanks for replying 

I tried to query the table, but got the below error

2:14:04 AM > Query failed in 0.602 seconds

2:14:05 AM > ErrorCode: 08P01 queryId: 52db0238-21e5-4df2-bee2-a0e594e63e85 Unknown error encountered. Reason: [Table not provisioned for dataset: 666025f90a4b0d2c3208eb32 at abfss://gen1@datalakegjlipb4f078afjaf.dfs.core.windows.net/platform/666025f90a4b0d2c3208eb32. To prevent this error either add data to the dataset or specify withAutoProvisionTableEnabled(true) when calling this operation]

COuld you please help on why i am seeing this error

Mayank_Gandhi
Adobe Employee
Mayank_GandhiAdobe EmployeeAccepted solution
Adobe Employee
August 5, 2025

@mohanala Go to the AEP UI and check Datasets > 666025f90a4b0d2c3208eb32.If the dataset is empty (no records ingested), ingest at least one record.
Adobe Experience Platform does not create a physical table until some data is loaded.