5,901
Dear All,
I saw below code any many queries in for date range :
SysQuery::findOrCreateRange(this.queryBuildDataSource(),
fieldNum(ProdTable, FinishedDate)).value(SysQuery::range(12\01\2017, 12\31\2017);
Can you please let me know how it's work findOrCreateRange() in date range.
Please give me more shed on this.
Thanks!
Arpan
*This post is locked for comments
I agree with Sukrut as he said 'In that case value is going to be blank and the report will filter all data'.
and this is the benefit for create
Hi Sukrut,
As you mentioned class ""AssetBalanceReportColumnsDP" i go through that.
As i understand :
Picture 01:
Picture 02:
If User put values in Book then it came to DP class through Contarct class and value will stored in assetBookID.
then in findOrCreateRange(...).value(assetBookId) is passed.
So, here one thing is clear it will find range (findOrCreateRange()) based on value eg. assetBookId. i.e OK.
Note : Suppose if i NOT put value in Book in dialog.
Then how findOrCreateRange(...).Value( ??) will work ? (refer Pic 02)
This is my question.
Please give me more shed on this.
Thanks!
Arpan
The same as we explained above, because it doesn't matter where it is.
Use cross-references if you want to find examples in the standard application; you don't me to do it for you.
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 (