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