Can we add display methods or simple methods in a dynamic query in x++?

(0) Share

Report

Posted on by Arif Hussain

206

Hi experts,

I am just following to know if we can use display methods/simple methods in a dynamic query in x++. By dynamic query I mean, the query which we create it using x++ code. Please share you suggestions if it's not possible then what alternative we can take.

More precisely, here is the image what I want to say:

I have the same question (0)

All responses (7)

Answers (2)

GirishS 27,825 Moderator on at

Like (1)

Report

Can we add display methods or simple methods in a dynamic query in x++?

Yes, you can join it in your lookup query. It's just a normal dynamic query you will be writing in classes, jobs etc.

There is no difference when it comes to lookup. You just pass your final query to parmQuery method of the SysTableLookup.

It will display the lookup data based on the query DataSource added with filter - joins added.

Thanks,

Girish S.

Was this reply helpful? Yes No
Martin Dráb 236,160 Most Valuable Professional on at

Like (1)

Report

Can we add display methods or simple methods in a dynamic query in x++?

Please create a new thread for your other question.

This topic is about "Can we add display methods or simple methods in a dynamic query in x++?" and the verified answers are related to that. It would be chaotic if we changed the topic (and either have open questions in an answered thread or even verified answers unrelated to the topic).

Was this reply helpful? Yes No
Mohit Rampal 12,563 Moderator on at

Like (1)

Report

Can we add display methods or simple methods in a dynamic query in x++?

Yes, there are many blogs like below regarding multiple tables used in lookup

http://axraja.blogspot.com/2016/09/create-lookup-from-multiple-tables.html?m=1

Was this reply helpful? Yes No
Arif Hussain 206 on at

Like (0)

Report

Can we add display methods or simple methods in a dynamic query in x++?

Sir GirishS , Mohit Rampal, Martin Dráb,

As always you helped me and I am really grateful to you all.

What if my lookup contains multiple table like CustTable and CustTrans. Can we join it using SysTableLookup?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,160 Most Valuable Professional on at

Like (0)

Report

Can we add display methods or simple methods in a dynamic query in x++?

Note addLookupMethod() doesn't add a display method to a query. It just tells SysTableLookup class to run the method on table buffers returned by the query.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

Can we add display methods or simple methods in a dynamic query in x++?

Hi Arif, You can use addLookupMethod. Check this thread.

https://stackoverflow.com/questions/28049926/using-addlookupmethod

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report

Can we add display methods or simple methods in a dynamic query in x++?

Hi Arif,

You can use sysTableLookup.addLookupMethod(tableMethodStr(TableName, MethodName));

Thanks,

Girish S.

Was this reply helpful? Yes No