• State Not Answered
  • Replies 2 replies
  • Subscribers 94 subscribers
  • Views 70 views
  • Users 0 members are here
Options
Related

Dynamic role condition

gary.lam
1 day ago

Dear Sirs

I try to put the following to the Dynamic role condition for just simple testing, however i have gotten the error 

Person.UID_Person in (select UID_Person from ADSAccount) 

The SQL statement in the field 'Condition' is not correct.

May i know what should i do next and are there any samples i can refer to ?

Thanks
Gary

Parents
  • 0 18 hours ago

    Hi Gary,

    To be clear, did you put in the exact statement above? Because generally you select the table the dynamic role is applying on in the 'selection boxes' and then only enter the 'where' part of the query.

    Also you'll want to specify what table the uid_person in your sub condition is being drawn from (THe ads account).

    So try,

    UID_Person in (select a.uid_person from ADSAccount a)

Reply
  • 0 18 hours ago

    Hi Gary,

    To be clear, did you put in the exact statement above? Because generally you select the table the dynamic role is applying on in the 'selection boxes' and then only enter the 'where' part of the query.

    Also you'll want to specify what table the uid_person in your sub condition is being drawn from (THe ads account).

    So try,

    UID_Person in (select a.uid_person from ADSAccount a)

Children
No Data