0

Sample printTable with Filter Criteria

Somethin don't work in this script on the botton.

When change the criteria, and press the button It doesn't show me the selected criteria, but when click again yes it show me the criteria.

do as server
    let x := 'Date Start';
    let y := 'Date Finish';
    (select 'AUDIT Plan').('To Print' := false);
    for i in select 'AUDIT Plan' where 'RE-Schedule Date' >= x and 'RE-Schedule Date' <= y do
        i.('To Print' := true)
    end
end;
printTable("Audit Plan", "Print Re-Schedule Audits")

7 replies

null
    • Mel_Charles
    • 7 mths agoTue, August 27, 2024 at 7:32 PM UTC
    • Reported - view

    I copied your script created your data/info

    Had no issue with the button itself but it just ignored the script to update "to Print" until I changed false and true to 1 and 2. then had no issue.

    do as server
    let x := 'Date Start';
    let y := 'Date Finish';
    (select 'AUDIT Plan').('To Print' := 1);
    for i in select 'AUDIT Plan' where 'RE-Schedule Date' >= x and 'RE-Schedule Date' <= y do
        i.('To Print' := 2)
    end
end;
printTable("Audit Plan", "Print Re-Schedule Audits")
      • Rafael Sanchis
      • Rafael_Sanchis
      • 7 mths agoTue, August 27, 2024 at 8:07 PM UTC
      • Reported - view

       

      Thanks Mel, I already saw the problem in Web Cloud it works, but not in App. 馃様 I usually work more in App than in Web.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 7 mths agoWed, August 28, 2024 at 7:26 AM UTC
      • Reported - view

       Hi Mel

      I spoke ahead of time. It doesn't work in app or public web. 馃槥

      • Rafael Sanchis
      • Rafael_Sanchis
      • 7 mths agoWed, August 28, 2024 at 10:19 AM UTC
      • Reported - view

       

      Ok find the solution, now yes work. Simple eliminate the do as server

      let x := 'Date Start';
let y := 'Date Finish';
(select 'AUDIT Plan').('To Print' := false);
for i in select 'AUDIT Plan' where 'RE-Schedule Date' >= x and 'RE-Schedule Date' <= y do
    i.('To Print' := true)
end;
printTable("Audit Plan", "Print Re-Schedule Audits")
      • Mel_Charles
      • 7 mths agoWed, August 28, 2024 at 4:03 PM UTC
      • Reported - view

       Don't you just love all those little Ninox Quirks 馃槃

      • Rafael Sanchis
      • Rafael_Sanchis
      • 7 mths agoWed, August 28, 2024 at 4:06 PM UTC
      • Reported - view

       馃

      • Mel_Charles
      • 7 mths agoWed, August 28, 2024 at 4:09 PM UTC
      • Reported - view

       Just to conifirmm - works on cloud(web) perfectly too.

Login to reply

Content aside

Categories

View all topics
  • 7 mths agoWed, August 28, 2024 at 4:09 PM UTCLast active
  • 7Replies
  • 66Views
  • 3 Following