Query DataSource

Description:

Query DataSource

Use this action to perform a query on a data store. Use Query Paramchild to specifiy the filters.

If this action is defined inside Go To Page action, then use Source Query Param child to source the filters from the source page.

Allowed Parent Components:

  1. Trigger After Device Drag

  2. Trigger After Device Move

  3. Trigger Before Device Drag

  4. Trigger Before Device Move

  5. Action Group

  6. Action Search

  7. Add Connection

  8. Case

  9. Change Language

  10. Clear All Filters

  11. Clear DataSource

  12. Clear Grid Sort

  13. Confirm Message

  14. Copy StoreRecord

  15. Drag Drop Operation

  16. Duplicate Item

  17. Duplicate StoreRecord

  18. Eval And Execute Expression

  19. Export To Google Sheet

  20. Geo Location

  21. Go Back

  22. Go To First Record

  23. Go To Last Record

  24. Go To Next Record

  25. Go To Page

  26. Go To Previous Record

  27. Import Data

  28. Insert Record

  29. Invoke DataSource

  30. Loop

  31. Loop Records

  32. Multi Sheet Export

  33. Query DataSource

  34. Query DataSource From Aggregate

  35. Reduce

  36. Refresh DataSource

  37. Refresh Navigation Menu

  38. Register State

  39. Remove Connection

  40. Save DataSource

  41. Save Transaction

  42. Save Video Recording

  43. Server Validate

  44. Set As Current StoreRecord

  45. Start Video Recording

  46. Stop Video Recording

  47. Trigger After Delete Record

  48. Trigger After Drop

  49. Trigger After Insert StoreRecord

  50. Trigger After Popup Close

  51. Trigger After Popup Open

  52. Trigger After Query

  53. Trigger After Save

  54. Trigger After Save

  55. Trigger After Select Query

  56. Trigger After Update StoreRecord

  57. Trigger After Upload Attachment

  58. Trigger Before Create

  59. Trigger Before Delete StoreRecord

  60. Trigger Before Drop

  61. Trigger Before Edit Cell

  62. Trigger Before Insert StoreRecord

  63. Trigger Before Popup Close

  64. Trigger Before Popup Open

  65. Trigger Before Query

  66. Trigger Before Query

  67. Trigger Before Record Change

  68. Trigger Before Render

  69. Trigger Before Save

  70. Trigger Before Save

  71. Trigger Before Select Query

  72. Trigger Before Update StoreRecord

  73. Trigger Before Upload Attachment

  74. Trigger On Aggregate Click

  75. Trigger On Any Attribute Change

  76. Trigger On Attribute Change

  77. Trigger On Cell Click

  78. Trigger On Change

  79. Trigger On Click

  80. Trigger On DataStore State Change

  81. Trigger On Day Click

  82. Trigger On Device Click

  83. Trigger On Device Hover

  84. Trigger On Dismiss

  85. Trigger On Drag

  86. Trigger On Drag End

  87. Trigger On Drag Start

  88. Trigger On Drop

  89. Trigger On Enter Key Press

  90. Trigger On Event Click

  91. Trigger On Event Drop

  92. Trigger On Event Resize

  93. Trigger On First Visit

  94. Trigger On Key Press

  95. Trigger On Mouse Over

  96. Trigger On No Data Action Button Click

  97. Trigger On Page Active

  98. Trigger On Page Exit

  99. Trigger On Page Init

  100. Trigger On Page Switch

  101. Trigger On Record Active

  102. Trigger On Row Click

  103. Trigger On Row Selection Change

  104. Trigger On Scan

  105. Trigger On Tab Active

  106. TriggerOnCellDoubleClick

  107. TriggerOnRowDoubleClick

  108. Wait

  109. Wait For LOV

Allowed Child Components:

  1. Abort

  2. Abort If DataStore Is Empty

  3. Action Copy

  4. Action Download Attachment

  5. Action Group

  6. Action Search

  7. Add Breadcrumb Item

  8. Add Connection

  9. Add Smart Search Filters

  10. Change Language

  11. Choose Attachment

  12. Clear All Filters

  13. Clear All Query Params

  14. Clear All StoreRecord Messages

  15. Clear DataSource

  16. Clear Grid Sort

  17. Clear Query Param

  18. Clear Smart Search Filters

  19. Clear StoreRecord Message

  20. Confirm Message

  21. Copy StoreRecord

  22. Delete Current Record

  23. Delete Selected Records

  24. Deselect All Records

  25. Duplicate Item

  26. Duplicate StoreRecord

  27. Eval And Execute Expression

  28. Export Data

  29. Export To Google Sheet

  30. Geo Location

  31. Go Back

  32. Go To First Field

  33. Go To First Record

  34. Go To Item

  35. Go To Last Record

  36. Go To Next Record

  37. Go To Page

  38. Go To Previous Record

  39. Hide Item

  40. Hide Popup

  41. Import Data

  42. Insert Record

  43. Invoke DataSource

  44. Invoke Trigger

  45. Loop

  46. Loop Records

  47. Multi Sheet Export

  48. Open URL

  49. Order By Param

  50. Print Props To Console

  51. Print To Console

  52. Query DataSource

  53. Query Param

  54. Reduce

  55. Refresh DataSource

  56. Refresh Navigation Menu

  57. Register State

  58. Remove Connection

  59. Reset DataStore

  60. Reset StoreRecord

  61. Save DataSource

  62. Save Transaction

  63. Save Video Recording

  64. Select All Records

  65. Server Validate

  66. Set As Current StoreRecord

  67. Set Message On StoreRecord

  68. Show Item

  69. Show Message

  70. Show Popup

  71. Silent Sign Out

  72. Source Query Param

  73. Start Video Recording

  74. Stop Video Recording

  75. Switch

  76. Update Item Number Property

  77. Update Item String Property

  78. Update StoreRecord

  79. Wait

  80. Wait For LOV

Properties

➤ Enable Condition

Specify an expression that should be evaluated to a boolean [e.g. #{dsAlias.attr1} == 'X' && #{dsAlias.attr2} > 1]. If no expression is specified, it will be considered as true.

Allowed Values: An expression which should return boolean after evaluation

➤ Target Data Source Alias Type

Check Expression to specify a dynamic expression for the target DataSource Alias value

Allowed Values:

  1. Expression

  2. Static

➤ Target Data Source Alias

Choose the target data source alias

Allowed Values: Choose the target data source alias

➤ Target Data Source Alias Expression

Specify an expression for the target dataSource alias

Allowed Values: An expression which should return string after evaluation

➤ Force

Check this property to skip the data caching

Allowed Values: Yes/No

Last updated