rladha

Just a thought, Template > Relationship screen there is an option for WHERE clause, can you try there.

Thanks, Peter.

– Yes, I am able to create Trigger to capture the update Timestamp, and already doing that on few tables.
– The gap I am finding is, how to capture the WP_Use name and save in the table during the UPDATE.
– I would also suggest, if you can explore my above suggestion (checkbox in the template screen)

Happy to provide more detail and happy to assist in testing too.

I believe this feature will be helpful for many users who are trying to build CRUD screen using WPDA.

Rahim

Hi Peter,

Is the fixed part of the latest released?

Hi Rahim,

Thank for your explanation. ?? I see the problem! The search panes query is not taking the default where clause into account. Good point! I will add it. Hope you have it after the next update.

Thank you for your contribution,
Peter

Rahim

1. I found the way to add WHERE Clause in Publication it is working.
2. But, I am finding, Search Panes (Under Premium Extension) doesn’t not take in account the WHERE Clause.

Example:
1. I have a list of Cities (TORONTO, MONTREAL, OTTAWA, VANCOUVER)
2. Add a WHERE CLAUSE CITY IN (SELECT DISTINCT CITY FROM X WHERE USER_NAME = ‘$$USER$$’)
2. USER_1 belongs to TORONTO
3. In Tables, WHERE CAUSED applied, only TORONTO is listed
4. But in Search Panes of Cities, it is listing all the CITIES (which should also show TORONTO.

My application is behind the login, and would like to display data as per user’s permission.

I hope above make sense.

Rahim

Proud support of this plug-in and re-newal owner of this Premium Plugins.

Addition: I would like to use $$USER$$ when displaying data in Publication.

I am interested too!

My use case:

DropDown 1: Category
DropDown 2: Product

Only display list of Products in DropDown 2 that are related to Category selected in DropDown 1.

I hope this helps.

Rahim

Thanks, Peter. you can close this ticket.

FYI: Using this plug-in, I am able to see the backend queries generated by WPDA… https://en-ca.www.ads-software.com/plugins/query-monitor/

I need to research if this data can be stored in the table, then it will solve my ask..

others have created further add-ons to this plug, perhaps, WPDA can also consider it… https://github.com/johnbillion/query-monitor/wiki/Query-Monitor-Add-on-Plugins

Thanks, @peterschulznl

1. Let me look into to above suggestion. Currently, my app tables with missed with wordpress tables.
2. Is there a log table in WP which keeps track for every SQL execution by all plug-ins? Perhaps, I can use that?

Thanks again, let me dive deeper as this scenario is important for my application.

R

Thanks, @peterschulznl and @charlesgodwin

@peterschulznl – I believe, Javascript is the approach because the record is still not saved!

If you can share a sample or example – I willing to give it a try.

thanks again — love this plug-in!!

Rahim

For this scenario, I would like today’s date as a default value.

Btw, I noticed— calendar widget only shows up for dates/time field not for date field – true?

Hello Irydant,

I can try to help.

I am working on a similar situation — have you installed WPDA sample app? https://wpdataaccess.com/demos/demos-apps/school-administration-system/

If yes, then follow the process for Teachers menu.

I believe, you will be able to manage this under the Template Project > [table screen’s edit menu] > List Table and Data Entry sub tabs.

Give it a try.

Regards

Rahim

Thanks @peterschulznl

In principle it make sense. Let me give it a try.

Thanks again, keep up the good work!

I will look into Code Manager https://www.ads-software.com/plugins/code-manager/

Rahim