Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

appidDatetime CompletedDate On/Before/After
1232018-01-01 09:38:00Before
3212018-04-20 15:01:00On
4562018-09-30 07:19:00After
789
N/A

Step 7: "Formatting"

Info
titleMap Report Links

If you are planning on creating a Map Report and want to include a link to the application, since the link builder is not available in the Map Report type, you will need to add a link column to the dataset. The link to an application follows a set formula: "https://onegov.site.com/view.php?id=###" where the ### is the UID of the application. 

On the Formatting step, use the Concatenate operation to build the link.

The first box of the Concatenate operation will use the Manual Entry box to enter the whole link without the UID at the end (https://onegov.site.com/view.php?id=) and the second box will be the appid (Called UID on the dashabord of the site) field from the main table (PermitApps or AppValuesByTypeId/XX). 

When you preview the application, you should see a column for the link that has a fully functioning link to the application in question. Try copying and pasting the link into your browser to test that it is working properly.


OperationUseRequirementsOperation Format
CoalesceReturns the value of the first field in the listing that isn't null/emptyTwo or more fields

ConcatenateReturns two or more fields formatted together as one fieldOne or more fields

CurrencyReturns a number formatted as a dollar valueA field containing a numeric value

Date FormatReturns the date provided in a format specified in the formulaA field containing date data

Date OnlyReturns only the date portion of a datetime fieldA field containing a date

Date PartReturns a portion of the provided date as specified in the formulaA field containing a date

Epoch to DatetimeReturns a datetime value converted from an epoch value(the number of seconds since January 1, 1970 not counting leap seconds)A field containing a numeric value (Must be an epoch value to function correctly)

JoinReturns a listing of values associated with a single value (Explained below)A field and a separator value (space, comma, semi-colon, etc.)

LeftmostReturns a number of the leftmost digits of a field as specified by the second value of the formulaAny field

NumberReturns a number field converted from a text datatypeA text field containing a number

RightmostReturns a number of the rightmost digits of a field as specified by the second value of the formulaAny field

Text to DateReturns a date field converted from a text datatypeA text field containing a date

Text to DatetimeReturns a datetime field converted from a text datatypeA text field containing a date

...

Click "Finish" to Save and exit from the dataset creation. 


Content by Label
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@1146e
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "dataset" and type = "page" and space = "GOV"
labelsdataset

...