Display only negative values

(0) Share

Report

Posted on by Community Member

I have created a form with SaleLine Table.When i open my form it has to display records with only negative values from the field Expected Return quantity.

How to give <(Less than) in Query in execute Query method().

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Ivan (Vanya) Kashperuk on at

Like (0)

Report

typing up here, so might contain some spelling/compilation mistakes.

salesLine_q.dataSourceTable(tableNum(SalesLine)).addRange(fieldNum(SalesLine, ExpectedReturnQty)).value('..0');

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

I would simply call this.queryBuildDataSource().addRange(...).value('<0') in the init() method of the data source. You shouldn't do it in executeQuery(), because you don't want to add a new range every time the query executes.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Ivan i got idea from your post but, i have implemented it in init method. Thats working for me

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Martin

Was this reply helpful? Yes No