Finance | Project Operations, Human Resources, ...

InActive addresses not appearing in my report

(1) Share

Report

Posted on by CU22120935-0

252

Hi,

I created a query with two tables: TableZ and LogisticsPostalAddress.
The relation between those tables is TableZ.PostalAddress=LogisticsPostalAddress.RecId

this query is being used in a report, and the address is appearing on the report.
However, when i deactivate the address, the address field in the report becomes empty, even though TableZ.PostalAddress is still filled. How to make it appear even though it's inactive?

I think it's maybe because logisticsPostalAddress is a validTimeState table?

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Yes, i think the issue is due the valid date time in table LogisticsPostalAddress.

If you want to see all records without limitation you need to use

query.validTimeStateDateRange(dateNull(), dateMax());

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes, you can do it in the RDP class to get all the records without limitation.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Waed Ayyad 9,214 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved?

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

for both are correct except that validTimeStateDateRange uses date and the other uses utcdatetime as type.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

You're right.

You can use validTimeStateDateTimeRange.

If you want to see all records without limitation you need to use Min DateTime & Max DateTime.

query.validTimeStateDateTimeRange(DateTimeUtil::minValue(), DateTimeUtil::maxValue())

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Waed Ayyad 9,214 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks
Waed Ayyad

Was this reply helpful? Yes No