Hi ,
I am trying to get all the account for the user through webservices but I get only 3 of them if the user has 20+ distinct accounts.
if I try to use user table there is a problem with display function .
is there a way to call the DD webservice from the table "
Could you give us an example of the WebService URL you are using? Are you specifying any value for returnMaxRows in the request?
I tested this in-house and it seems to be working. Maybe try adding the following parameter in case you have different case characters: &ignoreCase=true
NO ,its not working..
There are many accounts are available for the user but through drop down it displays only 3 accounts
please find the attached screenshot.
I think I know why, I think there is a miss understanding here. When you add employee_id=${XXX} this will not get you all accounts for a certain user. This means that you have an account attribute called employee_id and it will filter all accounts that have that account attribute set to your variable.
In other words, the user may have 20 accounts, but looks like only 3 of those accounts have the account attribute employee_id = your variable.
findAccounts command runs the query against PV_ACCOUNT view.. Are more rows returned if you run your query directly against this view?
Right I am not finding all accounts on the table
But I feel why this is not showing all the accounts in the table for the user.
is there any way to display all accounts using DD webservice .
I use 'user to account table ' in the form but there is a problem with display condition
Hi Durga, in this case the better option is to use the findUserAccountMappings webservice to get the results you want.
findUserAccountMappings
Purpose
The findUserAccountMappings command is used to find relationships between users and accounts. The command uses the PV_USER_ACCOUNT_MAPPING public view to find data. Any filters passed should be passed on this public view.
Input Parameters
The command expects the following parameters where a * denotes a required parameter:
- format: The format to return the data in (default = properties)
- properties: key=value. most useful when requesting a single object. If multiple objects are returned, values is a csv. ie key=value1,value2,value3 where value1 is the value for the first object, value2 is the value for the 2nd object, etc
- csv: Comma separated values
- tsv: Tab separated values
- xml
- json: Useful format for parsing into javascript or other languages. See www.json.org for details.
- delimiter: The delimiter to use between values for CSV & Properties formats
- returnColumns: The names of the columns to return (details below). returnColumns may be a CSV list of multiple column names. The returnColumns parameter may also be listed multiple times (ie returnColumns=col1,col2&returnColumns=col3,col4)
- returnMaxRows: The maximum number of objects to return
- distinct: When "distinct=true", return only distinct values. This is equivalent to the distinct keyword in SQL.
- sortByColumns: The results will be sorted based on the columns listed using comma as the delimiter if multiple columns are specified.
- sortDirection: This determines sorting order. When defined as 'asc' the sorting is in ascending order else in 'desc' descending order. If this parameter is not specified, the natural order of rows returned by database is used.
- includeHeaderRow : Column headers are included in the return output if set to true (default). This parameter only has an effect when the return form is csv or tsv.
- token - Session token, retrieved from loginUser. This token must be valid, unexpired, and for a user with system administrator privileges.
- ignoreCase - When "ignoreCase=true", return case insensitive search result for specified filter parameters.
- creation_date
- adc_id
- user_id
- remove_state
- deletion_date
- is_deleted_user
- account_id
- state
- created_by
- deleted_by
- add_state
- comments
- last_reviewed_date
Output Parameters
The command returns the requested returnColumns as output defaulting to names if no returnColumns is specified:
Filter Parameters
Additional parameters may be specified to filter results based on specific values. For example, to filter rows that have id=7, add "&id=7" to the URL. If a filter parameter exists multiple times, objects having any of the given values will be returned. This is equivalent to the SQL clause "AND id IN (value1,value2)".
If multiple filter parameters are specified, only objects matching all criteria will be returned. For example, to return objects that have both id=7 and group=34, add "&id=7&group=34" to the URL. To return objects that have id of either 7 or 8, and group of either 35 or 35, add "&id=7&id=8&group=34&group=35" to the URL. This is the equivalent of the SQL clause "AND id IN (7,8) AND group IN (34,35)".
Security
This command can be accessed from any of the IP addresses on the allowed list or by including a valid session token as an input parameter.
Could it be a problem related to the delimiter? May you try to have tsv (tab separated value) as format?
Could it be a problem related to the delimiter? May you try to have tsv (tab separated value) as format?