search

FeedTheCube / CogDoc

0 stars 0 forks source link

_SQL_GetAllReports is not a cross platform script #32

Open hyndgrinder opened 6 years ago

hyndgrinder commented 6 years ago

The WITH statement in the GetAllReports query uses MSSQL specific language. Need to alter to allow the query to run in all platforms.

SinclairC commented 6 years ago

Is this query otherwise valid for different content-stores? Do they all store reports in the same place, with the same column names?

hyndgrinder commented 6 years ago

Yes, as far as I know, the process to build the store is pretty standard across platforms. I can show you the structure if you like.

SinclairC commented 6 years ago

Just a small question about the new SQL: Is CMOBJPROPS7 a typo, or is it always #7? Or are there six more before that which might also have the data in some cases? I guess seeing the whole structure would be helpful.

hyndgrinder commented 6 years ago

There are almost 100 props tables, but they are always in the same order, and they are not always relevant to the CMOBJECTS record. For instance, the PROPS7 table is for reports, while the PROPS1 table is for Users (I beleive). There are also PROPS tables for folders, shortcuts, modules, ... basically every object in the cognos content store has a PROPS table.

SinclairC commented 6 years ago

Sounds good. I was just making sure that we don't have to account for reports in different PROPS tables. Is there anything useful to us in any other the others that we might want to incorporate into our program later?

hyndgrinder commented 6 years ago

...perhaps. I haven't finished going through them all yet. The one property I wanted (Owner) doesn't seem to be populating. Typical.