Read multiple project types

Hi Experts,

Read multiple project types from project types, Ex: I have ProjType1,ProjType2,ProjType3.... in ProjectTypes entity. Now I need to get ProjType2,ProjType3 with specific parameter like 'X'.

Below are my entities and in service.js I have written entity ProjectTypes as SELECT from my.ProjectTypes Which returning all the ProjTypes.

entity ProjectTypes{ key ProjectTypeID : String; ProjectTypeText : String; projects : Association to many Project on projects.ProjectTypes = $self; }entity Project { key ProjectID : Decimal; ProjectDescription : String; ProjectTypes : Association to ProjectTypes; Coach : Association to Couches; }Thanks in Advance.