which table contains debtor specific transactions

[JuiceyBrucey]

Hi, I need to do a query that gets all debtor specific transactions so that I can create an API method that returns all, or filtered types, of transactions.
Which table would I get them from?
Cheers

[Mike.Sheen]

Hi, I need to do a query that gets all debtor specific transactions so that I can create an API method that returns all, or filtered types, of transactions.
Which table would I get them from?
Cheers

DB_Trans is the table which contains all debtor transactions. But I wouldn't do that yourself manually - we've done the heavy lifting for you and have AutoQuery setup - you just need to add the route in your own custom plugin:

Code: Select all

AppHost.Routes.Add(typeof(DB_TransQuery), "/Queries/DB_Trans", "GET", "Retrieves a list of debtor transactions.", "");

requests to this route can specify what value of any column to filter on, so the request can specify a specific DebtorID.

If you want greater control, or don't trust the requestor to look at transactions for any debtor, you can do that also - explicitly inject a filter value - the UserSettingsGETManyRequest in the standard REST API plugin is a good example.

[JuiceyBrucey]

hI Mike, Thank you very much.
I discovered this Queries section yesterday and it has made things so much easier. I am going to use it for a lot of queries.
This means that the only time I need a custom route is when I need to do a table join or something a little bit more complex than just querying one table.
Thank you very much. Cheers

[JuiceyBrucey]

Hi Mike,
I take it you are referring to below. I am not that familiar with C# and this is a crash course for me.
Is there any examples of this being implemented?
#region "Services"
[CompressResponse]
public class UserSettingServices : Service
{
[Authenticate]
public void Post(UserSettingPOSTRequest request)
{
JiwaApplication.Manager manager = this.SessionAs<JiwaAuthUserSession>().Manager;
manager.JLib.SetProfileKey(manager.Staff.RecID, request.Section, request.IDKey, request.Contents);
}
public IAutoQueryDb AutoQuery { get; set; }
[Authenticate]
public object Get(UserSettingsGETManyRequest query)
{
JiwaApplication.Manager manager = this.SessionAs<JiwaAuthUserSession>().Manager;
var q = AutoQuery.CreateQuery(query, base.Request).Where(String.Format("UserID = '{0}'", manager.Staff.RecID));
return AutoQuery.Execute(query, q);
}
}
#endregion

Cheers

[Mike.Sheen]

I take it you are referring to below. I am not that familiar with C# and this is a crash course for me.

Yes, that is what I was referring to.

Is there any examples of this being implemented?

Ok, one of us must be missing something... because what you found and showed was an example of manually doing an AutoQuery with parameters injected.