web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to Get Current Rec...
Microsoft Dynamics AX (Archived)

How to Get Current Recid for a select query where condition

(0) ShareShare
ReportReport
Posted on by In AX2012 in the In... 499

Hi

Please help me for my select Query where condition . 

I want to pass my current recid in select query where condition as shown in the image , i am able to view the recid in the debugging mode with view of variables. i want to know as how to pass the same value in my where.

clause.

Recid.png

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Your question is very unclear, so I have to make an assumption here.

    You can refer it by the table field value directly.

    QueryBuildRange qbrRecId = SysQuery::findOrCreateRange(yourQueryBuildDatasource, fieldNum(TableToFilter, RecIdFieldToFilter));

qbrRecId.value(queryValue(yourTableToFilterBasedOn.RecId);


  • Verified answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    I could see you are trying to access the legerJournalTrans.RecId on the form LedgerJournalTransVendInvoice. Then simply you can access RecId with the help of ledgerJournalTrans datasource on the form and your code would look like below:

    select forupdate from ledgerJournalTrans1 where ledgerjournaltrans1.RecId == ledgerjournalTrans.RecId

  • Verified answer
    In AX2012 in the InventOnHandItemListPage I need to be able to f Profile Picture
    In AX2012 in the In... 499 on at

    select forupdate DefaultDimension, from ledgerjournaltrans3 where ledgerjournaltrans3.RecId == LedgerJournalTrans.RecId;

    Just  mention the name of datasource in my case it is LedgerJournalTrans 

  • Suggested answer
    In AX2012 in the InventOnHandItemListPage I need to be able to f Profile Picture
    In AX2012 in the In... 499 on at

    Hi Chaitanya

    Thanks for the response may be due to sync issue i was not getting the value in the ledgerjournalTrans.RecId , now i am getting , before viewing your reply i hurriedly posted by update anyhow now i am getting the recid value

  • Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    NP.Its fine that your issue is resolved.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans