Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. POProviding "Totals" for custom SQL queries on a regular basis
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USdani herrera
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COAren't views meant to be very static? At the moment we have a generic "Search function" which can be used by all our customers which all have different fields defined and while dynamic sp are not ideal, this is the only way we could handle all scenarios. What we want to achieve is create numerous "notification" icons which will display how many records match a specific search and display the total on an icon, so would a view still fall into that category? We definitely cannot have a view for every "notification" count icon scenario as this once again would greatly vary for all customers.
      singulars
      1. PO
      1. USThierry
    2. COYou can create a view with this structure: userID, count1, count2, count3, ..., count_n. With a create view user_counts as select userId, count( distinct ... ). Then map this view with an entity UserCounts and use the entity to display user Icons. For improve performance you can create a view for each icon but never a view for each user.
      singulars
      1. PO
      1. USdani herrera
    3. COI'll have to look into this further. It would definitely be a view for each icon rather than each user, but while not ideal, I'd still like to re-use our dynamic stored procedure which is responsible for our search but instead will return a count but I'm not sure about having a view with a dynamic sp in it?? Doesn't seem to make much sense. The only +, I guess is that the values in it would be hard-coded when calling the dynamic sp but it would only return the count rather than the actual result. I don't really know if it is a plus to be honest... as I said I'll have to look into it further.
      singulars
      1. PO
      1. USThierry
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload