SysQuery::valueNotEmptyString()

(0) Share

Report

Posted on by brianmaric

I have a checkbox on a form. This checkbox is supposed apply a filter to the a field on the sales line making it not empty.

            if(!IncludeUnmarked.value())
            {
                qbds_Salesline.addRange(fieldNum(Salesline,InventRefId)).value(queryValue(SysQuery::valueNotEmptyString()));
            }

Which seems to work fine as far as the SQL goes:

{SELECT FORUPDATE * FROM SalesLine(SalesLine) WHERE MHAdditionalSOModsAuditLogTable.SalesLineRecId = SalesLine.RecId AND ((NOT (SalesStatus = 3))) AND ((NOT (InventRefId = N'""'))) JOIN FORUPDATE * FROM InventTable(InventTable) ON SalesLine.ItemId = InventTable.ItemId JOIN FORUPDATE * FROM InventBuyerGroup(InventBuyerGroup) ON InventTable.ItemBuyerGroupId = InventBuyerGroup.Group AND ((MHHcmWorkerRecId = 5637231576)) JOIN FORUPDATE * FROM MHSalesLineReqItemView(MHSalesLineReqItemView) ON SalesLine.ItemId = MHSalesLineReqItemView.ItemId AND SalesLine.InventTransId = MHSalesLineReqItemView.InventTransId}

but puts this value on the form filter:

Do anyone know why?

Thanks

I have the same question (0)

All responses (3)

Answers (0)

Alex Panait 170 on at

Like (0)

Report

You need to make the range locked or hidden. Otherwise it will be just like any normal filter / user range on the form.

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report

I tried hiding it and locking it but still same result:

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report
I found the answer...needed to remove queryvalue:

if(!IncludeUnmarked.value()) { qbr_InventRefId = qbds_Salesline.addRange(fieldNum(Salesline,InventRefId)); qbr_InventRefId.value(SysQuery::valueNotEmptyString()); }

Was this reply helpful? Yes No