Data Filter help

[pawwy1415]

Hi Experts,

Can any one please help me on below requirement.

I have extracted the below script from Rest connector. I have to load only name = Approved data which is highlighted in red color.

Could you please help me to apply the condition here.

RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"id" AS "id_u2",
"createdBy",
"createdOn",
"lastModifiedBy",
"lastModifiedOn",
"system",
"name" AS "name_u2",
"__KEY_results",
"__FK_results",
(SELECT
"id",
"name",
"__FK_domain"
FROM "domain" FK "__FK_domain"),
(SELECT
"id" AS "id_u0",
"resourceType" AS "resourceType_u0",
"name" AS "name_u0",
"__FK_type"
FROM "type" FK "__FK_type"),
(SELECT
"id" AS "id_u1",
"name" AS "name_u1",
"__FK_status"
FROM "status" FK "__FK_status")
FROM "results" PK "__KEY_results" FK "__FK_results")
FROM JSON (wrap on) "root" PK "__KEY_root";

[Anil_Babu_Samineni]

May be use

If(name='Approved', name) as name_u2

Or 

Load * Where name='Approved';

SQL SELECT
"__KEY_root",
(SELECT
"id" AS "id_u2", .......

[pawwy1415]

Hi,

This one didn't work. We want to restrict at API level as we've 40 millions record and we want to extract only last 1 week record and based on some condition