x Want to participate? Join the group to interact

  • Using SQL Function in SQL Requester

    Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB. I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text. This works fine in SQL, but when I try in the SQL Requester…

  • Linking to ATABDIV (misc tables) in Graphical Query

    Has anyone ever done that? Looking to bring in the descriptions for the stat groups in ITMMASTER. And other places.

  • Adding a newly built requester to dashboard

    Hi, I have built some new requesters which I would like to add onto the dashboard screen, but I cannot see how to add these to the dashboard. When i click 'add>requesters' i am only presented with the default options - my new requesters are not available…

  • Requester by current user

    Hi guys, quick question about how to setup a requester filtering by the current user. I've created a simple requester and set the criteria to filter the table by GUSER. That works in the Request function but as soon I link that to a dashboard as menu…

  • RE: How to add an 'or' for criteria (SQL)

    Hi Israel, Sorry to bother you again, but I have yet another question. I'm trying to do as you've shown me for search criteria, but I seem to be running into a small issue. I have 2 fields that are joined. I have the following query: SELECT F.ITMREF_0…

  • SQL Requestor - WHERE clause for negative amounts

    Does anyone know how to create a where clause in SQL such that For a given column (which has both negative and positive amounts), it only shows the positive amounts (or shows all negative numbers as 0.00)? I have tried, but to no avail. The expression…

  • Is there a way to SUM UP Values from two different levels?

    Ex. Summing values of a column in LEVEL1 such that you can get "Values of Column A" (which is in level 2) - "SUM of values of Column B" (level 1 detail) - See my picture for bet Is there a way to convert all "blank" fields in a requestor to 0.00 (or…

*Community Hub is the new name for Sage City