How to create an object from SQL over Object Layer

Marek L over 1 year ago

I would like to create an object from SQL and would like to use object layer instead of using INSERT.

There is procedure QBM_PJobCreate_HOInsert which can be use but not sure how I can generate UID/XObjectKey?

I found function newid() but it's generating GUID without CCC in front - can I just concat it?

Is there function which create XObjectKey from table name and UID?

Is there other easier way of creating those objects by SQL?

Top Replies

Markus Weiss-Ehlers 11 months ago +3 verified

To answer your two questions:

-- Function to create a Module-GUID
dbo.qbm_fcvGuidtoTransfer(newid(),'CCC')

-- Function(s) to create an XObjectKey
-- Tables with one PK
dbo.qbm_fcvelementtoobjectkey1(…

0 Markus Weiss-Ehlers over 1 year ago

Why not using the object layer via PowerShell?

github.com/.../IdentityManager.PoSh
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 matthias richter 11 months ago

I have a custom M:N table. For each object in Person matching a condition, I need to create an entry in that table combined with a fixed value. (Or image that you want to directly assign a org to all persons). That statement shall be executed in all stages via transporter, as access to other stages is very limited for us and operating cannot be bothered to perform such tasks manually).

For that reason, it seems to feasible to make an INSERT-Statement via ObjectLayer. I do not need the events to be triggered, but would like to have UID and X-fields be set automatically.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

+1 Markus Weiss-Ehlers 11 months ago

To answer your two questions:

-- Function to create a Module-GUID
dbo.qbm_fcvGuidtoTransfer(newid(),'CCC')

-- Function(s) to create an XObjectKey
-- Tables with one PK
dbo.qbm_fcvelementtoobjectkey1('tablename','pk_columnname','pk_value')
-- Tables with two PK
dbo.qbm_fcvelementtoobjectkey2('tablename','pk_columnname1','pk_value1', 'tablename2','pk_columnname2','pk_value2')