Data Source-Reference
  • 2 Minutes to read
  • Contributors

    Data Source-Reference


      Article summary

      An overview of data source reference

      After reading this article you will know:

      • What is a data source reference
      • How to create it

      The sole purpose of a data source-reference is to fetch data in to an application from the data source with selective Input fields and related Output fields.

      How to configure data source reference?

      NOTE
      To create a DS-Reference, you must have a data source. Learn to create a data source...
      • Once you have a data source ready, simply click on the data source to see the Actions & Adoption Types, as shown below.

      2(2)

      • Click on the "+" corresponding to the References option to start creating a data source reference.
      • On the Create Reference page, do the following configurations:
        • Give a name to the reference
        • Select an Add-on, if required, to diversify the data visualization.
        • Select an Input Field. The data field you specify here will be the primary identifier/condition for fetching the entire data record/selected output fields, in an app. However, the data fetching depends on the Condition Operators. 
          • Equal: This operator will fetch the relevant info of the selected input value.
          • Not-Equal: This operator will fetch the irrelevant info of the selected input value.
          • Greater Than: This operator will fetch the data of the input value which is greater in value to the selected input value (Number or Date) 
          • Less Than: This operator will fetch the data of the input value which is lesser in value to the selected input value (Number or Date) 
          • Greater Than or Equal To: This operator will fetch the data of the input value which is greater or equal in value to the selected input value (Number or Date) 
          • Less Than or Equal To: This operator will fetch the data of the input value which is lesser or equal in value to the selected input value (Number or Date)
      EXAMPLE
      Assume a data source in which we have a data record with data fields as Employee ID, Employee Name, Employee Email, Employee Phone Number.

      Employee ID (Input Field)Employee Name (Output Field)Employee Email (Output Field)Employee Phone Number (Output Field) 
      0011Xing Longxing@gmail.com9876785432
      0012Ramarama@gmail.com0989087654
      Case 1: Keeping the Conditional Operator as Equal, If you select the input value for Employee ID as 0011 the resultant output values will be relevant, as given below.

      Employee ID (Input Field)Employee Name (Output Field)Employee Email (Output Field)Employee Phone Number (Output Field)
      0011Xing Longxing@gmail.com9876785432
      Case 2: Keeping the Conditional Operator as Not-Equal, If you select the input value for Employee ID as 0011 the resultant output values will be irrelevant, as given below.

      Employee ID (Input Field)Employee Name (Output Field)Employee Email (Output Field)Employee Phone Number (Output Field)
      0011Ramarama@gmail.com0989087654
      Case 3: Keeping the Conditional Operator as Greater Than, If you select the input value for Employee ID as 0011 the resultant output values will be, as given below.

      Employee ID (Input Field)Employee Name (Output Field)Employee Email (Output Field)Employee Phone Number (Output Field)
      0012Ramarama@gmail.com0989087654
      Case 4: Keeping the Conditional Operator as Less Than, If you select the input value for Employee ID as 0012 the resultant output values will be, as given below.

      Employee ID (Input Field)Employee Name (Output Field)Employee Email (Output Field)Employee Phone Number (Output Field)
      0011Xing Longxing@gmail.com9876785432
      Case 5: Keeping the Conditional Operator as Greater Than or Equal To, If you select the input value for Employee ID as 0011 the resultant output values will be, as given below.

      Employee ID (Input Field)Employee Name (Output Field)Employee Email (Output Field)Employee Phone Number (Output Field)
      0011Xing Longxing@gmail.com9876785432
      0012Ramarama@gmail.com0989087654
      Case 6: Keeping the Conditional Operator as Less Than or Equal To, If you select the input value for Employee ID as 0012 the resultant output values will be, as given below.

      0011Xing Longxing@gmail.com9876785432
      0012Ramarama@gmail.com0989087654
      • Order By: Use this option to arrange the list of output values either in Ascending or Descending order. 

      NOTE
      The configuration option to decide whether the output values a list or single is available in the apps under Reference form field's settings. 



      Was this article helpful?