Rank: Newbie
Groups: Registered
Joined: 12/3/2021(UTC) Posts: 6  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.pnghow to used {InputValue_<workdate>} thank you Edited by user Friday, December 10, 2021 12:55:28 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 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.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 12/3/2021(UTC) Posts: 6 Location: TOUCHEN
|
OK thank you your answers
|
|
|
|
|
|
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.
