Form grid position to record is not working

(1) Share

Report

Posted on by tyhj

629

I have a new simple list form that is opened to show all records from a list page.

When open the form, it is always show first record but not the selected record from the list page

The datasource in new form set as tmp let say is MyTable, when the form opens I want to set like below

MyTable selectedBuffer;
        
select firstonly MyTable 
    where MyTable.RefRecId == element.args().record().RecId;
    
selectedBuffer.data(MyTable);
MyTable_ds.positionToRecord(selectedBuffer);

I have try above code in datasource init but it's not working. In the executeQuery, the form open with the selected record only

How can i open a form with all records and the cursor is highlighted in the selected record from previous caller ?

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Martin Dráb 239,747 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Why exactly do you select data from MyTable and then pass it to selectedBuffer? Couldn't you simply do this?

select firstonly myTable where myTable.RefRecId == element.args().record().RecId; MyTable_ds.positionToRecord(myTable);

Does it make a difference? I've never tried it, but the fact that you're using non-temporary buffer (populated with data()) to find a record in a temporary table may be a source of problems.

Also, init() may be too early. What if you do it in run() instead?

Was this reply helpful? Yes No
tyhj 629 on at

Like (0)

Report
Copy link

Link copied!

Yes init() maybe too early. I use a buffer hoping I can get the result I want. But seem like no difference. The code and my previous code give the same result, under form run() method, it will open only one record (selected record).

Also I try to add the caller table as a datasource in my new form, the new form is also filtered to the selected record only.

I suspect temporary datasource does not support the positionToRecord / findRecord method ? Is there any other way to do this ?

Was this reply helpful? Yes No
ToddB Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi SLC,

Were you able to resolve the issue?

Not sure if the below thread helps:

Form datasource find record method

community.dynamics.com/.../form-datasource-find-record-method

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

Like (0)

Report
Copy link

Link copied!

findRecord() is deprected, it was replaced with positionToRecord(). Source: Deprecated APIs.

Was this reply helpful? Yes No