Hi All, I have created a query Entity that fetches data from a view.

...
ri!Code
),
{},
a!queryFilter(
field: "Code",
operator: "=",
value: ri!Code
)
),
if(
rule!APN_isBlank(
ri!secondID
),
{},
a!queryFilter(
field: "secondID",
operator: "=",
value: ri!secondID
)
),
if(
rule!APN_isBlank(
ri!ID
),
{},
a!queryFilter(
field: "ID",
operator: "=",
value: ri!ID
)
),
a!queryFilter(
field: "parentID",
operator: "is null"
)
}
)
),
pagingInfo: rule!PDIM_genericPagingInfo_All()
)
)

You can put your if around the entire queryEntity instead.

Put all the checks around your query and return "todatasubset({})" if they fail. This way you are consistent in the returned value.

you can put if condition before applying filter

just like
a!queryEntity(
entity: cons!COB_DATASTORE_CUSTOMER_CASE,
query: a!query(
selection: if(
rule!COB_verifyIsNullorEmpty(
ri!selectionColumns
),
{},
a!querySelection(
columns: apply(
rule!COB_dynamicQueryColumn,
{
ri!selectionColumns
}
)
)
),
pagingInfo: if(
isnull(
ri!pagingInfo
),
a!pagingInfo(
startIndex: 1,
batchSize: - 1
),
ri!pagingInfo
),
logicalExpression: if(
and(
rule!COB_verifyIsNullorEmpty(
ri!Id
),
rule!COB_verifyIsNullorEmpty(
ri!Name
),
rule!COB_verifyIsNullorEmpty(
ri!customerId
),
rule!COB_verifyIsNullorEmpty(
ri!caseStatus
)
),
null,
a!queryLogicalExpression(
operator: "AND",
filters: {
if(
rule!COB_verifyIsNullorEmpty(
ri!Id
),
{},
a!queryFilter(
field: "Id",
operator: "=",
value: ri!Id
)
),
if(
rule!COB_verifyIsNullorEmpty(
ri!Name
),
{},
a!queryFilter(
field: "Name",
operator: "includes",
value: ri!Name
)
),
if(
rule!COB_verifyIsNullorEmpty(
ri!customerId
),
{},
a!queryFilter(
field: "CustomerId",
operator: "=",
value: ri!customerId
)
),
if(
rule!COB_verifyIsNullorEmpty(
ri!caseStatus
),
{},
a!queryFilter(
field: "CaseStatus",
operator: "=",
value: ri!caseStatus
)
)
}
)
)
)
).data

Thanks All. Using if condition in SAIL code fixed the issue.