Attempt to retrieve the parent ID through a web service query - DoSelect

[Felipe Nunes]

Hi everyone, 

I am trying to retrieve the hier_parent and hier_child through a web service query.
When I execute the DOSELECT method using the following where clause:
parent=2AB2C52E288D8842A9158CFA9C4F0C60 and ci_rel_type=30007

I get the following error:
<ErrorMessage>Error fetching: AHD03053: Incorrect Where clause: Parse error at: "parent=2AB2C52E288D8842A9158CFA9C4F0C60 and ci_rel_type=30007" (Bad where clause)</ErrorMessage> as shown below:

However, if I use only ci_rel_type in the where clause, the value is returned correctly, as shown below:

Does anyone know what I am doing wrong in the where clause when I include the parent ID?

Thank you in advance for your help.

------------------------------
Regards,
Felipe Nunes
------------------
IT Analyst
Prodabel
------------------------------

[Felipe V]

Hi @Felipe Nunes,

You must use the follow wc code syntax:

parent=U'2AB2C52E288D8842A9158CFA9C4F0C60' and ci_rel_type=30007

------------------------------
Regards,
Felipe Vandrilho

Linkedin: https://www.linkedin.com/in/vandrilho/
------------------------------

[Felipe Nunes]

Hi @Felipe V,

It worked! I had forgotten that this syntax was also an option.
Thanks a lot for the support!

------------------------------
Regards,
Felipe Nunes
------------------
IT Analyst
Prodabel
------------------------------