menu
Logo
  • Why azing?
  • Blog
  • Help
ENarrow_drop_down
  • DE
  • EN
Suche in Checklisten
search
azing Logo ENarrow_drop_down
  • DE
  • EN
  • Why azing?
  • Help
2sxc
drive_folder_upload
  • homeChecklist Templates
  • south
  • fiber_manual_recordData - Use Tables, Queries and more
  • south

folder_sharedVisual Query

  • homeChecklist Templates
  • south
  • fiber_manual_recordData - Use Tables, Queries and more
  • south

folder_sharedVisual Query

Folders and checklists

  • check_circleVisual Query - Create
  • check_circleVisual Query - Parameterize using Params
  • check_circleVisual Query - Re-Use a Query with QueryRun

Parts (0) expand_more

These are small document-parts which are used in other documents. They are not a starting point for any real activity. Because of this, they will be listed further down and the search will not list them unless requested. 

Since 2sxc 10.23 (see blog) you can define Params to configure what the Query does. 

This recipe assumes you've already created a Visual Query and that you're in the edit-view of the Visual Query. 

  1. Define the List of Params with default values (assuming you have default values)
    1. Open the Query Configuration
    2. Write down each Param on each line using best-practices setting params
    3. Where possible also add a default value to the parameter default params
    4. Save
  2. Create Test-Values for your Params to enable testing
  3. Change your parts to use the params
    1. Open the part-configuration where you need it
    2. Set the Param there using [Params:Name]
  4. Run the query
  5. Adjust as needed
Logo
Legal | Content Copyright CC-BY 4.0
bug_reportReport Bug
  • info
  • Links
  • Permissions
code Share
code
URL copied to clipboard.
Embed Checklist close
Copy Copy
Content Copyright

CC-BY 4.0

Translations

None

2sxc - Content Management for DNN & Oqtane Logo

2sxc - Content Management for DNN & Oqtane

QR-Code
azing.org/2sxc/r/QGWvPJsr
View & Use

Public (can be used by everybody)

Edit & Admin

Default (all members can edit)

This catalog has a simple permission model, where all members have the same permissions. For advanced permissions, upgrade to Enterprise.

Here you can see how this document is used and linked by other documents

Used in (1)

Others referencing this

  1. Visual Query - Re-Use a Query with QueryRun
Uses these (6)

Documents linked from this document

  1. Visual Query - Create
  2. Visual Query - Configuration - Open from Designer
  3. Visual Query - Params - Best Practices
  4. Visual Query - Params - Default Values
  5. Visual Query - Test Parameters
  6. Visual Query - Parts - Configure
How it Behaves

How this document is categorized changes how it behaves.

This is a main document, it is listed normally and appears in search result.

Type

This is a Checklist. Lists are converted into checkboxes.

Get something to say?

Comment to start a discussion or make a note
send

please log on to chat

close

Durchsuche ganz Azing