Func60_CreateUpdateArtifact

<< Click to Display Table of Contents >>

Navigation:  Modules > Asset Management > Software License Management > Authorization Analyzer (Complex license types) > AA Functions >

Func60_CreateUpdateArtifact

Description

This function is used to update an existing artifact, or create the artifact in the case that it does not exist.  This function should not ever end a rule.  It always returns -1 and will not update the EUR.  This function will interpret tags.  The updated and created dates will be automatically populated.

 

Processing Notes

This function goes through the following steps:

Search the artifacts table for an existing artifact that matches the criteria provided

oIf the artifact exists, the artifacts is updated

oIf no artifact is found, it is created

 

Inputs

 

Parameter

Explanation

Type

Select a single artifact type from the drop down choices (required)

Source

Required for identification. Accepts tags, must resolve to Text field, 80 character limit

KeyChar

Required for identification. Accepts tags, must resolve to text field, 80 character limit

KeyInt

Required for identification.  Accepts tags, must resolve to integer > 0

ArtChar01

Accepts tags, must resolve to Text field, 250 character limit

ArtChar02

Accepts tags, must resolve to Text field, 250 character limit

ArtChar03

Accepts tags, must resolve to Text field, 250 character limit

ArtChar04

Accepts tags, must resolve to Text field, 250 character limit

ArtChar05

Accepts tags, must resolve to Text field, 250 character limit

ArtChar06

Accepts tags, must resolve to Text field, 250 character limit

ArtChar07

Accepts tags, must resolve to Text field, 250 character limit

ArtChar08

Accepts tags, must resolve to Text field, 250 character limit

ArtChar09

Accepts tags, must resolve to Text field, 250 character limit

ArtChar10

Accepts tags, must resolve to Text field, 250 character limit

Date01

Accepts tags, must resolve to SQL date

Date02

Accepts tags, must resolve to SQL date

Date03

Accepts tags, must resolve to SQL date

Date04

Accepts tags, must resolve to SQL date

Date05

Accepts tags, must resolve to SQL date

Date06

Accepts tags, must resolve to SQL date

Date07

Accepts tags, must resolve to SQL date

Date08

Accepts tags, must resolve to SQL date

Date09

Accepts tags, must resolve to SQL date

Date10

Accepts tags, must resolve to SQL date

Date11

Accepts tags, must resolve to SQL date

Date12

Accepts tags, must resolve to SQL date

ArtInt01

Accepts tags, must resolve to an integer

ArtInt02

Accepts tags, must resolve to an integer

ArtInt03

Accepts tags, must resolve to an integer

ArtInt04

Accepts tags, must resolve to an integer

ArtInt05

Accepts tags, must resolve to an integer

ArtInt06

Accepts tags, must resolve to an integer

ArtBigInt01

Accepts tags, must resolve to a big integer

InternalSourceID

Accepts tags, must resolve to an integer

ArtFloat01

Accepts tags, must resolve to a number

ArtFloat02

Accepts tags, must resolve to a number

ArtFloat03

Accepts tags, must resolve to a number

FullRecord

Accepts tags, Text field, nvarchar(max)

 

Outputs

 

Result

Result Explanation

Confidence Adjustment

Return Value

True

There was an artifact that was created or updated

N

-1

False

It is not possible to have a false result.

N/A

N/A

Else

The required information was not provided

A processing error was encountered

Y

-1