How to get table record recId

(0) Share

Report

Posted on by Community Member

I am working on functionality, where I do not know the table , but I have the tableId and fieldId (field value too) , but how can I get recordId for that tables record?

I looked online for some code, and found this

http://www.doens.be/2009/07/select-a-record-from-a-table-when-you-only-have-the-tableid/

public Common findRecord(TableId _tableId, RecId _recId, Boolean _forUpdate = false)
{
Common common;
DictTable dictTable;
;
dictTable = new DictTable(_tableId);
common = dictTable.makeRecord();

common.selectForUpdate(_forUpdate);

select common
where common.RecId == _recId;

return common;
}

but it only works, when I already know the recId for the tables record. I hope you can help me with my problem. I can answer to some questions if more explanation is needed.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 237,959 Most Valuable Professional on at

Like (1)

Report
Is the field unique? If not, which record do you want to take? All? A random one?

Regarding how to access the field, you can either do it in your select statement:

where common.(fieldId) == fieldValue

or you can use a query:

q.addDatasource(tableId).addRange(fieldId).value(queryValue(fieldValue))

Was this reply helpful? Yes No