• Locked Locked
  • Replies 4 replies
  • Subscribers 96 subscribers
  • Views 5048 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

whereClause parameter in process Orchestration.

subash sukumaran
over 6 years ago

Hi All,

I have a custom process to export identities from the Person table under dialogue database in the process Orchestration.

There is already a whereClause parameter in my implementation. Please see below.


Dim f As ISqlFormatter = Connection.SqlFormatter

Value = f.AndRelation( _

f.Comparison("IsDummyPerson", False, ValType.Bool, CompareOperator.Equal), _

f.Comparison("IsInActive", False, ValType.Bool, CompareOperator.Equal), _

f.Comparison("IsExternal", False, ValType.Bool, CompareOperator.Equal))


I Would like to add an additional filter into this whereClause. The requirement is the export should ignore identities who do not have an ADS Account.


We have to export only person object who has a managed AD account.

Please let me know, how to add this filter into this whereClause.

Regards,

Subash

Parents
  • over 6 years ago

    Hi Subash,

    You can try ANDing in a where clause like the following to select only those Person rows which have a managed ADSAccount:

    ( uid_person in (select ads.uid_person from ADSAccount ads where ads.uid_person is not null and ads.uid_tsbbehavior is not null))

    hth,

    Rob.

  • over 6 years ago in reply to Robert Byrne

    Hi Robert,

    Thanks for your reply.

    The filter that you have provided is correct, but do you have any idea how we can include this filter into the below code. The export process should qualify for the below conditions also.

    Dim f As ISqlFormatter = Connection.SqlFormatter

    Value = f.AndRelation( _

    f.Comparison("IsDummyPerson", False, ValType.Bool, CompareOperator.Equal), _

    f.Comparison("IsInActive", False, ValType.Bool, CompareOperator.Equal), _

    f.Comparison("IsExternal", False, ValType.Bool, CompareOperator.Equal))

    Regards,

  • over 6 years ago in reply to subash sukumaran

    Hi Subash,

    You can just add a string parameter to the AndRelation() method as below. 

    Here's a hint: In Designer go the search bar in the program Menu bar and type ISqlFormatter.  You will find over a 100 scripts that use that type...so there are many examples to choose from.  That's a trick that helps in general when we are looking for hints on how to use any of the the API calls--the best documentation in fact for the API is the product's own usage of it.

    hth,

    Rob.

    Dim f As ISqlFormatter = Connection.SqlFormatter

    Value = f.AndRelation( _

    f.Comparison("IsDummyPerson", False, ValType.Bool, CompareOperator.Equal), _

    f.Comparison("IsInActive", False, ValType.Bool, CompareOperator.Equal), _

    f.Comparison("IsExternal", False, ValType.Bool, CompareOperator.Equal), _

    "( uid_person in (select ads.uid_person from ADSAccount ads where ads.uid_person is not null and ads.uid_tsbbehavior is not null))" _

    )

Reply
  • over 6 years ago in reply to subash sukumaran

    Hi Subash,

    You can just add a string parameter to the AndRelation() method as below. 

    Here's a hint: In Designer go the search bar in the program Menu bar and type ISqlFormatter.  You will find over a 100 scripts that use that type...so there are many examples to choose from.  That's a trick that helps in general when we are looking for hints on how to use any of the the API calls--the best documentation in fact for the API is the product's own usage of it.

    hth,

    Rob.

    Dim f As ISqlFormatter = Connection.SqlFormatter

    Value = f.AndRelation( _

    f.Comparison("IsDummyPerson", False, ValType.Bool, CompareOperator.Equal), _

    f.Comparison("IsInActive", False, ValType.Bool, CompareOperator.Equal), _

    f.Comparison("IsExternal", False, ValType.Bool, CompareOperator.Equal), _

    "( uid_person in (select ads.uid_person from ADSAccount ads where ads.uid_person is not null and ads.uid_tsbbehavior is not null))" _

    )

Children