CUPS/CUPC : externalcontact on CUPC

[Christophe NICOLAS]

hello

I have CUPC 8.5 with CUPS 8.6(4) I've created a external contact from my CUPC userid 789456 ( i.e : 123456 pizza ) into a group named ' personal contact'.

Now from the CLI CUPS server I would like found with the sql queries ( run sql select .... etc ) my contact'

123456 pizza' into the group named  ' personal contact'.

I used the following sql queries without any sucess the result is blank !

run sql select pkid,userid from enduser where  userid like '%307%'

pkid                                   userid    

==================================== ==========

0a239318-9a9a-9ac0-4b77-612b28e1f9bb  789456

and

run sql select * from epascontactgroup where fkenduser ='0a239318-9a9a-9ac0-4b77-612b28e1f9bb'

pkid fkenduser name index isdefault

==== ========= ==== ===== =========

if a person  know the exactly the sql queries I takes !!

Many thanks for your help

Regards,

Christophe NICOLAS

[Christophe NICOLAS]

sorry the good request is

run sql select pkid,userid from enduser where  userid like '%789%'

pkid                                   userid    

==================================== ==========

0a239318-9a9a-9ac0-4b77-612b28e1f9bb  789456