search by LastName

Q&A
1

I want to do search by LastName using filter in rest api but don’t work I have Rest Api like this one :
…/API/bdm/businessData/com.company.model.DemandesConges q=findByLastName&p=0&c=100&f=LastName=={{searchValueNom}}

this my requete :SELECT d FROM DemandesConges d
WHERE d.LastName= :LastName
ORDER BY d.persistenceId

persistenceId_string | filter:searchValueNom, idDemandeur | filter:searchValueNom, LastName | filter:searchValueNom, FirstName | filter:searchValueNom, nombreJours | filter:searchValueNom, dateDebut |date | filter:searchValueNom, dateFin | date | filter:searchValueNom, dateRetours |date | filter:searchValueNom, typeConge | filter:searchValueNom, motifConge | filter:searchValue, manager | filter:searchValueNom, estApprouveeLabel | filter:searchValueNom, solde | filter:searchValueNom, estApprouveeLabelSolde | filter:searchValueNom
searchByName
search

2

Hi,

It looks like there are two typos in the REST call. Is it only a copy/paste issue or is it the one you were using? In any case, here is what I would try:

…/API/bdm/businessData/com.company.model.DemandesConges?q=findByLastName&p=0&c=100&f=LastName={{searchValueNom}}

Cheers

3

same don’t work

4

Maybe you can export your diagram as a .bos file and share it so we can give it a try?

5

çi joint .bos file
https://www.dropbox.com/preview/DemandeConges-27.0.bos?role=personal

https://www.dropbox.com/preview/page-SuiviDemandesConges(4).zip?role=personal

https://www.dropbox.com/personal?preview=dmd.png

6

The link you shared are not publicly accessible. Can you please update them?

Thanks

7

https://www.dropbox.com/s/tsht6cxcgu32zyl/DemandeConges-27.0.bos?dl=0

https://www.dropbox.com/s/ofnhyiw838hmhro/page-SuiviDemandesConges(4).zip?dl=0

https://www.dropbox.com/s/nh5xjd2ienhqkgt/dmd.png?dl=0

8

what is the error !!