search

reapit / foundations

Foundations platform mono repo
57 stars 21 forks source link

Property Status change table #10586

Closed elizabethhamlin closed 4 months ago

elizabethhamlin commented 6 months ago

Hi

The property status change table does not seem to function as it should.

For example, I want to be able to report on any properties that are classed as a relet so where there has been a tenancy on the property before. Therefore this would be any property status where it has changed from either provisional or tenancy current - unavailable to To Let - available or Tenancy Current - available. However the when using these filters it does not pull through the data. I have check some of the properties that should have appeared and they do not despite this entry being present -

image

Please can you let me know your thoughts?

plittlewood-rpt commented 6 months ago

Hi @elizabethhamlin the entry you mention above is showing in the PROPERTY_STATUS_CHANGES view. If you run the following query directly against Snowflake you'll see the row

SELECT * FROM PROPERTY_STATUS_CHANGES WHERE OLD_STATUS LIKE '%Tenancy Current - Unavailable%' AND NEW_STATUS LIKE '%Tenancy Current - Available' AND CHANGED_AT_DATE = '2024-01-05' AND _CUSTOMER_ID = 'LOC' ORDER BY CHANGED_AT_TIME

image

Are you able to give me a bit more information about the problem you're seeing?

github-actions[bot] commented 6 months ago

We have recently requested additional information relating to the issue you have raised. Please can you take the time to review this ticket and where applicable, provide the information requested. For more information on our processes, please click here

elizabethhamlin commented 5 months ago

Hi Pete

So this is what we have set up

[A screenshot of a computer Description automatically generated]

So anything that was tenancy current – available or To let – available or To let – unavailable that has changed to arranging tenancy – available or arranging tenancy – unavailable should appear but it doesn’t.

Here you can see the change logged in Reapit

@.***

But it does not appear in the data

Thanks

Lill

Elizabeth Hamlin MARLA Reporting and Systems Manager 07443 188920 @.**@.>

[Text Description automatically generated]

Lomond is a group of leading Lettings and Sales Agents across the UK. Lomond is the trading name of Chianti Holdings Ltd. Registered office address 70 St. Mary Axe, London, EC3A 8BE. Registered in England and Wales. Registered Company No. 13075482.

This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Lomond. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please contact the sender. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

From: Pete Littlewood @.> Sent: Thursday, January 18, 2024 8:17 AM To: reapit/foundations @.> Cc: Elizabeth Hamlin @.>; Mention @.> Subject: Re: [reapit/foundations] Property Status change table (Issue #10586)

You don't often get email from @.**@.>. Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification

Hi @elizabethhamlinhttps://github.com/elizabethhamlin the entry you mention above is showing in the PROPERTY_STATUS_CHANGES view. If you run the following query directly against Snowflake you'll see the row

SELECT * FROM PROPERTY_STATUS_CHANGES WHERE OLD_STATUS LIKE '%Tenancy Current - Unavailable%' AND NEW_STATUS LIKE '%Tenancy Current - Available' AND CHANGED_AT_DATE = '2024-01-05' AND _CUSTOMER_ID = 'LOC' ORDER BY CHANGED_AT_TIME

image.png (view on web)https://github.com/reapit/foundations/assets/30798627/3963f417-6241-4196-a2c6-3ee3d772f4ef

Are you able to give me a bit more information about the problem you're seeing?

— Reply to this email directly, view it on GitHubhttps://github.com/reapit/foundations/issues/10586#issuecomment-1897998664, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AY6KCUGD4HZGN5VQ74NM34TYPDK6LAVCNFSM6AAAAABB3MDFHCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOJXHE4TQNRWGQ. You are receiving this because you were mentioned.Message ID: @.**@.>>

plittlewood-rpt commented 5 months ago

Hi @elizabethhamlin all the image content has been stripped out. Please can you email this to sinfo@reapitfoundations.zendesk.com so I can take a look?

elizabethhamlin commented 5 months ago

Hi Pete Any update on this one? Thanks Lill

plittlewood-rpt commented 5 months ago

Hi @elizabethhamlin did you ever send the detail over to Zendesk? Thanks

elizabethhamlin commented 5 months ago

Yes

Elizabeth Hamlin MARLA Reporting and Systems Manager 07443 188920 @.**@.>

[Text Description automatically generated]

Lomond is a group of leading Lettings and Sales Agents across the UK. Lomond is the trading name of Chianti Holdings Ltd. Registered office address 70 St. Mary Axe, London, EC3A 8BE. Registered in England and Wales. Registered Company No. 13075482.

This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Lomond. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please contact the sender. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

From: Pete Littlewood @.> Sent: Friday, January 26, 2024 3:01 PM To: reapit/foundations @.> Cc: Elizabeth Hamlin @.>; Mention @.> Subject: Re: [reapit/foundations] Property Status change table (Issue #10586)

You don't often get email from @.**@.>. Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification

Hi @elizabethhamlinhttps://github.com/elizabethhamlin did you ever send the detail over to Zendesk? Thanks

— Reply to this email directly, view it on GitHubhttps://github.com/reapit/foundations/issues/10586#issuecomment-1912208649, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AY6KCUBWA5WMXW7CCNFKX5TYQPAJZAVCNFSM6AAAAABB3MDFHCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMJSGIYDQNRUHE. You are receiving this because you were mentioned.Message ID: @.**@.>>

plittlewood-rpt commented 4 months ago

Closing as per zendesk ticket. Glad you got this sorted. Thanks

github-actions[bot] commented 4 months ago

It looks like you have commented on a closed issue. If your comment relates to a bug or feature request, please open a new issue, and include this issue number/url for reference. For more information on our processes, please click here