You’re offline. This is a read only version of the page.
Announcements
928
Hi everyone,
I have a lookup form where I want to add range to the the querybuilddatasource.
this.queryBuildDataSource().addRange(fieldNum(ABCHRMEmployeeLookup,PositionId)).
value(HcmPosition::find(hcmPositionHierarchy.Position).PositionId);
this line is working fine with few Records but with 996 records it give this error.
Then I decided to keep the 996 records in the tempDB table and try to create join with my data source
which is a view of the query.
I wrote this code to join with my current datasource.
Then I got this Error
Please help me how I can solve the first and second problem.
P1: How to set multiple ranges without buffer overflow?
P2: How to Join Temp table with this data source? (datasource is AOT View of AOT query)
For Problem 2 I tried this suggestion. But I can't be able to use 'this. query().'
community.dynamics.com/.../the-data-source-is-not-embedded-within-a-parent-data-source
*This post is locked for comments
I can't do that as the query is working on multiple lookups. I think I should use a regular table and add a field to keep track of the current user. delete table element for new lookup for each user.
It will be slow but it will work as I am dealing with a few thousand rows.
Thank you ievgen Miroshnikov..
I can't do that as query is working on multiple lookup. I think I should use regular table and add a field to keep track of current user. delete table element for new lookup for each user.
It will be slow but it will work as i am dealing with few thousand rows.
Thank you ievgen Miroshnikov..
Yes.
Please help me understands why it is not working in my case.
Normally I have used query directly on the form and I can do like this.query(), ... etc
As now "data source is an AOT View which contains an AOT query." Now I can't use 'this.query()'
Or any good reading material in this regard.
Hello @ievgen Miroshnikov,
this.setREcord is not working in my case. because my datasource are associated with View which contain an AOT query.
e.g
this.queryBuildDataSource() is working
but this.query() is not working so as this.setRecord()
please help?
Using SetRecord is not showing any Result
qbds=this.querybuilddatasource().addDataSource(tableNum(AbcPositionHierarchy));
qbds.joinMode(JoinMode::ExistsJoin);
qbds.addLink(fieldNum(AbcHRMEmployeeLookup,HcmWorker),fieldNum(AbcPositionHierarchy,workerRecId),this.queryBuildDataSource().name());
this.setRecord(abcPositionHierarchy);
what is wrong with this code? especially this.setRecord line
Hi Khurshid,
Please go through below link.
mafsarkhan.blogspot.com/.../example-for-using-tempdb-table-in-query.html
but there is no tmpTableClass in my AX version?
AX 2012 R3 6.3.3000
#1
André Arnaud de Cal...
294,125
Super User 2025 Season 1
#2
Martin Dráb
232,871
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
