Make field value redistricted to lookup value

(0) Share

Report

Posted on by maram fraij

I have a string field and I build lookup based some certain criteria. I need to restrict the value which may be entered directly from user ( not selected from lookup) to lookup values.

I know that I can use validate method to validate field value , but I need to know if I can do this directly especially if I have complicated criteria build in lookup

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi maram fraij,

Usually you have a query for a lookup. So you can reuse same query in validate method and check if this query returns something for value entered by user. Ideally you can create a method that returns query and use it in lookup and validate methods.

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report
Copy link

Link copied!

How can I use query to validate the value ? can you share some code

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!
Let say you have a query already with table InventTable and your lookup is over ItemId.

boolean ret = true; QueryRun qr; QueryBuildDataSource qbds = query.dataSourceTable(tableNum(InventTable)); qbds.addRange(fieldNum(InventTable , ItemId)).value(queryValue(valueFromTheField)); qr = new QueryRun(query); if (!qr.next()) { ret = checkFailed('Not valid'); } return ret;

Was this reply helpful? Yes No
Suggested answer

Heinz Schweda 1,367 on at

Like (0)

Report
Copy link

Link copied!

Hi,

you may use the class SysLookupMultiSelectCtrl to build your lookup. Using this class you don't have to overwrite the lookup-method of you StringEdit field, instead you have to build your lookup in the init-method of your form.

Using this class, the user has to use the lookup, he is not able to enter values manually. But maybe this is exactly what you want.

See following simple example, hope it helps (LookupStringEdit has to be replaced with the name of your StringEdit-field).

public void init()

{

Query query;

super();

query = new query();

query.addDataSource(tableNum(CustGroup));

SysQuery::findOrCreateRange(query.dataSourceTable(tableNum(CustGroup)), fieldNum(CustGroup, Name)).value("*inter*");

SysLookupMultiSelectCtrl::constructWithQuery(this, LookupStringEdit, query);

}

Regards,

Heinz

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report
Copy link

Link copied!

Hi Heinz,

I need only one value to be selected so SysLookupMultiSelectCtrl cannot be used . is it applicable to make this control accepts only one value?

Was this reply helpful? Yes No
Heinz Schweda 1,367 on at

Like (0)

Report
Copy link

Link copied!

Hi, sorry, i didn't realize that you only need one value. So my suggested code won't help you.

Was this reply helpful? Yes No
Suggested answer

Jonathan Halland 11,310 on at

Like (0)

Report
Copy link

Link copied!

Hi Maram

I think you are looking for the modifiedField method on table if its a global rule or else the modified method on the field of your form's datasource if its form specific logic. In there you can validate against the same criteria as your lookup and clear the value if its incorrect

Was this reply helpful? Yes No