Infoset Data?

I'm not positive about this - I know just enough about this to be dangerous - but I think it is stored on the OLAP server on the LBI box as a cube.  Because of this, it's not someplace that can be easily queried directly, if that's what you're trying to do.

I'd be happy to hear that I'm wrong, if there is anyone else out there who knows more about this than I do...

It's been awhile since I looked for this, but I believe it is in a blob/image field on one the SN tables. However, if you check the large infoset box when saving the infoset, the data will be stored in a database table in the SN repository (table will start with the name "INFOSET...").

I thought I remembered it being a blob...but I've looked in all of the SN tables and can't find anything...I don't believe is uses OLAP....

I thought I remembered it being a blob...but I've looked in all of the SN tables and can't find anything...I don't believe it uses OLAP....

I don't know if this helps or not, but what I pass to access one of the Infosets through ProcessFlow, I go to the LBI Server, LawsonSN database and then query on the specific infoset that I am attempting to access the data from. I actually trigger the update of the infoset in ProcessFlow and then query on the results.

Hpw specifically do you query the Infoset results? What node are you using?

I am using the SQL Node to query the infoset.

Do you mind posting your query?

There is actually 3 separate queries that I run. One to detect Adds, another to detect Deletes and another to detect Changes.

For Adds the query is:
SELECT a.column1, a.column2
FROM as a
LEFT OUTER JOIN as b on b.column1 = a.column1 and b.rowisnew = 0
where b.column1 is null

For Deletes the query is:
SELECT a.column1, a.column2
FROM as a
LEFT OUTER JOIN as b on b.column1 = a.column1 and b.rowisnew = 1
WHERE b.column1 is null

For Changes the query is:
SELECT a.column1 AS OLDCODE, a.column2 AS OLDSUP, b.column1 AS NEWCODE, b.column2 AS NEWSUP
FROM as a
LEFT OUTER JOIN as b on b.column1 = a.column1
WHERE b.rowisnew = 1
and b.column2 != a.column2
and a.rowisnew = 0

This example is to capture changes made on HRSUPER where column0 is Company, column1 is Supervisor Code and column 2 is the Employee attached to the code.

So, Jeff, are you querying the actual database, not the SN tables themselves? Or can you point out which tables you are pulling from?

I am querying the the Infoset created when you perform an update infoset in SN. I am not sure what SN tables you are referring to.

In your queries you have "select xxx from"

I'm looking for what specifically you are using as the from db/table that is not in your syntax.

The From would be the infoset name like infoset_1000 or whatever number is assigned to that infoset. Once assigned it won't change. I have a variable there which is why it didn't translate so I can run this in either Production or Test and it picks up the correct infoset name. The Left Outer Join is actual joining to the same Infoset just the other Rowisnew value.