JS entity get and load fail but create and save work

quentinm9832912

08-06-2020

Hi everyone,

I use  NLWS.nmsRecipient.get(id); and NLWS.nmsRecipient.load(id); in order to retrieve some data but there is always errors when i do it on nmsRecipient

QUE-370014 Erreur lors de la génération de la requête (sur un document de type 'Destinataires (nms:recipient)').

But when i make a create + save on nmsRecipient it works perfectly. 

According to another error also raised, i understand that the issue probably come from nmsRecipient schema extension but i don't understand why exactly .

 XTK-170036 Impossible d'analyser l'expression '@RepBranch-id'.

 

Does someone know how to deal with that ? 

Thank you,

Quentin, 

 

View Entire Topic

Jyoti_Y

MVP

10-06-2020

Hi,

 

Your join is not properly created.

You are getting error related to RepBranch foreign key not present in Recipient Schema.

Can you check definition of Recipient Schema( Preview tab) and verify whether @RepBranch-id column is created or not.

If not, please specify specific join condition between two tables. They are not able to join with primary key.

 

Thanks,

Jyoti