Показать сообщение отдельно
Старый 16.11.2011, 15:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,644 / 848 (80) +++++++
Регистрация: 28.10.2006
workflowax: How do I select from table Common in AX?
Источник: http://workflowax.wordpress.com/2011...-common-in-ax/
==============

Workflow quite often uses fields such as ContextTableId and ContextRecId to reference the original document. I’ve been needing to get hold of the original database record as a Common object from which I can then do various things, but the question is how do i get that common object?

I’ve tried something like this
X++:
Common buffer;
;
select buffer where buffer.TableId == _tableId && buffer.RecId == _recId;
This however always return an empty buffer regardless of whether or not the record does exist. I eventually managed to retrieve a common record with the following method.
X++:
Common buffer;
SysDictTable dictTable;
;
dictTable = new SysDictTable(_tableId);
buffer = dictTable.makeRecord(); 
select buffer where buffer.RecId == _recId;
I’ve needed to do this a couple of times in the past and kept forgetting, so I’m posting it here for myself and who ever else wants to accomplish this. Enjoy!




Источник: http://workflowax.wordpress.com/2011...-common-in-ax/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.

Последний раз редактировалось Poleax; 16.11.2011 в 17:42. Причина: оформление