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

Notification

Icon
Error

Options
Go to last post Go to first unread
jeffery89127405  
#1 Posted : Friday, December 10, 2021 12:50:23 AM(UTC)
jeffery89127405

Rank: Newbie

Groups: Registered
Joined: 12/3/2021(UTC)
Posts: 6
Taiwan, Province Of China
Location: TOUCHEN

i want to used inputvalue

sql is

select mod_no,zzatcolr,zzcolorcode,formulano,coalesce(sum(pro_qty),0)pro_qty
from (
select (case when a.ProductKind = 'HR' then b.ZZOUTSOLMOD else b.ZZMIDSOLMOD end)mod_no,
b.zzatcolr,b.zzcolorcode,b.zzformulanumber formulano,
coalesce((a.primaryquantity),0) pro_qty
from web_mes_soleprod a,mda_mat_cawn b
where a.plnbez = b.matnr
and a.productkind = {InputValue_<workdate>}
and a.act_workdate between '20190101' and '20211208'
and a.action = 'TrackOut'
and a.stepid = 'LNS'
and a.act_shift like 'PGS_IDsu_1stShift')c
group by mod_no,zzatcolr,zzcolorcode,formulano


https://pasteboard.co/1NGx3DRXKMrs.png
how to used {InputValue_<workdate>}
thank you

Edited by user Friday, December 10, 2021 12:55:28 AM(UTC)  | Reason: Not specified

epf  
#2 Posted : Friday, December 10, 2021 2:20:35 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 174 time(s) in 168 post(s)
You mismatch input values (https://sealreport.org/Reports#lineInputs) and common restrictions (https://sealreport.org/Sources#lineTables_cr)

In you case I would write:
Code:
and a.productkind = {InputValue_workdate}


Then if your model involves the table defined (or the SQL),
just edit the "Common restrictions and values' property, you will find your 'workdate' restriction.


jeffery89127405  
#3 Posted : Monday, December 13, 2021 2:16:49 AM(UTC)
jeffery89127405

Rank: Newbie

Groups: Registered
Joined: 12/3/2021(UTC)
Posts: 6
Taiwan, Province Of China
Location: TOUCHEN

OK thank you your answers
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.