Popular Tags

  • Why do I get error message "Unable to execute transition XX on XX. One or more fields are invalid" when a Shell.Redomessage should stop the transition?

    I have a transition that will Perform another transition from Actions, the second transition is a quick transition that runs a webservice. BUT as a Post-transition action on the quick transition we have an appscript that checks field values if it should…

  • What file extension are you using for ModScript (i.e. Chaiscript) files?

    What file extension are you using for ModScript (i.e. Chaiscript) files? I'm currently using ".chai". For AppScript I started using ".tsc" (i.e. "TeamScript") many years ago, along with ".tsl" for "Teamscript Library" files which are libraries of…

  • Obscure/advanced AppScript question .... deleting an item related to other items...

    We have 2 Primary tables with 3 different types of items: In primary table Shipping_Pkgs we have a " Shipping_Manifest " type item and a " Manifest_Line " type item. In the 2nd primary table (Envelopes) we have Envelope type items. The user creates…

  • Variable handling

    Variable handling I am programming a script in appscript. executes in an action in an SBM form. the execution ends in the execution of a .bat with parameters. The first inconvenience is the value of one of these variables (description,of type text), which…

  • In appscript, create variable [First initial][Lastname] from Submitter [Firstname Lastname]

    Maybe leftstring? What would the statement and the syntax be? Example: Phil Bustin becomes PBustin.

  • How an an appscript delete the first n lines and the last n lines of a memo field?

    I am submitting SBM items by adding a comment "@[mailbox]" in Jira, by mapping Body to Description in app admin > mailbox. The first several lines and last several lines in the resulting Description need to be deleted. Since the email submit transition…

  • RE: Can Appscript or Modscript read in External Files and attach them to items?

    Is this a one-time-only import? If so, it might be easier to create the attachment and attachment sequence records in SQL. Even though you've configured attachments to go into the database, I'm betting that you can put the file into the file system, create…

  • Can java or appscript test whether a string occurs once in a text field?

    I set a form action to show Field B if a text Field A contains a string. I would like to hide Field B if the string only occurs once in Field A. Can javascript or appscript accomplish this?

  • REST Grid on State Form...

    Hello All, I'm working on an Asset Management workflow in our SBM system and I'm faced with a rather interesting challenge. I need to pull in and display data on a stat forms from two different systems related to this process (Kaseya

  • 65535 characters limitation on Appscript

    Hi All, how do you workaround with the string length limitation (65535 characters) on Appscript? Thanks, Derek

  • Creating 500 main task and sub task on a go

    Hi All, I am now facing a problem to create 500 main task and sub task on one go in a transition. But since it involves multiple tables. 1. Main task table 2. Sub task table 3. TS_SUBTASKS 4. TS_NOTIFICATIONEVENTS (Not to mention data feed…

  • Performance Tuning on 1000 records reading at a time [Appscript]

    Hi All, I am just now facing a problem on reading 800-1000 records from a table with 40000 to 50000 taking about 20 secs, but which i can read it with less than 1 second using the SAME sql query as on the appscript on the db. Psuedo code as below…

  • Run bat file thru appscript

    Hi everyone, I'm trying to run a .bat file from appscript with the following command: sLog = sLog

  • Relational Field lookup?

    Hello All, I've got a change management workflow I'm working on. I'm creating a HTML formatted Audit log on the change. However, I want to create an automated rollback of these changes I imagine this being a "quick" transition so my intent is to use…

  • How to write logs into a file using appscript ?

    Hello Team, How to write logs into a file from appscript and also dynamically I want to create new log file when it reaches certain size. Is it possible ? please help me Thanks a lot for your help. Thanks Praneeth

  • How can I schedule a repeating notification to occur on the 1st...

    ...day of the month? Or is there a supported mechanism for creating and terminating notifications via AppScript (other than direct database manipulation)?

  • How to inculde image or jquery file in appscript ?

    Hello Team, In my application when your clicks on button I'm invoking a appscript, in appscript I'm displaying the data in a Html table. Here html code I'm writing inside the Call Ext.WriteStream("my html tags"), but if I want to include a Image or…

  • SQL query to perform pagination (Oracle, appscript) ?

    Hi Team, I want to perform the pagination in my application, we are using Oralce database. I have a function, for this function I pass the start and end row number dynamically but how to write SQL query to get the data between the range. whereClause…

  • How to make Http Post Request from javascript to appscript ?

    Hi Team, I'm trying to make Http Post Request from Javascript to appscript and I want to pass JSON Object with payload. Like below : var url = ("/tmtrack/tmtrack.dll?ScriptPage

  • Data is inserting as 0 even if give some value in table TS_SECURITYCONTROLS

    Hi, I'm trying to insert the data into the table TS_SECURITYCONTROLS from my appscript. But when I use below code data is inserting as 0's , it is not taking my values. In below code GroupID,roleID,prjctId are coming properly I printed on screen and tested…

  • Unable insert or update record in TS_GROUPS table ?

    I'm trying to insert or update the record inside the TS_GROUPS table from the appscrit. I have used below code to insert the data Set myRecord = Ext.CreateAppRecord (Ext.TableId("TS_GROUPS")) Call myRecord.SetFieldValue("TS_Name","Test") myLong…

  • Serena javascript methods AddLoadCallback,AddSubmitCallback are not working on update transition form

    Hi Guys, SBM javascript call back methods like AddLoadCallback,AddSubmitCallback are working fine when I create new item but these methods are not working on update transition form. could you please help me in this. My requirement is I want…

  • How to get Distinct records ReadWithWhere ?

    Hi Guys, could you please help me to get distinct record from database. whereClause4 = " TS_ID =" inputId Set tasks4 = Ext.CreateAppRecordList(Ext.TableId(" USR_SBG_Table")) Call tasks4.ReadWithWhere(whereClause4) For each task4 in tasks4 Call…

  • AppScript Multi-User Field and current user?

    Hello All, I'm trying to write an appscript to modify a multi-user field. Essentially I'm looking to set the script up so that a user can hit the quick transition button that calls this script, the script in turn should add that user to a multi-user…

  • AppScript VarFieldList independent from a table

    There's a section of the AppScript Guide definition for the VarFieldList object that has intrigued me for years: ... A VarFieldList is a list of Field objects representing the variable fields of a primary or auxiliary item. Note that Field is a subtype…

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.