Hi
A sysQueryForm is not filtering by a field correctly. This field is from a different table that has been joined after modifying the sysquery.
How to add two different tables as a data source of a query object and filter by the field of the joined table on a sys query form?
*This post is locked for comments
Thanks for the response. The issue was resolved using the SysQuery:findOrCreateRange method.
Can you show us your complete code? And if it's not visible in your code, please tell us what datasource exist in the query.
For example, I wonder why you search for a ProjPostedTransTable datasource if you've just created it.
If there is no other datasource for ProjPostedTransTable, then you can simply refer to qbdsProjPostedTrans variable. And you can throw away all the code dealing with ranges, because there are no ranges to iterate. You would have to add some first, which you didn't. If you want to add some ranges, you'll have to fix your logic.
Or your query already contains another DS for ProjPostedTransTable and your code may be filtering the other DS (which you didn't even mention so far).
Thanks for the quick response! Hmm I tried the above but it doesn't output any records in the table though the table contains records with the matching category id. Not sure why its not outputting any record. Hope to hear from you soon.
Hmm I tried the above but it doesn't output any records in the table though the table contains records with the matching category id. Not sure why its not outputting any record. Hope to hear from you soon.
Hi !
If you want to join ProjPostedTransTable to ProjTable you should add new DS to qbdsProject instead of _qbdsHeader.
qbdsProjPostedTrans = qbdsProject.addDataSource(tableNum(ProjPostedTransTable));
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (