Real Estate - Matching Properties List - can not Unlink property

[tarektoubia]

Dear All,

I recently upgraded Espo 8.4.2 and Real Estate extension 1.8.1 to Espo 9.0.1 and Real Estate extension 1.8.3.

Everything is working fine and when I create a Request, I get the matching properties correctly.

However, to unlink some properties which are not needed, I click on View List to see the full list.



When I choose the property and click UNLINK in Actions, I get error 500.




The logs shows the below :

ALERT: (0) Entity 'RealEstateRequest' has not relation 'matchingProperties'. :: DELETE /RealEstateRequest/67964fffed9194573/matchingProperties :: /home/xxxxx/crm/application/Espo/Core/Record/Service.php(1137)

I tried the online demo of EspoCrm and it showed the same error.

I tried to create a Relationship link between the request and property (many-to-many) but the issue persisted.

I tried to revert to Espo 8.4.2 and RE 1.8.1 but the issue persisted.

I checked the Database table (real_estate_property_real_estate_request) related to Requests and it only contained old records, probably created with Espo 8.4 and RE 1.8.0.

If I click on Remove in the Actions list, the property is deleted from the system which is not what I want.

Any ideas if there is a workaround for this issue.?

Regards

[yuri]

Hi, I think there was no such an ability. The only issue that the action is available in the View List modal. The extension was created way before the View List modal appeared in Espo.

A Pull Request hiding non-working actions would be appreciated, if anyone will.

[tarektoubia]

Dear yuri,

Let's say I need to add such ability to Matching properties and I want to add another button to the drop down list in the LIST view.

Using the below link:

https://docs.espocrm.com/development/custom-buttons/#mass-action-in-list-view

I was able to add the button to the dropdown but How can I get the IDs of the selected records in order to perform an action?

I read about "getSelected()" function but I am not able to get it to work. I don't seem to find the right way. I would appreciate any help.


In detail view, I was able to create successfully the button with action.

Thank you in advance for your support.

Regards

[yuri]

Hi,

Do you need an action to unlink matching properties. The problem that it's not a relationship, the list is formed dynamically in the backend.

There's the ability to mark a specific match as not interested. It serves the similar purpose.



Regarding your question about coding. Unfortunately, I'm busy with work. I would need to look into code.

[tarektoubia]

Dear yuri,

Thank you for your time. Nothing is urgent.

I noticed the "Not interested" option, it is useful, but my aim is different. I need to keep only the needed properties in the list.

All the listings are syncing to a website through XML. Each property has an internal private ID (different from ESPO ID).
On the Real estate website, the listing can be accessed by https://www.xxxx.com/?propid=PRIVATE-ID.

I have added "Send by Whatsapp" which works in Detail View, it gets the private ID of the property and add the Website link, and it is working perfectly.
Also the Print to PDF is working perfectly using a template, but It is better to drive traffic to our website instead of sending PDF.

But in the matching properties page, I need to get the IDs of the listings Checked (I think I can use [find('input.record-checkbox:checked')]), then for each ID, I get the internal ID, and build the public links and send them via Whatsapp. Maybe I can also activate the UNLINK feature by sending an API request to delete the record from the list.





I will try from my side to work on it, and I will be waiting for your support whenever you have time.

Regards

[yuri]

I'd consider adding a primary filter. Then, only valid matches would show if the filter is applied. I'd try to add it when get a chance.