When working in Advanced Portal Designer templates, these are the special tags that can be used. A special tag is specified with question marks, like this example:
<?action('CustomerCard',Customer)?>
This example will add a link into the page to open the CustomerCard action, and pass the Customer table as a parameter. You can activate intellisense with Ctrl-Space in the template to have the editor help you find the right tags and their parameters.
Tag | Short title | Function | Returns into the file | Parameter 1 | Parameter 2 | Parameter 3 | Parameter 4 |
action | Insert URL for action | Insert URL for action | Action URL | Action | Table | ||
add | Legacy add | Add a value to a field | Added value | Table | Field | Value to add | Format string (optional) |
apd | Get the path of the webapp | Get the path of the webapp for APD | Return webapp path from APD setup | ||||
auth | IF authenticated | Allow block if user is authenticated, encapsulate with <?endif?> | |||||
auth0link | Link for Auth0 login | Construct link for Auth0 login page | Login Link | ||||
auth0logoutlink | Link for Auth0 logout | Construct link for Auth0 logout page | Logout link | ||||
calc | Calculates an expression | Calculates an expression | Calculation result | Formular | Decimal format string (optional) | ||
calcdate | Calculates a date | Calculates a date | Calculated date | Date formular | starting date (expression) (optional) | Date format string (optional) | |
caption | Get caption from a field | Get caption from a field | Field caption | Table | Field | ||
close | Close a table | Close a table | Table | ||||
codeunit | Call codeunit | Call into a codeunit and return output directly in page | Codeunit text output | Codeunit No. | Parameter 1 passed to codeunit | Parameter 2 passed to codeunit | Parameter 3 passed to codeunit |
company | User APD Company | Get the current APD Company | Company ID (APD, not BC) | ||||
companyname | Company Name | Gets the current BC Company Name | BC Company Name | ||||
count | Get number of records | Get number of records in table | Record count | Table | |||
edit | Edit field | Add a edit form field linked to a BC field with validation | Edit field control | Table | Field | ||
else | Else clause | Else clause in <?if?> statement | |||||
endif | End of <?if?> statement | End of <?if?> statement | |||||
endloop | End of <?loop()?> block | End of <?loop()?> block | Table | Step count 1=1 row forward -1=1 row backwards |
|||
field | Get the value of a field | Get the value of a field | Field value | Table | Field | Format string (optional) | |
fieldname | Field name | Return a field name | Field name, if specified ‘SQL’ as second parameter, the name is sanitized | Table | Field | SQL (optional) | |
filter | Apply a filter to a table | Apply a filter to a table | Table | Field | Filter string | ||
findlast | Find last record | Find the last record with the current filters | Table | ||||
get | Gets a record from a table | Gets a record from a table | Table | Primary key 1 field value | Primary key 2 field value | Primary key 3 field value | |
hidden | Hidden form field | Add a hidden form field | Hidden form field | Table | Field | ||
if | IF logic expression | Allow block if logic test is true, ecapulate with <?endif?> or <?else?> | Table (specify 0 if testing parameters) | Field or COUNT or EMPTY If table = 0, parameter expression. |
Logic operator: ‘=’ Equal ‘<‘ Lessthan ‘>’ GreaterThan ‘<=’ LessEqual ‘>=’ GreaterEqual ‘<>’ Different (Must be in single quotes) |
Comparison value (Expression) | |
indent | Indentation spaces | Create indentation space | number of spaces (emsp;) | Number of spaces (expression) | |||
init | Legacy Init | Legacy function, insert link to javascript library | |||||
key | Build key string | Build a key string for record | Key string | Table | Source (optional) 1 = Table 2 = Query string fields |
||
loginerror | Last error encountered | Last error encountered | Error text | ||||
loginok | URL for accepted login | URL for accepted login | Redirect URL after approved login. | ||||
logout | Logout the current session | Logout the current session | |||||
lookup | Lookup button for a edit | Create a lookup button for a edit field | HTML lookup button | (Legacy function) | |||
loop | Loop of table | Start loop of table, block is encapsulated with <?endloop?> | Table | Starting position: ‘-‘ = First ‘+’ = Last |
|||
loopend | End of <?loop()?> block | End of <?loop()?> block | Table | Step count 1=1 row forward -1=1 row backwards |
|||
loopno | Current loop number | Return the current loop number, often used for line numbering | Loop number | Table | |||
mimetype | Set the mime type | Set the mime type of page | New MimeType | ||||
new | Initialize a new record | Initialize a new record | Table | ||||
next | Link for next page | Create link for next page | Next page link (<a>) | Table | Step count 1=1 row forward -1=1 row backwards |
||
no | User BC number | The BC number of the logged-in user (example: customer number) | BC Number | ||||
open | Open table | Open table | Open a table for use (same as the <?table()?> tag | Table | |||
options | Legacy options | Legacy function for option field values select | |||||
pageno | Current page number | Get current page number for a table | Page number | Table | Page Size | Step count (same as on <?endloop()?> | |
pages | Page count for table | Get the maximum pages for a table | Total page count | Table | Page Size | ||
parm | Parameter value | Get the value of a parameter | Parameter value | Parameter name (from querystring or post data) | |||
prev | Link previous page | Create link for previous page | Previous page link (<a>) | Table | Step count 1=1 row forward -1=1 row backwards |
||
profile | IF security profile | Allow block if user has security profile, encapsulate with <?endif?> | Profile | ||||
profiles | IF multiple security profiles | Allow block if user has multiple security profiles, encapsulate with <?endif?> | Profiles as BC filter | ||||
raw | Raw field value | Get the value of a field as a raw value (no localization of dates etc) | Raw value, escaped | Table | Field | Format string (optional) | |
rawhtml | Field value as raw HTML | Get the value of a field as raw HTML | Field value in raw html (Typically used if field contants HTML), content will not be escaped (Injection possible) | Table | Field | Format string (optional) | |
rawselect | Legacy select control | ||||||
report | Legacy report | Legacy function, embed output of report as html | Return webapp path from APD setup | ||||
row | IF row is even | Allow block if row number is even, encapsulate with <?endif?> | Table | ||||
security | Verify that a user has a security profile | Verify that a user has a security profile | (Legacy function) | ||||
select | Legacy select control | ||||||
select2 | Legacy select control | ||||||
sessionid | Current SessionID | Gets the current SessionID | SessionID | ||||
set | Set parameter value | Sets a “parm” parameter value | Parameter | Value (expression) | |||
setkey | Set table sorting | Set the sorting for a opened table | Table | ||||
show | Read only field | Add a edit field in read only mode | Read-only field control | Table | Field | ||
super | IF Super user | Allow block if user is marked “Super User” on APD user card, encapsulate with <?endif?> | |||||
table | Open table | Open table | Open a table for use (same as the <?open()?> tag | Table | |||
tablename | Table name | Returns the table name | table name, if specified ‘SQL’ as second parameter, the name is sanitized | Table | SQL (optional) | ||
time | Get the current time | Get the current time | Current time | Time formatting string(optional) | |||
today | Get todays date | Get todays date | Today’s date | Date formatting string (optional) | |||
upload | File upload structure | Creates an file upload structure | HTML Form with upload field | Action | Additional parameter to upload actions (parm=value&parm2=value format) | ||
userid | Current User | Gets the current User | User ID (APD User, not BC) | ||||
usertype | IF user type | Allow block if user is specific type, encapsulate with <?endif?> | User type: 1=Customer 2=Vendor =Contact 4=Salespeople |
||||
wsfn | Get the path of the webapp | Get the path of the webapp for APD |