English 中文(简体)
DQL从网上获得i_chronicle_id
原标题:DQL to get i_chronicle_id from r_object_id

I have a situation like this: I need to find out the i_chronicle_id of a document. If I try with r_object_id(i.e select i_chronicle_id from dm_document where r_object_id= some id , it will return me the i_chronicle_id. Then no problem. But if someone has modified the document(checked out and checked in) my above query doesn t work because the r_object_id has changed in that situation, which I do not know. Can anyone help me with dql in such a situation?

注:我寻找“i_chronicle_id”的原因,是获得最新数据。

最佳回答

努力做如下事情:

select r_object_id from dm_document 
where i_chronicle_id in (
    select i_chronicle_id from dm_document (ALL) where r_object_id = ID( ? )
)

选择所有版本后的关键词

问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签