Convert select in to Query Stataement

Hi all,

my select statement is attached below… How can i convert the select statement in to the Query statement…???

while select * from UtilElementsLocal order by name
where
UtilElementsLocal.recordType == UtilElementType::Form &&
UtilElementsLocal.utilLevel == global::currentAOLayer() &&
UtilElementsLocal.createdDateTime>=rangeStart &&
UtilElementsLocal.modifiedDateTime<=rangeEnd
{
info(strFmt("%1 %2 %3",UtilElementsLocal.name,UtilElementsLocal.createdDateTime,UtilElementsLocal.modifiedDateTime));
}

In your select statement mistake is there, this is the right one.

while select * from UtilElementsLocal order by name
where
UtilElementsLocal.recordType == UtilElementType::Form &&
UtilElementsLocal.utilLevel == global::currentAOLayer() &&
UtilElementsLocal.createdDateTime>=rangeStart &&
UtilElementsLocal.createdDateTime<=rangeEnd
{
info(strFmt("%1 %2 %3",UtilElementsLocal.name,UtilElementsLocal.createdDateTime,UtilElementsLocal.modifiedDateTime));
}

how ever for this query range filter:

  1. you need to add datasource into that report and put the table property to utilelements.
  2. In design node → auto design → create a body —> add a required fields to that body .
  3. Open the report and put filter on it.

can u explain clearly

8081.Capture.PNG