Hello community
Is it possible to query the Infobox LINK on my customers table? I would like to list my customers and the path (address) of the first document saved in LINK.
Thanks for your help.
Best regards,
daveadm
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello -
If you are using a "Universal" data source connector and the information you are wanting is listed in a database table, you should be able to access that information just as you would any other piece of data.
Likewise, if you are using a Dynamics NAV data source connector and that information is stored in a NAV table (i.e., a table that is accessible from within NAV itself), Jet Essentials should have access to that, as well.
Same story for Dynamics GP (if it's in a GP table, Essentials should be able to get to it). -
Jet Reports Historic Posts Hi Daveadm.
If you are using a NAV data source then the notes and memos are all stored in the Record Link table. You can filter on this table, but it can sometimes be challenging as all notes from all tables (customers, fixed assets, etc) are stored here with a prefix of what table it belongs to so when filtering you have to include this in the filter for Record ID.
Also, if you are returning the field "Note" then you would need to use a Binary Text type.
=NL("BinaryText","Record Link","Note")
Hope this helps.
Please sign in to leave a comment.