logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Benbabu  
#1 Posted : Thursday, November 21, 2019 11:03:51 AM(UTC)
Benbabu

Rank: Advanced Member

Groups: Registered
Joined: 8/9/2019(UTC)
Posts: 45
India

Thanks: 13 times
Hi Eric,
I'm trying to impact a cell using a prompt restriction "FROMDATE" in the Model.

Basically, I need to show Amount for "SELECTED_DATE - 1 DAY" .
I've tried employing {CommonRestriction_FROMDATE} and {CommonValue_FROMDATE} for this; but I'm getting nowhere.

This is what I have employed in the CustomSQL for Amount field:
Code:
case when to_char(business_date-1,'dd-mm-yy') in ({CommonRestriction_FROMDATE}) then Sum(BALANCE) end


And this is what's showing in the ReportSQL :
Code:
case when to_char(business_date-1,'dd-mm-yy') in (1=1) then Sum(BALANCE) end



I have also tried creating Report Init Value: FROMDATE
But again, no luck.

Please help!

Edited by user Thursday, November 21, 2019 11:05:22 AM(UTC)  | Reason: Not specified

epf  
#2 Posted : Thursday, November 21, 2019 4:28:46 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
Yes, it appears that Elements SQL (and custom SQL as well) are not handled to determine the Common Restrictions and Values...
This will be enhanced in the 5.1

In your case it will be a {CommonValue_FROMDATE} as {CommonRestriction_FROMDATE} will also inject the column name in the SQL...



Benbabu  
#3 Posted : Monday, November 25, 2019 3:57:25 AM(UTC)
Benbabu

Rank: Advanced Member

Groups: Registered
Joined: 8/9/2019(UTC)
Posts: 45
India

Thanks: 13 times
ok, thanks Eric.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.