Getting master data from its details

[Lucas Lopes]

Hi, everyone!

I want to create an HTML page where I can search by a field called "Document" from a detail table, and retrieve the corresponding "Sale" field from its master record.

The "Document" field is in a detail item, and "Sale" is in the master item of that detail.

How can I search by the detail and return a field from the master using Jam.py?

[Dean D. Babic]

Sorry, v5 is out of support. You'll need to upgrade.

[Ari Sobel]

Fala Lucas, Brasil?

It's a good recomendation to upgrade to v7.

Meanwhile, see the below code, from the documentation, you can handle details changes for Master interactiosn:

https://jam-py.com/docs/refs/client/item/on_detail_changed.html#on-detail-changed

regards

Ari

--
You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/jam-py/6ed34e3f-4883-45ba-8364-210b52fd3fa7n%40googlegroups.com.

[Dean D. Babic]

Actually, 

this is exactly how Demo was built. The Detail has items from Tracks, so your Document should be a part of some other table.

Then, the Master is Invoice table, with Details. 

The Tracks can find the Invoice:
https://jampyapp.pythonanywhere.com/

I think for v7 Demo, we need to change this behavior to match v5. 

On Monday, June 30, 2025 at 11:00:53 PM UTC+8 Lucas Lopes wrote:

[Dean D. Babic]

I implemented Tracks/Invoices on v7, as on v5 demo in here:

https://jampy.pythonanywhere.com/

I think we have a bug with 7.0.58 for Details, my suggestion is to use 7.0.53 for now.

D.

[Ari Sobel]

Thanks Drazen!

--
You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/jam-py/4fb58446-80c5-4e5f-bc61-f09be5767276n%40googlegroups.com.

[Dean D. Babic]

I released 7.0.60 with the bug fixed for Details.