Database Schema Reference

L.s.I have some questions I would like to get answered but up till now nobody seems to be able to help me out. 1. What does a negative dataid mean i.e. in Dtree ?2. How can you tell a document has been deleted from Dtree ? (Probably only by looking at the owner (recycle bin) !?)3. What do the values in the column type mean in kuaf ? (general description won't do)4. What do the values in the column userprivilege mean in kuaf ? (general description won't do)5. What is the meaning of groupid and userid in dtree ? I have a feeling that the description in the schema reference is wrong !6. How can you pass a date from the parent to the sub-report ? The example in the book doesn't seem to work.The schema reference is nice but it still lacks a lot of information to be able to work with it !

Find more posts tagged with

Comments

Marie_Lindsay_(MLindsay_(Delete)_15608)

1. What does a negative dataid mean i.e. in Dtree ?--Depends--often refers to a "volume" ID. (I hope someone else will reply with a better answer.)2. How can you tell a document has been deleted from Dtree ? (Probably only by looking at the owner (recycle bin) !?)--(No recycle bin in the off-the-shelf functionality.) You could check the Audit trail, assuming you are auditing that event.3. What do the values in the column type mean in kuaf ? (general description won't do)Specifies whether user (0), group (1), or project group (foreign key to DTree.DataID for project).4. What do the values in the column userprivilege mean in kuaf ? (general description won't do)--Sorry, I haven't looked at it in detail. I think it's a bit mask defining which privileges (see the Add User page) the user has.5. What is the meaning of groupid and userid in dtree ? I have a feeling that the description in the schema reference is wrong !--I haven't played with these. I'd be interested in knowning why you think the doc is wrong.6. How can you pass a date from the parent to the sub-report ? The example in the book doesn't seem to work.--I'm not sure which book you're referring to. Generally, you can specify the name of the date column you used in the parent's SQL statement as sub-report parameter 1, then in the sub-report, put a %1 in the SQL statement where you want to use the date and select "user input 1" as the parameter for %1.Marie Lindsay

Jos_Doldersum_(oranjuser3_-_(deleted))

Thanks for your quick response ..... however:4. What do the values in the column userprivilege mean in kuaf ? (general description won't do)--Sorry, I haven't looked at it in detail. I think it's a bit mask defining which privileges (see the Add User page) the user has.----- I know it's a bit mask but what mask means what privilege !?!?! -----5. What is the meaning of groupid and userid in dtree ? I have a feeling that the description in the schema reference is wrong !--I haven't played with these. I'd be interested in knowning why you think the doc is wrong.----- The userid isn't the ID of the user who created the node. I've checked in the database and apparently the userid is the id of the user who OWNS the node. Try "select a.name, b.name from livelink.dtree a, livelink.kuaf b where a.createdby <> a.userid and a.userid = b.id".Try looking up one of these entries in the system and see who owns that specific node ! The same goes for the groupid I believe. -----6. How can you pass a date from the parent to the sub-report ? The example in the book doesn't seem to work.--I'm not sure which book you're referring to. Generally, you can specify the name of the date column you used in the parent's SQL statement as sub-report parameter 1, then in the sub-report, put a %1 in the SQL statement where you want to use the date and select "user input 1" as the parameter for %1.----- I thought so too but I can't get it working, I've attached two livereports (parent and sub) regarding this issue. -----

Manieka_Wright_(firdadmin_-_(deleted))

Has 6. ever been resolved? As I have also been battling with the same problem of trying to pass an input to a parent report down to a sub-report. The book referenced is Chapter 3, Livereports from the Livelink Forms and LiveReports Administrator's Guide, pages 43 - 49. The date input does not pass thru to the sub-report, but instead they are again prompted to be re-input.

Bruno_De_Planchon

I think you can make it by giving the date a name in the first report, and passing it as a parameter to the subreport. Something like :select createdate "date1" from DTree where...thensubreport parameter1 = date