All Users with Role Report Mapping

You can map DaaS data to the All Users with Role Textura report with the following prompt or query.

Suggested Prompt to use in Textura Reports

Show me users in my organization. Include their:

• Basic profile details (ID, first and last name, email, phone, alternate phone, fax, job title, role, active status)
• Account dates (date created, date modified, last login date)
• All permission flags and system roles (such as project manager, compliance manager, signer, invoice approver, disburser, enterprise disburser, owner funding manager, classified attachments manager, TPA manager, project creator, interfaces manager, all projects viewer, notary, and related notary details including state/province and expiration)

Also include all their project-level roles. For each project they are associated with, return:

• Whether they are an authorizer or parallel approver
• The project’s segment ID, project number, and name
• The owner contract organization details, including:
• Textura customer number
• Organization name
• Full address (address lines, city, state/province, postal code)
• Phone number
• Tax ID

Note:

• For more information on using prompts, see topic Creating a Report from a Prompt.
• The above prompt is a suggestion, your results may vary.

Query

query{
  user(organizationID:xxx, offset:0, next:1){
    id
    firstName
    lastName
    email
    isActive
    role
    jobTitle
    projectManager
    complianceManager
    signer
    invoiceApprover
    disburser
    enterpriseDisburser
    ownerFundingManager
    classifiedAttachmentsManager
    tpaManager
    projectCreator
    interfacesManager
    allProjectsViewer
    notary
    lastLoginDate
    dateCreated
    phone
    altPhone
    fax
    enterpriseDisburser
    notaryStateProvince
    notary
    notaryExpiration
    dateModified
    projectUserRoles{
      authorizer
      parallelApprover
      project{
        segmentID
        projectNumber
        name
        ownerContract{
          organization {
            texturaCustomerNumber
            name
            address1
            address2
            city
            stateProvince
            postalCode
            phone
            taxID
          }
        }
      }
    }
  }
}

Mapping Table

Note: If you copy text from a table cell for use in code, paste it as plain text to avoid copying typographic quotation marks or other formatting.

Use the table below to map report output column fields to DaaS fields. Note that cells with a DaaS Field of Not Applicable do not have a DaaS equivalent to an available report field.

Column Number	Report Column	DaaS Field
1	Last Name	user.lastName
2	First Name	user.firstName
3	User ID	user.id
4	Username	Not Applicable
5	Email	user.email
6	Status	user.isActive
7	Type	user.role
8	Title	user.jobTitle
9	PM	user.projectManager
10	CM	user.complianceManager
11	Signer	user.signer
12	Invoice Approver	user.invoiceApprover
13	Authorizer	projectUserRoles.Authorizer
14	Disburser	user.disburser
15	Enterprise Disburser	user.enterpriseDisburser
16	Owner Funding Manager	user.ownerFundingManager
17	Classified Attachments Manager	user.classifiedAttachmentsManager
18	EPP Manager	user.tpaManager
19	Project Creator	user.projectCreator
20	Interface Manager	user.interfacesManager
21	View All Org Projects	user.allProjectsViewer
22	Textura Analytics	Not Applicable
23	View Only	user.docWriterViewOnly
24	Publisher	user.docWriterPublisher
25	Editor	user.docWriterEditor
26	Notary	user.notary
27	Last Login	user.lastLoginDate
28	Date Created	user.dateCreated
29	Created By	Not Applicable
30	Last Deactivation Date	Not Applicable
31	Deactivated By	Not Applicable