How to write select statement for a enum in enterprise portal

Finance and Operations/AX Developer Forum
1

Hi

How to write select statement in ep page for selecting a enum value from table

axRecordDimensions.ExecuteStmt(“select * from %1 where %1.Num ==’” + ProjectId + “’ && %1.DimensionCode==’” + project+ “’”);

here table is dimension and dimensioncode is a ennum field and project is enum name but it throws error at %1.DimensionCode==’" + project+ “’”);

is there any other way to select the enum field

thanks