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)

Sort by

Suggested answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 239,063 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

Thanks Martin

Was this reply helpful? Yes No