Microsoft Dynamics AX (Archived)

Lookup method

(0) Share

Report

Posted on by BASMA

932

I add lookup method in form to filter data.

Query query = new Query();
QueryBuildDataSource queryBuildDataSource;

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(SecurityRole), this);
sysTableLookup.addLookupField(fieldNum(SecurityRole,Name));
queryBuildDataSource = query.addDataSource(tableNum(SecurityRole));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();

but when I delete role from SecurityRole and I open Form I get the role deleted like this :

0841.role.png

the role "TestRole" doesn't exist in securityRole but I find it in filter :

8345.security.png

How can I solve this issue?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi, BASMA!

If you take a look at the Delete button and clicked method on this button you will see what selected role not deleted - it's disabled. Try to add queryRange on IsEnabled field of SecurityRole table.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

Hi BASMA,

Are you sure that you deleted it instead of disabling ? Go to AOT and check if it is there under Security\Roles. If it it there and disabled then you need to add range to the query by "IsEnabled" field, because form you referring to does not show disabled roles.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

Hi,thanks for reply.

Yes I find it in AOT\Security\Roles:

But I don't understand your suggestion,How can I add queryRange on IsEnabled field??

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Try this:

queryBuildDataSource.addRange(fieldNum(SecurityRole, IsEnabled)).value(queryValue(NoYes::Yes));

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

I add this in lookup method but I get error:

queryBuildDataSource=query.addRange(fieldNum(SecurityRole, IsEnabled)).value(queryValue(NoYes::Yes));

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

It's a wrong code

queryBuildDataSource=query.addRange(fieldNum(SecurityRole, IsEnabled)).value(queryValue(NoYes::Yes));

you need this

queryBuildDataSource.addRange(fieldNum(SecurityRole, IsEnabled)).value(queryValue(NoYes::Yes));

Range need to be added on DataSource, not on query.

Query query = new Query();
QueryBuildDataSource queryBuildDataSource;

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(SecurityRole), this);
sysTableLookup.addLookupField(fieldNum(SecurityRole,Name));
queryBuildDataSource = query.addDataSource(tableNum(SecurityRole));

queryBuildDataSource.addRange(fieldNum(SecurityRole, IsEnabled)).value(queryValue(NoYes::Yes));

sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

when I add this code I don't get error but in the form I don't get any value in filter

Was this reply helpful? Yes No
Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Try value("1") instead of value(queryValue(NoYes::Yes))

Was this reply helpful? Yes No
BASMA 932 on at

Like (1)

Report
Copy link

Link copied!

Thanks Rustem.

It works now :)

Was this reply helpful? Yes No