JScript Helpers and Functions

Emre posted some script to help with password as hashed, pin shouldn’t be to hard is not.

That’s a good shout. So these wouldn’t be available by gql?

No but there are some gql ones that do same thing. They are documented

1 Like

Its probably going to be a hefty automation update so think I’m going to have to update setup offline and switch to a fresh db on live day to avoid issues with rule sorting etc as some is new and some is updated. Will get messy very quickly and window for switch isn’t long plus will be stocktake day (to avoid split reports).
The girls have claimed the occasional slow down. While update and autoresize may resolve a fresh history won’t hurt and will keep old db.
Know closing work period with backup switched on is beginning to take a noticably longer time than it used to.

Backups seem to happen faster if you use MSSMS instead.

1 Like

Yet, have been thinking about changing to that.
Do you just have it to schedule backup on SQL itself.

I use Windows schedular to run it myself.

1 Like

It generates a different file right? The backup wouldn’t restore within samba and Visa versa without unzipping. Never needed to check but guessing there is a normal SQL backup inside the samba generated zip?

It creates the same file it’s not not compressed already like Sambapos does

1 Like

is it possible to use in some way report template in script ?
looks like it {CALL:X({REPORT CONSUMPTION DETAILS:X})}

Yes you can do that.

1 Like

Hey @bezdelmax
Here an example where I create an A4 doc with the idea to email to suppliers:

\r
\r

{REPORT ENTITY DETAILS:[EC.Company Name] + '\r',EC.Address,EC.Email:(EN=$1):{0}\r{1}\r{2}:::}

[PURCHASE ORDER:2, 1]
>Stock Description|Date
{CALL:Strip.Text("{REPORT ENTITY DETAILS:EC.Orders:(EN=$1)}","~","\r")}

It basically shows how extensible Emre’s code was…
Enjoy Paul.

1 Like

why is this not working for me?

Report tags may not work from there. You would need to try it in a rule.

Is that a valid report tag?

Yeah so you may need to try it in a rule.

don’t work

Use double quotes around it not single. “blah”

2 Likes